Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more

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.

Filter by
Sorted by
Tagged with
0 votes
1 answer
16 views

Do the vCores in my Read-Replica process the synchronization activity?

My initial understanding of my read-replica is that it would be less busy than the primary. After all, the primary is processing all the reads, inserts, updates and deletes which are supporting my ...
Yossi Geretz's user avatar
1 vote
1 answer
23 views

Why can't I create more than 1 geo replica for my primary database?

I have a primary database in the Premium service level. I am trying to create a second geo replica to a different region. The primary is in the East Coast, The first replica is in South Central, and ...
Yossi Geretz's user avatar
0 votes
1 answer
13 views

Can I create a Geo Replica of a Named Replica?

For clarity, we have two databases on a server in a given region. One database is the primary for the read/write workload, and one is a replica for the read-only workload. I'm trying to set up a ...
Yossi Geretz's user avatar
0 votes
1 answer
35 views

What happens to my read-replica database in failover mode?

I have a few basic questions about Azure failover. I am new to failover. I've been reading the literature and I'm ready to give this a shot. Before I take the plunge, I'd like to have a better ...
Yossi Geretz's user avatar
0 votes
1 answer
44 views

Will a 2-node windows server failover cluster go down if the disk witness owner crashes?

In a 2 node WSFC where Node 1 owns the disk witness, would Node 1 crashing result in the entire cluster going down (loss of quorum because only 1/3 votes remain)? Or does disk witness ownership ...
Marcus's user avatar
  • 69
0 votes
1 answer
12 views

Why is my 4-node replicaset setup is not working?

I have a 4 Node setup which is being hosted On-Prem by 2 Host Servers (DC1, DC2) 192.168.0.1 - Primary (Located in DC1) 192.168.0.2 - Secondary (Located in DC2) 192.168.0.3 - Arbiter (Located in DC2) ...
JRA's user avatar
  • 149
0 votes
0 answers
80 views

Patroni failed to get list of machines from etcd

I am running a patroni cluster (3.4) on linux with an etcd cluster. Normally the cluster runs perfectly fine but sometimes I get some errors saying Request to etcd server failed (ReadtmeoutError, ...
mymarcelsql's user avatar
0 votes
2 answers
35 views

AD DNS manager records duplication with SQL always on failover cluster

We are managing our SQL Always On listeners records in 2 active directory servers (they are syncing each other) and we came across an issue which we couldn't pinpoint the cause for.We are testing ...
Yishai's user avatar
  • 1
1 vote
1 answer
64 views

SQL availability group failover latency experienced is 35 seconds, which is 10 seconds higher than older SQL Mirror failover

Encountered problem: Our use-case has 3 x Server 2022 in a topology of a domain controller with two node cluster. This is a SQL Always On AG architecture. The cluster hosts the SQL availability ...
AllYourBaseAreBelongToUs's user avatar
0 votes
1 answer
19 views

How can I minimize data loss & data transfer when I failback with the requirement that I promote the old primary back to its primary status?

The definition of failback according to IBM docs is "the process of returning production to its original location after a disaster or a scheduled maintenance period". From my reading of ...
Anthony O's user avatar
  • 125
0 votes
1 answer
87 views

Does application need to do anything to handle database failover?

I'm trying understand database failover (mainly in SQL Server) and what handling is required from application side to have zero downtime (no failures) to handle DB failover? Assuming that DBAs have ...
Hitesh's user avatar
  • 3
0 votes
0 answers
31 views

MongoDB WiredTiger History Store File Growth Observed During Failover

We are currently undergoing a migration from MongoDB version 4.4 to 5.0, and during this process, we have encountered some intriguing observations that deviate from our anticipated outcomes. Despite ...
user202752's user avatar
0 votes
0 answers
88 views

Database disappear from Failover Group

I run an Azure subscription with a main SQL Server in West Europe and a georeplicated SQL Server in North Europe with a failover group. In these servers I have two elastic pools with the same name. ...
Paolo Crociati's user avatar
0 votes
1 answer
47 views

Clarification on Automatic Failover Rules in SQL Server Availability Groups

I'm configuring a SQL Server Availability Group with three replicas: node1\inst, node2\inst, and node3\inst. I have set node1\inst for automatic failover with synchronous commit, while node2\inst and ...
Just a learner's user avatar
1 vote
0 answers
53 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 ...
mbielsa's user avatar
  • 66
0 votes
0 answers
74 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 ...
Mike's user avatar
  • 658
0 votes
0 answers
225 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 ...
Farid Zahidov's user avatar
0 votes
0 answers
213 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 ...
info.sqldba's user avatar
0 votes
0 answers
60 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?
Nothing Else's user avatar
0 votes
1 answer
80 views

MySQL Master Slave Asynchronous GTID Replication Failover/Switchover 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 ...
Avinash Pawar's user avatar
0 votes
0 answers
55 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 ...
Aheho's user avatar
  • 141
0 votes
0 answers
83 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&...
Astora's user avatar
  • 723
0 votes
0 answers
39 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 ...
HAKAN MAZI's user avatar
0 votes
1 answer
73 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 ...
Marcus's user avatar
  • 69
-2 votes
1 answer
39 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?
zul nasir's user avatar
0 votes
1 answer
41 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 ...
Shevy's user avatar
  • 1
0 votes
1 answer
33 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)....
Fajela Tajkiya's user avatar
0 votes
1 answer
249 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 ...
jean-christophe manciot's user avatar
1 vote
2 answers
437 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 ...
Elvin Ahmadov's user avatar
0 votes
1 answer
218 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 ...
SQL_NoExpert's user avatar
  • 1,061
