High-availability technologies mask the effects of hardware or software failure, so that perceived downtime for users and applications is minimized.

learn more… | top users | synonyms (1)

4
votes
2answers
3k views

PgPool 2 with HA Proxy

So, I'm looking to add high availability to a postgresql server. I've looked into some tutorials on the web but, haven't been able to find exactly what I'm looking for. E.g.: PostgreSQL ...
3
votes
2answers
2k views

Removing secondary replica from SQL Availability Group causes large log file

Due to an unforeseen hardware error, I had to take our secondary replicas down for maintenance. This was really due to a storage issue and, it was decided at a higher level, to purchase a new storage ...
1
vote
2answers
108 views

Maintain Up-To-Date Copy of Very Large Table if Clustering/Partitioning/Moving Operation Needs to be Killed/Rollback

I've appended the following information in a previous post but I asked the 'why' instead of the 'how'. So here's the question... SQL Server 2014, CU6. 4.5 TB database, Simple recovery. The most ...
0
votes
2answers
76 views

Avoid user login Directly to AlwaysOn High Availability Primary

I have setup an AlwaysOn High Availability in Sql Server 2014. my IP addresses are according to this : 192.168.1.189 -- Listener 192.168.1.180 -- Replica 192.168.1.181 -- Primary Right now users ...
4
votes
1answer
64 views

SQL Server - Company wants HA for single instance with 1 userDB - sanity check and questions

I am new to SQL Server (2 months) and learning at a gov company (europe). The job is to make a HA solution for this 1 productive instance (1 database). Following is given SQL Server 2012 Windows ...
2
votes
1answer
96 views

SQL AlwaysOn & System Center Configuration Manager TP 4 1601

Recently Microsoft released Technical Preview 4 for Configuration Manager (1601). Per TechNet, "Configuration Manager now supports using a SQL Server AlwaysOn availability groups to host the site ...
2
votes
1answer
1k views

Reporting services - High availability setup - SQL server 2012

I need some guidance on best practices and setup for SSRS. I have a SQLServer 2012 setup with data source on 1 instance and SSRS on a separate server. There is a need to setup HA and I understand what ...
1
vote
1answer
25 views

Setting up HA and a synced up reporting box all together using SQL Server 2014 Standard Edition

Scenario: We are going to upgrade our third party application. Also we are going to upgrade our DBMS from SQL Server 2008 R2 to SQL Server 2014 Standard edition. We also wanted to have a high ...
1
vote
1answer
71 views

High Availability for MariaDB and Postgres : replication or active-passive (SAN)

During the last weeks I did a lot of research on High Availability for Postgres and MariaDB. Both by my own research and also recommended by vendor's, replications seems to have more advantages. Some ...
0
votes
1answer
27 views

MySQL: 3 servers on-site architecture

