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.
363
questions
0
votes
0
answers
23
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
52
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 ...
0
votes
0
answers
94
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
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
0
answers
44
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 ...
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
41
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&...
- 616
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
48
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 ...
- 45
-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?
- 11
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 ...
- 1
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)....
- 1,157
0
votes
1
answer
129
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 ...
1
vote
2
answers
273
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 ...
- 230
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 ...
- 101
0
votes
1
answer
146
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 ...
- 1,039
0
votes
1
answer
42
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 ...
- 1,039
0
votes
1
answer
62
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 ...
- 145
0
votes
1
answer
113
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 ...
- 103
0
votes
1
answer
113
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 ...
2
votes
1
answer
360
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 ...
- 1,157
0
votes
1
answer
475
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
+-------------+--------------------------------------+-----------------+----------------------+-----...
- 1,157
1
vote
0
answers
177
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 ...
- 9
0
votes
0
answers
198
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
241
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 ...
- 113
0
votes
0
answers
67
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
2
answers
969
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 ...
- 1,039
1
vote
1
answer
615
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 ...
- 1,253
0
votes
2
answers
238
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 ...
- 1
1
vote
1
answer
446
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, ...
- 13
0
votes
0
answers
67
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 ...
0
votes
2
answers
392
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 ...
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 ...
- 1,910
0
votes
2
answers
518
views
How to organize MongoDB replicaset backup and alerting
I have a running MongoDb replicaset consisting of 2 replicas and 1 master nodes. Recently I noticed that my master gone and automatic failover took action and changed master, however I wasn't aware of ...
- 191
1
vote
1
answer
662
views
High availability primary does not automatically take secondary role when back online
Setup:
Basic high availability
2 replicas (1 primary, 1 secondary).
DB01 => initial primary.
DB02 => initial secondary
Synchronous commit on both
Both are in synchronized state
There is no ...
- 553
0
votes
1
answer
256
views
Automatic Failover for Basic Availability Group
This will be my first project with Basic availability group so I thought would check before implementing .
As per Microsoft documentation below it says we will need to have Software assurance for ...
- 1,039
1
vote
1
answer
445
views
Why sql service is still running after uninstalling failover cluster instance?
The installation of sql server failover cluster instance didn't go well.
So I decided to remove whatever was installed and reinstall it again.
To to uninstall sql failover cluster instance went ...
- 657
0
votes
1
answer
231
views
Turning off Secondary Replica in Always on availability group for maintenance
We are planning to turn off the secondary synchronous replica in our always on availability group for few hours for maintenance . Once we are done with the maintenance then we will need to failover ...
- 1,039
0
votes
2
answers
964
views
Testing WSFC failover puts secondary replica in RESOLVING mode
I have 2 locations and each has its own WSFC.
Cluster 1: WSFC,Datacenter1, Node1, Node2. Listener1
Cluster 2: WSFC, Datacenter2, Node3, Node4. Listener2
Created an Availability group as EXTERNAL ...
- 657
1
vote
0
answers
76
views
Windows Failover Cluster/Availability Groups - Issues because all servers of one site where unreachable
we had some issues because of maintenance and hope someone can explain what happened.
Our cluster looks like this:
Site A:
Node A1 (Quorum vote)
Node A2 (Quorum vote)
Node A3 (Quorum vote)
Node A4 (...
- 11
2
votes
1
answer
624
views
What happens to application in-flight transactions in an SQL Failover Cluster Instance?
In a SQL Server FCI configuration, what happens to transactions that are in flight when the failover event happens? 1. If the transaction is committed just before the server crashes 2. If the ...
- 303
0
votes
1
answer
320
views
Is there a SQL Server HA Configuration that is similar to Oracle RAC?
Please is there a SQL server High Availability configuration that is similar to Oracle RAC with respect to scalability? In Oracle RAC, in order to avoid overloaded resources, application requests can ...
- 303
1
vote
1
answer
844
views
Does Postgres CHECKPOINT process affects streaming replication?
Does Postgres CHECKPOINT process affect async streaming replication in any way?
If checkpoint_timeout is increased from 5min (default) to 30min, then CHECKPOINT processes will be triggered less often (...
- 165
2
votes
0
answers
471
views
DB_CHAINING lost on on planned Availability Group failover for SQL Server 2019 cumulative update
I'm looking for ideas on how to determine a plausible root cause for DB_CHAINNG problems encountered when we recently performed a planned AG failover.
We're using SQL Server 2019 Standard Edition with ...
- 746
3
votes
1
answer
980
views
Entity Framework Core for SQL Server Failover Basic Availability Groups does not work
I have set up an SQL Server Standard 2019 with Basic Availability Groups on a Windows Failover cluster. It is not like the Always On AG, but more of a limited version of it where DB operations are on ...
- 171
0
votes
1
answer
210
views
Migrate from Standalone Instance to Failover Node Instance
I am fairly new to the MS SQL and i am currently working on a project at my company. We have a ERP System built on a SQL Server and we want to create a SQL failover node.
The original configuration is ...
0
votes
2
answers
2k
views
Failover Cluster Manager > Role > SQL Server (Node1 is owner) > Resources (SQL Server & SQL Agent)
I created 2 separate WFC, one for database (SQLClustr) and one for application (APPCluster). Each cluster has 2 nodes plus one disk witness in quorum. I can easily failover by rebooting the one of the ...
- 3