0 votes
1 answer
54 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 ...
SQL_NoExpert's user avatar
  • 1,061
0 votes
1 answer
120 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 ...
pithhelmet's user avatar
0 votes
1 answer
139 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 ...
Liso's user avatar
  • 103
0 votes
1 answer
162 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 ...
Sven Dühring's user avatar
2 votes
1 answer
547 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 ...
Fajela Tajkiya's user avatar
0 votes
1 answer
711 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 +-------------+--------------------------------------+-----------------+----------------------+-----...
Fajela Tajkiya's user avatar
1 vote
0 answers
213 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 ...
padjee's user avatar
  • 187
1 vote
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 ...
vay's user avatar
  • 19
0 votes
0 answers
230 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 ...
pgresdbq's user avatar
0 votes
1 answer
3k 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 ...
Foo's user avatar
  • 113
0 votes
1 answer
278 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 ...
Foo's user avatar
  • 113
0 votes
0 answers
73 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 ...
dexon's user avatar
  • 47
0 votes
0 answers
95 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 ...
CrushingIT's user avatar
0 votes
2 answers
1k 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 ...
SQL_NoExpert's user avatar
  • 1,061
1 vote
1 answer
842 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 ...
Rauf Asadov's user avatar
  • 1,273
0 votes
2 answers
314 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 ...
Oky's user avatar
  • 1
1 vote
1 answer
596 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, ...
Ric's user avatar
  • 13
0 votes
0 answers
75 views

Procedures to safely perform SQL Server Always On database cluster failover during Updates & Patching?

I need some steps and guidance, to perform the Microsoft Cluster Failover (MSCS 2016) for my SQL Server 2017 Enterprise Edition – Always-On 2x nodes. This is to perform the Windows Server updates that ...
Senior Systems Engineer's user avatar
0 votes
2 answers
463 views

Always On Failover Cluster Instances (FCI) on existing SQL Server

I have launched three EC2 Windows_Server-2019_SQL_2019_Standard instances. How can I implement Always On Failover Cluster Instances (FCI) on these existing SQL Servers. I can only find details like ...
Shivkumar Mallesappa's user avatar
0 votes
1 answer
4k 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 ...
TheDataGuy's user avatar
  • 1,940

1
2 3 4 5
8