Questions tagged [failover]
Failover is the concept of moving services from one host or node to another in order to provide high availability in a computing system.
364
questions
0
votes
0
answers
26
views
Always-On listener not working correctly
I have an Always-On architecture with two nodes and two AG. One of AG working correctly but other AG's listener only directs to the primary node. When I fail it to the secondary node, the application ...
- 42
5
votes
1
answer
511
views
Mysqlfailover command - No slave is listed in health status
I have successfully created replication using GTID_MODE. It works perfectly. Now I need to setup automatic failover feature in it. I have run the following command.
mysqlfailover --master=root:abc@10....
CommunityBot
- 1
2
votes
1
answer
2k
views
Repmgr: Error to promote Standby Cluster to Master Cluster in failover
I maked the configuration of the failover system based in Repmgr, but i don't haved success to promote the Standby Cluster to Master Cluster in case of failover.
Following my configurations, this ...
CommunityBot
- 1
0
votes
0
answers
25
views
How to check with TSQL if I'm connected to an Azure Managed Instance in a Failover Group?
How can I check with TSQL if I am connected to an Azure Managed Instance that's in a Failover Group?
For Always-On we can use this:
SELECT SERVERPROPERTY('IsHadrEnabled')
But in the case of Azure ...
- 628
0
votes
0
answers
60
views
Failed to start patroni
I am trying to configure patroni and etcd. Etcd is working fine, but patroni is failing to start. I have 3 servers, I have installed patroni and etcd on each server. When I try to start patroni on ...
3
votes
1
answer
402
views
SQL Server 2014 Availability Group failed
I have 3 servers on VMware workstation:
Win 2012 R2 as ADDC -Cluster service.
Win 2012 R2 as SQL server primary replica .
Win 2012 R2 as SQL server secondary replica (auto fail-over).
My ...
CommunityBot
- 1
0
votes
0
answers
97
views
WSFC - Unable to set node weight in Failover cluster
I have a two node Windows failover cluster configured with Always on availability groups which are configured for disaster recovery not for high availability. In this windows failover cluster we are ...
- 317
0
votes
1
answer
636
views
Repmgr : It automatically promotes to new master but other standby stopped
I'm trying to setup postgre with repmgr and here is the rsult
The scenario is,
i tried to spinup 1 primary and 2 standby.
then i stop the primary so the postgres-2 got promoted.
Unfortunately the ...
CommunityBot
- 1
5
votes
1
answer
905
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 ...
CommunityBot
- 1
1
vote
1
answer
8k
views
SQL Server Cluster Service Online Pending Status
I have 2 Nodes of SQL Cluster running SQL 2012 Ent over Windows 2012 R2 and i don't know suddenly what happened the service is not coming online. Under Failover Cluster Mannager > Roles > SQL > ...
CommunityBot
- 1
0
votes
0
answers
27
views
What is the best way to simulate split-brain?
I have a Windows failover cluster and would like to test if it works in a split-brain scenario. The cluster consists of virtual machine in hyper-V. How would one go about doing this?
0
votes
1
answer
829
views
Load Balancing SSRS inside an AlwaysOn Availability Group
We have 3 nodes in an Availability Group in SQL 2014:
Primary Site:
Server1 (synchronous primary)
Server2 (synchronous, readable secondary)
DR:
Server3 (async, nonreadable secondary)
We use ...
CommunityBot
- 1
0
votes
1
answer
3k
views
SQL Sever Alwayson - Increase the WSFC failover threshold
Im trying to simulate the Failover in my SQL server 2017 alwayson by stopping and starting the SQL server service.
It worked 2 times, but after that, the failover is not happening, It showing an error ...
CommunityBot
- 1
0
votes
2
answers
978
views
Split Brain scenario Always on Availability group
Due to maintenance our primary site will be offline for few hours. I have an availability group where there are 2 nodes at the primary site and one node at the DR Site.
Since the Primary site will be ...
CommunityBot
- 1
3
votes
1
answer
11k
views
DATABASE lacks a quorum of nodes for high availability
Just after setting up successfully alwayson - availability group,
testing the failover,
I get this error message:
TITLE: Microsoft SQL Server Management Studio
Failed to resume data movement in ...
CommunityBot
- 1
1
vote
1
answer
263
views
Automatic MYSQL failover
We have a wordpress environment however this is not a wordpress question. Our scenario is that front Ends connect to a MYSQL backend (MYSQL VM1) which is replicated to a backup vm (MYSQL VM2). The ...
CommunityBot
- 1
0
votes
0
answers
47
views
MySQL Master Slave Asynchronous GTID Replication Failover over ProxySQL with little downtime
This is a production setup and I have to perform a failover from Master A to new potential master B.
MySQL Version is 5.7 and CentOS 7 is the OS.
I have a simple master slave setup with A as Master ...
5
votes
1
answer
5k
views
Postgres Streaming Replication: How to re-sync data in master (with standby) after failover
I am absolutely new to postgres 9.1 replication mechanisms.
I have managed to set up streaming replication between a master and standby postgres (Both have x number of records). At one point when ...
CommunityBot
- 1
0
votes
1
answer
36
views
How to monitor mysql master - slave replication in windows os and failover in event of failure of master
I have a master and 3 slave all on windows OS.
I need a tool I can use to monitor replication and failover to a slave incase the master is goes down. What tool do you recommend.
I prefer open source ...
- 55
0
votes
0
answers
30
views
Prevent Sql Server sending Failover partner to connecting clients
I have 2 Sql Server 2008R2, enterprise edition servers setup in an asynchronous (High Peformance) mirror setup. There is no witness.
Intermittently I find that a client will attempt to connect to the ...
- 141
0
votes
0
answers
42
views
It's possible switchover a innodb cluster instance as primary?
If I am in topologyMode Single-Primary, it's possible to switchover the primary instance between machines in the cluster? I did not find anything in the documentation.
Ie: in my lab I have:
topology&...
- 77k
0
votes
0
answers
35
views
Whenever a failover occurs, either manually or automatically Immediately blocking problem occurs
I have a table log_table, and I have two stored procedures: insert_sp for inserting log entries into the table, and update_sp for performing update operations.
I have a SQL Server failover cluster ...
0
votes
1
answer
50
views
Can a domain-independent SQL Server Failover Cluster Instance be created
I know that Always on Availability Groups can be set up on a windows server failover cluster without active directory integration.
But can a SQL Server Failover Cluster Instance high availability ...
- 47
-2
votes
1
answer
30
views
Is there support for distributor server failover?
I have done googling for this question. The answer is no. But the answer is on year 2015. How about now? Is the distributor server have failover support capibility?
- 2,532
0
votes
1
answer
133
views
Promoting MySQL replica to primary during failover
The MySQL primary fails and I'm trying to promote the replica to primary.
Following the official documentation, I've already:
disabled the failed primary server on all load balancers
waited for the ...
- 25.1k
0
votes
1
answer
30
views
Can I fail back from Node2 to Node1 when my SQL Server database is in recovery?
I recently failed over my SQL Server instance from Node1 to Node2 and noticed below informational message:
Recovery of database 'huge_database' (22) is 24% complete (approximately 399 seconds remain)....
- 30k
1
vote
2
answers
279
views
Failover time after SQL Server patch
We have two node Windows Server cluster with installed SQL Server (2019 Standard Edition) Clustered instances on each node
There are 500 active databases
There are no any Availability Groups or any ...
- 30k
0
votes
0
answers
28
views
Is having a backup database system ready for when my database cluster fails a good idea?
We have a MySQL database cluster using NDB with four nodes, two in each datacenter.
The database uptime is very important, it must be up 24x7 and we cannot affort downtime.
Is the following a good ...
- 35.2k
1
vote
1
answer
159
views
SQL Network Name owned by Available Storage OwnerGroup in Server 2012 FCI
I did a simple get-clusterresource and noticed the 'owner group' is 'available storage'. Not SQL Server (instance)for the SQL Server Network Name (instance). I want to fix this ASAP but I'm having a ...
- 1
0
votes
1
answer
43
views
Distributed Availability group with witness server for quorum
I have experience in setting up availability group and have used witness server when the nodes are even to achieve quorum.
One of the vendor provided a layout which will have two availability group ...
- 30k
0
votes
1
answer
149
views
Split brain scenario
We have a 4 node availability group with 3 nodes at primary site and 1 node at the DR. Suppose the Primary site entirely goes down and we have to do a forced failover at the DR.
Now if there is no ...
- 45.9k
0
votes
1
answer
65
views
What owner node should the quorum drive belong to
Using windows fail over clustering on a two or three node cluster. What owner node should the quorum drive be owned by?
During my fail over testing, i can jump from node 1 to 2 and 2 to 1, but the ...
- 30k
0
votes
1
answer
114
views
How to reliably restore slave to master in MySQL Multi Source Replication?
I have multi source mysql replication setup configured, so I have this big server which act as a slave to other smaller server. The setup looks similar to below.
Everything is working fine— until one ...
- 77k
0
votes
2
answers
1k
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 ...
0
votes
1
answer
117
views
Is it possible to have a failover sql server with same instance name and same database name?
We have an application that is licensed on MS sql server instance name and database name. It is not possible to add a second instance/database. Is it possible to have active mirroring and let the ...
- 18.9k
2
votes
1
answer
376
views
Should the quorum drive always be at the same node with the SQL Server role in a SQL Server failover cluster environment?
In a SQL Server failover cluster environment, I can move the SQL Server role to node a and the quorum drive at node b. Although it's possible, is this a correct configuration? While I was Googling ...
- 30k
0
votes
1
answer
486
views
How to failover in a database mirroring session when the safety mode is off and no witness
I'm testing SQL Server database mirroring and below is my topology.
node2, principal
node1, mirror
+-------------+--------------------------------------+-----------------+----------------------+-----...
- 16.1k
1
vote
0
answers
178
views
Multi master with some slaves vs single master with some slaves
I need some advice on architecture.
I have a national database that relies on postgres and some architectural design that involves orchestrating several components, very much similar to the picture ...
- 167
0
votes
1
answer
1k
views
Exception code: 0xc0000374 constant failover
I have two clusters setup for failover.
However, from some time ago, I keep getting error Exception code: 0xc0000374
Then SQL SERVER failover happens.
When failover happens, sometimes the secondary ...
- 38.8k
0
votes
1
answer
902
views
MongoDB 2 node cluster
I am trying to understand the implications of setting up a 2 node MongoDB cluster with the following configuration (Documentation does say a minimum of 3 nodes is required).
MongoDB Version is 3.2.
If ...
CommunityBot
- 1
0
votes
0
answers
200
views
Using logical replication with PostgreSQL 14 & handling failover and failback
I have PostgreSQL 14 on two Linux servers. There is a database on both servers, let’s say database ‘A‘ in server-1 and database ‘B‘ server-2. I have a software that generates some data, and while I ...
- 1
0
votes
1
answer
2k
views
This operation returned because the timeout period expired - unable to add third node to existing Windows Failover Cluster
I have a Windows failover cluster up and running, with two nodes.
I'm now trying to add a third node:
Add-ClusterNode -Name node3
this unfortunately fails with the following error:
The clustered ...
- 113
0
votes
1
answer
766
views
Log Shipping failover when Primary is not accessible
Log Shipping Fail-over
I have set up log Shipping with Cluster. In this scenario I want to simulate a situation when the whole cluster becomes inaccessible.
My Steps for fail-over will be
Copy and ...
- 25.1k
0
votes
1
answer
245
views
Does an asynchronous replica in Always On Availability Group need to be part of windows failover cluster?
I have a Windows failover cluster up and running, with a primary and secondary server.
I have also created an Always On Availability Group with the two servers, with both the primary and the secondary ...
- 30k
0
votes
0
answers
69
views
Failover - azure. Connection string
I've got a primary and secondary database that i've just configured a Failover group.
My question is:
Can existing connection still connect directly to the DB, or do i need to change all connection ...
- 11
0
votes
0
answers
89
views
Slow Database queries when on Secondary Node of Availability Group
Failover happens almost immediately, but an application connecting to several databases on the server runs WAY slower (Queries return in 4 minutes compared to 30 seconds).
The hardware and software on ...
- 33
0
votes
3
answers
140
views
Need to configure Availability Groups between three different SQL failover instance
We have total 6 Nodes and 3 failover cluster (Each with two node).
Cluster1.TestAD.com(Node1,Node2) - SQL Failover Instance (SQL1) - 1
TB Shared storage
Cluster2.TestAD.com(Node3,Node4) - SQL ...
CommunityBot
- 1
1
vote
1
answer
624
views
Why automatic failover does not occur when I turn off SQL Service in SQL Server Failover Cluster Instance?
I faced unusual behavior associated with automatic failover so that automatic failover does not work in the case of turning off SQL Server service. It seems that clustered disks are still remaining ...
- 5,069
1
vote
1
answer
457
views
AG failover successful, but old Primary node thinks its still primary after bringing back online
I am doing some testing on SQL 2017 Availability Groups and have the following setup:
1 SQL Clustered instance on a 2-node WSFC in DC1
1 standalone SQL node in DC2
There is 1 AG, containing 3 DBs, ...
- 30k
0
votes
2
answers
240
views
3 Node WFCS - How to automatically FO to DR?
I am planning to implement a two-node Windows Server Failover Cluster (WSFC) for SQL Server Always On Availability Group in our main site, and the third node in our DR site.
All application clients ...
- 3,359