I have 3 servers with RHEL 6 OS and Percona server running in one of the servers in the same data centre, while the other 2 servers lie idle. Now I need to implement some kind of on-site redundancy (...
0
votes
1answer
26 views

When you use a replica to backup from so you don't have to turn off the master, is this considered High Availablity?

I read somewhere that MySQL can have a master / slave setup in which the master database can continue to run live and in production while the slave database can be turned off to snatch a backup. And ...
0
votes
1answer
83 views

SQL database disaster recovery in a second datacenter using storage

I have the following: Data Center (1) has a set of two Microsoft SQL Server databases. They are clustered using MSCS and shared NetApp storage FAS3250 system. This provides me with local fail-over / ...
6
votes
0answers
110 views

Low performance, high availability, replicated key/value store with audit trail

I'm looking for a database system with fairly specific specs. I've looked most of the major relational databases and NoSQL products out there and did not find one that even remotely satisfied my ...
4
votes
0answers
214 views

ENABLE_BROKER vs NORECOVERY

I have two nodes with MSSQL2012 which work with AlwaysOn High Availability After some crash I had to remove db from availability group on the one of the nodes. For restoration I've made backup (full+...
3
votes
0answers
244 views

AlwaysOn FCI + HA Setup Question

I am planning to create FCI + HA solution in the same datacenter, but running into some problems. I'd really appreciate if someone can provide some guidance. Here is the current configuration (All ...
3
votes
0answers
909 views

SQL Server Database Mirroring : strange client application behavior upon failover

I am putting a HA SQL server environment up based on three SQL Server 2008 R2 machines and database mirroring. I'll name them : principal.company.intra mirror.company.intra witness.company.intra ...
2
votes
0answers
26 views

Asynchronous Availability Group Secondary Verify Up To Date with Primary Before Backup

I was wondering if there was a way to include a verification step before a backup on a secondary replica under asynchronous commit mode in availability groups to verify that the secondary replica is ...
2
votes
0answers
38 views

Alwayson cannot fail over using tsql

I have an Alwayson test environment with the following settings. My test goals are as follows: When SqlNod1 is primary instance, I want SqlNod2 to answer read-only queries. When SqlNod2 is primary ...
2
votes
0answers
3k views

High availability PostgreSQL 9.3 server on Windows

I'm trying to set up PostgreSQL 9.3 server in HA mode on 2 Windows servers. Final solution should be deployed to Microsoft azure network, so there are few limitations. Since Microsoft is doing ...
2
votes
0answers
351 views

dropping and adding subscription only picking up new article on some subscribers

I have used the following script to drop aand re-add a table from a subscription so I could move replace the ntext fields with nvarchar(max) columns. the script worked fine, but when I ran the ...
2
votes
0answers
2k views

SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled

I have two SQL Server instances in an availability group. They are not mirrored. I'm trying to connect to the AG using the MS JDBC drivers (4.0) with a connection string including multiSubnetFailover=...
1
vote
0answers
49 views

Quorum Questions For An FCI And AlwaysOn in a WSFC

I was reading the white paper on FCI + AlwaysOn as well as several other resources on quorum voting differences in Windows Server 2008 and 2014 and had 3 questions. 1- Will giving a node in the ...
1
vote
0answers
29 views

Synchronization report for uncontained objects across each of the replicas in HAG

I have seen How to transfer logins and passwords between instances of SQL Server , Synchronize Availability Group Logins and Jobs and SQL Server 2012 Availability Group Add-in to synchronize ...
1
vote
0answers
20 views

Replicating data from SQL Server 2014 to SQL Server 2005 - temporary solution

I will be installing a new SQL Server 2014 database system, which is based on our current SQL Server 2005 database system. The new system will be on a completely new infrastructure when we go live, ...
1
vote
0answers
67 views

IP from a different subnet is registered even after node and resource were removed

We run two SQL server at primary site in AlwaysOn High Availability Group on subnet 10.10.0.0/24 A third SQL server is running on secondary site in a different subnet 10.10.1.0/24 We have had third ...
1
vote
0answers
159 views

how to get pgpool2 HA

I am using pgpool2 and PostgreSQL to get a HA of postgresql service. I have been working in this: .-----. .--------. | | W | DB | | PGP |-----+-----------...
1
vote
0answers
44 views

Windows Clustering 2008 R2

I'm trying to build a Windows cluster with 3 nodes, 2 Active and 1 Passive, And If I have to build in a way like N1 Active - N3 Passive will be refer as "cluster network 1" and N2 Active and N3 ...
1
vote
0answers
369 views

High Availability in PostgreSQL with automated failover

I am currently working on designing an architecture for High Availability in PostgreSQL for a database of approximately 5TB in size. Also, I would like to re-direct my reads to a slave node(preferably ...
0
votes
0answers
20 views

SQL Server 2012 Availability Group (with Synchronous & Asynchronous Replicas)

I have an AG set up in SQL 2012 (sp3), where I have 2 replicas (with synchronous commit & automatic failover) which works very well. When I try to add a 3rd replica (for DR purpose, with ...
0
votes
0answers
6 views

Pgpool2 connection pooling

I have installed both PGPOOL2 3.3 and Postgresql 9.3 db(master) on the same server and in the pgpool.conf file have given the connection parameters as: num_init_children = 100 max_pool = 2 Therefore ...
0
votes
0answers
22 views

Quorum Drive needed?

Do I need a quorum drive for configuring Always On on SQL Server 2014? I am sure it is not mandatory as the 'last man standing' concept is based on node and disk majority. But I need a little more ...
0
votes
0answers
98 views

Which pgpool “mode” for high availability & failover on Postgresql 9.3

I'm in the process of designing a HA setup for a web API & application that uses Postgresql 9.3. To satisfy availability & resiliency, we require: failover to a secondary database instance ...
0
votes
0answers
90 views

Simple/Easy PostgreSQL HA multi-master for high latency / unreliable network

I have an environment consisting of two servers running JBOSS and PostgreSQL. Each server writes to its own database and programmaticly synchronises some data to the other database. This causes ...
0
votes
0answers
356 views

pgpoolAdmin for pgpool-II 3.4 : superuser: unknown (Connection error)

I cannot start/stop/reload my nodes through pgpoolAdmin and it says "superuser: unknown" even though I'm logged with the postgres account. What could be the cause? pgpool.conf is identical to another ...
0
votes
0answers
22 views

Create db2 alert for automatic failover

We have two servers in automated failover HADR (TSA installed and haicu configured). How can we create an alert that fires when a failover happens i.e. when the primary server goes down and the ...
0
votes
0answers
18 views

HA options for Standard SQL2008

Running SQL 2008 standard with our pants down, no mirror (shut off due to performance hits) shipping logs but that is not going to be good enough. I want an HA option that works. With dual node ...
0
votes
0answers
47 views

Why does my SQL Server HAG fail from PRIMARY to RESOLVING and back again?

I recently noticed our SQL Server High Availability Groups failed from the PRIMARY to the RESOLVING state, and then from RESOLVING to the PRIMARY state, without failing to the SECONDARY state. Does ...
0
votes
0answers
88 views

Problem Setting up MariaDB Spider HA

I have problem setting MariaDB with Spider for partitioning and HA.My environment consists of: Spider Proxy - 10.64.20.207 Backend1 - 10.64.20.208 Backend2 - 10.64.20.209 First I am creating user ...
0
votes
0answers
424 views

Couldn't setup postgresql cluster with heartbeat pgsql ra

I'm trying to install postgresql cluster with the following configuration: 2 virtual hosts with RHEL 6.6 x64: postgresql 9.1 with hot standby replication pacemaker 1.1.12 resource-agents 3.9.6 I ...
0
votes
0answers
38 views

Can two databases share one data folder?

I'm planning to install a database (same configuration) on two separate machines, PC1 and PC2. PC1 is the main database while PC2 is the backup.. Is it possible that they can have the same datadir in ...
0
votes
0answers
62 views

Fencing a failed application node to isolate it from SQL Server

I have a multi-node server application that is backed by SQL Server 2012, often in a clustered or AlwaysOn AG/FCI HA configuration. My application monitors the health of the application nodes (not the ...
0
votes
0answers
48 views

Need a High available for Database : HA clustering vs failover with mysql utilities

I intend to setup a high available for database system, I have 2 solutions here : Set up a HA clustering with heartbeat and share storage for 2 nodes as master(to storage the configuration and data ...
0
votes
0answers
644 views

Configuring multiple listeners on SQL Server 2012 through High Availability

We have configured two SQL servers on Azure and they are in HA. There are about 10 databases and we wanted to have two critical ones on one dedicated HA group. The listener worked fine until we ...
0
votes
0answers
174 views

Recommended plan for 0min RTO and RPO

I have a Windows Server 2008R2 Server, running SQL Server 2008R2 SP2. The server currently only does a full backup once daily. The server's operational hours are between 8am and 5pm. The server's new ...
0
votes
0answers
252 views

Streaming Replication Resource Management (PGSQL) on FreeBSD 8.x

I am attempting to set up PGSQL-HA streaming replication on freeBSD 8.2 (willing to upgrade to 8.4 if need be). The set up is simple: 2 nodes, one active one standby. I have successfully set up ...
0
votes
0answers
137 views

Synchronization between master and backup server

I am searching for an option to synchronize data between production server and backup server automatically. Does somebody know a method, how I can do this: if I delete, insert or update a record it ...
0
votes
0answers
223 views

How to setup a Postgres-xc streaming replication with master-slave(for HA)?

Can you guys please help me about how to make streaming replication with master-slave configuration using Postgres-xc to confirm an HA environment? Thanks