Failover is the concept of moving services from one host or node to another in order to provide high availability in a computing system.

learn more… | top users | synonyms

3
votes
4answers
1k views

Avoiding MySQL Fabric to become a single point of failure

I managed to install and configure MySQL Fabric that manages multiple MySQL Server nodes. It works very well since I tested it by connecting to the Master node directly and played with the data (...
4
votes
1answer
236 views

Replication throw an error after failover mirror partner is down in SQL Server

Received an error mentioned below after failover when mirror partner is down. Error : to fail over to a database which is not configured for database mirroring. code: 22037, text: 'Invalid ...
1
vote
1answer
831 views

pgpool-II doesn't execute my failover script

I have been installed pgpool-II 3.3.4 from source. I have two pgpool nodes and I also used the watchdog configuration to get a pgpool services with High Availability. When I stop one, the other wake ...
1
vote
1answer
834 views

MySQL failover - Master to Master Replication

My company is trying to implement a MySQL failover mechanism, to achieve higher availability in our webservices tier - we commercialize a SaaS solution. To that end we have some low-end VMs scattered ...
2
votes
1answer
125 views

Availability Groups - Can async replica delay failover of sync replica?

Availability Groups SQL Server 2012. Node 1 and Node 2 in primary data centre - sync mode for HA Node 3 in dr data centre - async mode for DR If a manual failover is performed between node 1 and ...
0
votes
0answers
21 views

Combining SQL Failover cluster with availability groups and SAN replication

We are looking at implementing the following Windows cluster containing 4 node FCI (2 nodes per data centre) with SAN replication - our current setup. manual failover (storage first then SQL resource)...
0
votes
1answer
43 views

Automatic recovery on a 3 node AlwaysOn Multisite Cluster?

We are looking to build a 3-node AlwaysOn Windows 2012 R2 failover cluster with 2 nodes in our primary datacenter for HA, and a 3rd node replica in our DR datacenter for reporting. Given this is a ...
1
vote
0answers
39 views

SQL Server 2012 failover cluster node won't start cluster services

We have 2 node SQL server failover cluster setup in our environment. Node2 SQL server machine got shut down. I turned it back on and connect back to the failover cluster. It successfuly connected ...
0
votes
1answer
62 views

Failed to create, join or add replica to availability group in SQL Server 2014

I have a 2 node FCI and a standalone SQL Server installation on a non FCI node. I have been automating the configuration/installation of FCIs, AGs, and DB Replicas which has worked fine up to now in ...
-1
votes
1answer
37 views

SQL Server mirroring / failover alternative [closed]

I am looking at building at reliable database with Microsoft SQL Server, with mirroring and automatic failover. The SQL Server here is standard version, not enterprise one so High Availability ...
1
vote
1answer
270 views

SQL Server 2012 Cluster Service pack 3 fail to failover node

Roughly a year ago, i had this problem with an 2008R2 cluster. I asked about it here, but i didn't grab enough logs in the process. And now i have the same problem on my 2012 failover cluster. So i'm ...
0
votes
1answer
67 views

SQL Server 2012 on a Windows 2008 R2 cluster, would like to upgrade Windows to 2012 R2

I need someone to help validate a strategy. I have a pair of Windows 2008 R2 server in a active/passive failover cluster with SQL Server 2012 installed. I would like to upgrade the Windows OS to ...
5
votes
1answer
55 views

Understanding of SQL Server active/active cluster

I have a vague understanding of SQL Server's active/active cluster. Can anyone help to confirm if my understanding is correct? As I understand, active/active cluster use two or more Windows servers. ...
1
vote
1answer
96 views

Linked server to Availability Group Listener - is anyone successfully using one?

I edited the question hoping to check the basic stuff first. Does anyone have linked servers that successfully work with Availability Group listener? Have anyone heard of problems with linked servers?...
1
vote
1answer
19 views

Scenario to automate the promotion of a read replica when the master db is not responding

I would like to set a scenario like the following: Set an RDS event subscription [that the MySQL is unresponsive] that will publish to an SNS topic that will trigger a Lambda function which will ...
3
votes
2answers
52 views

Slave DB promoted as Master DB when Master DB is down. New data added on the new master while old master is down

I am currently setting up a call center system (Vicidial) having a Master DB and a Slave DB. When the Master would go down, I have made a script on the SlaveDB that would execute "stop slave" on the ...
1
vote
1answer
75 views

patching SQL Server with Availability Group and Secondary Replica

Scenario: SQL Server 2014 CU6. 1 AG with 2 databases (compatibility level 100). Failover Cluster with 3 nodes on Windows Server 2012 R2. Primary Availability Replica on node 1 and node 2. Secondary ...
0
votes
1answer
71 views

SQL 2012 Availability Group issue - The core cluster resources do not move when we initiate AG fail-over

I have a Windows 2012R2 cluster with two nodes and a File Share quorum. I am running SQL 2012 SP2 and I have configured a test AG with a dummy database. When I fail-over the AG, the Availability ...
1
vote
0answers
30 views

Firewall Rules, ip address failover cluster

We are having issues with some applications running and connecting to a failover cluster through a firewall(no windows firewall). In the firewall settings we configure the ip addresses from the ...
1
vote
0answers
77 views

Why switch? [ReplicationExecutor] another primary seen with election time xxx:1 my election time is yyy:1

On 09-05-16 - 08:41:51 Replica Set elected a new primary. The question why? Here the logs from this time series and without login messages egrep -v 'NETWORK|ACCESS'. On the same OpenStack platform ...
2
votes
1answer
281 views

Adding a distributor for availability groups

According to this MSDN article, I need to add a distributor: Configure Replication for AlwaysOn Availability Groups (SQL Server) I'm confused by this particular statement: The distributor should ...
0
votes
1answer
25 views

Should a Sql Server be accessible through the service's virtual network name?

In a working SQL-Server failover cluster environment I can open a SQL-Server connection using the configured service's IP address independantly of the current node it is on. I wonder if the assigned ...
2
votes
1answer
58 views

Sql Server Cluster with multiple nodes

Does it make sense to think about a failover cluster configuration where less than 50% of all included nodes are standby? For example instead of setting up 4 clusters with two nodes each where one is ...
10
votes
2answers
1k views

If I fail over one database, do the others that share the same mirror endpoint fail over as well?

We have two databases setup for mirroring on a single SQL Server instance: a test database and a production database. Both get mirrored to another server using the exact same endpoints. If I go into ...
3
votes
1answer
284 views

Manual Failover with AlwaysOn availability group

We are planning to upgrade our SQL 2012 to SQL 2014. We currently use a mirror for our production databases but are planning to move to availability groups. We are going to be running 2 SQL Servers on ...
2
votes
0answers
72 views

SQL 2014 Availability Group Cluster or Listener

We recently deployed a setup of SQL 2014 availability groups and we are having some difficulty with the failover. Setup: Two windows server 2012R2 VMs in a windows cluster with a CNAME pointed at ...
0
votes
1answer
71 views

Windows cluster failed over, but SQL instances didn't move

I recently inherited a SQL Cluster (2008R2) which for the most part behaves itself impeccably. The windows cluster is made up of two nodes running Active/Passive, Node1 and Node2 are dedicated ...
6
votes
3answers
2k views

Is MSDTC required for SQL Server 2012 Fail Over Cluster?

I am making a 2 node SQL Server 2012 Failover Cluster; do I need to install the MSDTC component? If yes, can both be installed on single shared disk?
0
votes
0answers
68 views

Install SP4 on SQL Server 2008 SP3 - named clustered instance MQ and PQ in A/A configuration on two Nodes A and B

Current config - We have two named instances called MQ and PQ which are clustered in A/A configuration on two nodes A (for PQ) and B (for MQ). MQ and PQ instances/features on both nodes A and B are ...
1
vote
0answers
37 views

Manually specifying candidate masters in Maxscale

Looking over the documentation, I haven't quite been able to find if its possible to manually set the candidate master status of a server in Maxscale. The reason I am looking for this is because some ...
1
vote
1answer
57 views

MaxScale not correctly recognizing new topology when we failover to a new master

So I currently have an architecture where we have one master and one slave and read/write splitting in Maxscale. When we fail the slave, Maxscale correctly recognizes it and displays the information ...
3
votes
0answers
2k views

MS SQL Server 2012 Failover Cluster connection issue

I was about to give up with this but I'll give it a go here if anyone can help. I've set up a fail-over cluster SQL Server with 2 SQL nodes, Domain controller and file witness. All seems to work fine,...
1
vote
2answers
128 views

Remove a node from Failover Cluster

We had 5 SQL Server 2012 servers configured with AlwaysOn. A few days ago we dismissed 2 of them, we removed them from the availability group and then stopped SQL services. We need to reuse these ...
2
votes
1answer
185 views

Can I get pg_rewind to show me lost data after a Postgres failover?

Say I have Postgres setup with a warm standby using the build in replication features. Now, imagine a scenario where the data centre the master loses power and the slave is in another data centre and ...
35
votes
4answers
22k views

Clustering vs. transactional replication vs. availability groups

Assuming you need to make sure your application that relies on SQL Server 2012 as its database backend is available around the clock, even if one server machine fails. As a developer and not a DBA, I ...
3
votes
1answer
86 views

Can SQL Server 2012 FCI have multiple names?

Is it possible to have multiple names for the same SQL Server Failover Cluster Instance (virtual server)? IT has a naming convention they like, but it hard codes the Windows cluster name into the SQL ...
0
votes
1answer
53 views

Mixing Clustered Instance and Non-Clustered Instance

I'm currently managing a 2 node SQL Server Failover Cluster in Active/Passive setup. I plan on adding a new SQL Server instance which doesn't have to be on the Failover Cluster. The only documentation ...
6
votes
2answers
182 views

Force a Member to Become Primary in mongodb

I looked into answers but nothing works for me in mongo 2.6.11 cluster 'nms' (members nms01m and nms02) below. I want my current secondary nms01m to become primary, and now nms02 is primary instead of ...
3
votes
1answer
101 views

Force a Member to Become Primary when Primary fails in mobgodb

I have mongodb 2.6.11 cluster of two members: nms02 and nms01m. I know how to force secondary to become primary when primary is avail. But now my primary nms02 failed..and nms01m is secondary...How I ...
1
vote
1answer
355 views

SQL Server failover cluster installation fails on primary node

I'm trying to install SQL Server 2014 fail-over cluster, but the installation fails with following log i have tried a lot of things but without any success.. The installation failed with following ...
1
vote
0answers
158 views

Is is possible to convert SQL Server from single instance to failover clustered node?

If SQL Server 2014 Enterprise has already been installed, can it still be converted/added to a failover cluster? Specific scenario - Amazon EC2 instance of Windows 2012 + SQL Server 2014 (license ...
2
votes
1answer
162 views

Change port number for SQL 2012 Cluster

I have been trying to change the port number of a SQL 2012 cluster with little success. I had thought that I could just do this the same way as normal through configuration manager however, even with ...
0
votes
1answer
57 views

SQL Server - How does Always On in a shared nothing config maintain transaction durability during a failover?

I've been reading up on Always On, and I was wondering how transactional durability is maintained during a failover when using a shared nothing configuration. The only things I can find on google ...
1
vote
2answers
126 views

Would SQL Server in a Cluster failover if it is running out of RAM

I have a SQL Server 2008 R2 in a Cluster in an active-passive mode. The server is running out of RAM (both physical and pagefile). In the instance level settings there is not Max RAM set (set to the ...
0
votes
0answers
30 views

PGBouncer pausing hanging from ltm monitor

Currently I have the following setup: F5LTM --> PGBx2 --> DBx3 The PGBouncers are set up with priority groups on the F5 so in the event one fails or hangs traffic will still be sent to the database ...
-1
votes
1answer
67 views

What are the typical errors that cause sql server to failover in a cluster [closed]

I have a two-nodes cluster with active-passive applied for a single instance of SQL Server 2008 R2. What would be the typical reasons the instance will fail over to the passive node?
0
votes
1answer
206 views

SQL Server does not failback to the primary node

We are running SQL Server 2008 R2 on a Windows Server 2008 R2 two-node cluster. My choice of machine is primary, and the secondary is just a low-end machine for contingency planing. We had a ...
5
votes
2answers
197 views

MySQL InnoDB over a Raw Device in an Active/Passive topology

We have an Active/Passive topology where there are two x86 complexes with a shared raw storage, where only one of the nodes in a given moment has an access to the shared storage (AKA the active node). ...
2
votes
1answer
294 views

SQL Server 2012 Always On Setup with two nodes

I have AlwaysOn setup with two data nodes and one witness. I faced an issue where my PRIMARY Server restarted abruptly. Here're some issues I faced during this timeframe. Due to abrupt restart of ...
2
votes
1answer
1k views

How do I configure AWS Aurora to separate write/read operations

I want to migrate my database instance from AWS RDS MySQL to Aurora, but I have a doubt about replication and how Aurora management the write/read operations. I have my application and I want to ...