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.
345
questions
0
votes
2
answers
45
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,007
1
vote
1
answer
35
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,163
0
votes
2
answers
53
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
37
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
24
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
95
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
402
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,688
0
votes
0
answers
34
views
Hidden SQL server replica in always on availablity group
I want to deploy SQL server 2017 always on availablity group also with a replica for DR purpose.
I want to use
1 primary(prod)
2 secondary(prod)
1 secondary(DR)
Now my question is,
the failover can ...
- 1,688
0
votes
2
answers
79
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 ...
- 171
0
votes
0
answers
32
views
Has anyone used a Windows Failover Cluster with SQL Server FILESTREAM FileTables and experienced any major issues?
Has anyone used a Windows Failover Cluster with FileTables and experienced any major issues?
We're doing a proof of concept of this architecture with Windows Server 2019, SQL Server 2019 Standard ...
- 186
0
votes
0
answers
53
views
Creating a new SQL Server Instance in a Failover environment
I am having a real hard time trying to create a new instance for a database using SQL Server 2019 Failover cluster.
I am trying to follow these directions. I am stuck on Step 10 which is Instance ...
- 207
1
vote
1
answer
99
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 ...
- 481
0
votes
1
answer
52
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,007
0
votes
0
answers
38
views
The best way to install and uninstall (multiple times) sql server failover cluster instance
On my test environment I have WSFC with 2 nodes.
For testing purposes I have to install and uninstall sql server failover cluster instance multiple times.
What I do to uninstall:
In media folder I go ...
- 637
1
vote
1
answer
136
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 ...
- 637
0
votes
0
answers
67
views
SQL Server 2019 Always On Replica Disconnected
We are setting up Always On AGs in SQL Server 2019. The Availability Group will create on both nodes Node1 and Node2 but the database will not restore to the secondary node (Node2) because it is ...
- 61
0
votes
1
answer
58
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,007
0
votes
2
answers
262
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 ...
- 637
1
vote
0
answers
58
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
189
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 ...
- 231
0
votes
1
answer
105
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 ...
- 231
0
votes
1
answer
150
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 (...
- 135
2
votes
0
answers
224
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 ...
- 514
3
votes
1
answer
446
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
87
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
389
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
1
vote
1
answer
157
views
SQL Server Always On AG – Is a Passive Secondary Required for Automatic Failover?
It is my understanding that for automatic failover to occur in an Always On AG environment, the replicas just need to be configured with "automatic failover," "synchronous commit" ...
- 121
3
votes
0
answers
487
views
Got fatal error 1236 from master when reading data from binary log
I am trying to do a MySQL failover, in some situations I endup with broken replication. Any idea what could be the cause of it ?
Background
Needed to perform a host updates on master host. Hence ...
- 39
1
vote
0
answers
227
views
What are the available automatic failover solutions for MariaDB Master-Slave replication on Windows Server?
I am setting up a Master-Slave or Master-Master setup in MariaDB on two seperate servers running Windows Server. I also need to configure an automatic failover solution where client read requests gets ...
- 11
1
vote
1
answer
175
views
Failover in MySQL Chain Replication
We have a 4 server setup, 1 master, 3 daisy-chained slaves, in the following setup:
A (master) -> B (slave) -> C (slave) -> D (slave)
(the servers B and C and D are running with ...
- 13
2
votes
0
answers
53
views
SQL Server Failover Cluster -- How to Fail Over Storage?
The picture helps explain what I am trying to do.
I know how to setup an SQL failover cluster, did it and it works perfectly.
Here is my situation : Node1 and Storage A is in one location (city) and ...
- 21
2
votes
1
answer
101
views
Longer time to bring SQL online after node failover
We had a strange issue post our regular OS patching for SQL servers.
Per best practices, we apply patch on Passive and do node failovers to make current passive, active and vice versa to complete ...
- 2,127
0
votes
1
answer
310
views
SSRS subscriptions after failover
Shortly I will be migrating a 2008 R2 SSRS installation to a new SQL 2019 Always on AG in AWS. This one will contain subscriptions, and I have never dealt with them before. I read the documentation ...
- 203
0
votes
1
answer
51
views
How to optimize and estimate DB recovery times?
Would like to optimize recovery time for db's after failover to passive node in high availability cluster.
Assuming full recovery model...
What are the steps to take to optimize DB recovery time for a ...
- 922
-1
votes
1
answer
157
views
Availability Group is not failovering when a cluster core resource is failedover
I have created always on availability group.The cluster core resources failover is happening. The availability group (Automatic) failover is happening. But, when the cluster core resource is failed ...
0
votes
1
answer
32
views
AAG trigger a query when failing over
I'm running a Failover cluster on windows 2016 servers (2 nodes) where I set up an AG in SQL 14.0.2027.2
This works good and I'm happy. But when it failover I need to fix my logins so I need to run a ...
- 1
0
votes
1
answer
57
views
How to configure Oracle traffic director for full site failover to have high availability?
I have two server systems, each server having both Apache Tomcat server (deployed web app) and Oracle 11g database server. The database on the two servers is synchronised by Oracle Data Guard for high ...
1
vote
1
answer
2k
views
Error Failover in Always on high availability groups
We have a problem with Always on high availability groups in Microsoft SQL Server 2016 (SP2) , When we want to failover to the secondary node manually, it fails because of this error:
Failed to ...
- 21
1
vote
1
answer
794
views
SQL Server AlwaysOn: Lost of heartbeat and connection with secondary replica
Virtual Enviroment description:
Hypervisor: VMWare
WSFC composed by two nodes with Windows server 2016 Standard
SQL Server AlwaysOn with synchronous replica and automatic failover
SQL Server 2014 (...
- 97
1
vote
1
answer
138
views
REPMGR - change reconnect_attempts and reconnect_interval not working
I configured PostgreSQL automatic failover with REPMGR. But, in my simulation the sleeping time is 1 second for each reconnect attempt:
If I consult official documentation the default value to ...
- 304
1
vote
0
answers
25
views
Notification for host failure and health status [closed]
I set up a MongoDB cluster with replica sets.
I wish to have something like a dashboard or a "health status". My current solution is to connect to the cluster and query the replication state ...
- 11
2
votes
1
answer
225
views
AlwaysOn failover DR testing
I have always-on group running on 4 node cluster. Each DC has 2 node running on it
Data Center1:
Node1: Sync Replica - Automatic failover
Node2: Sync Replica - Automatic failover
Data Center2:
...
- 95
0
votes
1
answer
193
views
In Postgresql 12 how to I make the primary server a slave after a deliberate failover
I am using PostgreSQL 12 on Debian 10.6.
I have been reading up about replication and I have set up an asynchronous replication between one primary and standby. I wanted to test failover so I stopped ...
- 85
5
votes
2
answers
519
views
Availability Group - how much data was lost after forced failover
Let's consider a SQL Server AlwaysOn cluster with two nodes in asynchronous replication.
Is there any way to calculate how much data was lost after forced failover?
I mean in terms of time, to be able ...
- 97
0
votes
1
answer
378
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 ...
- 959
-1
votes
2
answers
339
views
how to failover in log shipping?
I am reading the book 'Pro SQL Server 2019 Administration' from Carter, where in the Log shipping section he mentions:
"Unlike other high availability and disaster recovery technologies, an
...
- 251
6
votes
6
answers
2k
views
Why is there automatic failover for HA and manual failover for DR?
I am reading this summary from the book 'Pro SQL Server 2019 Administration' from Carter:
And it specifies:
hot → automatic failover → used for high availability (HA)
warm → manual failover → used ...
- 251
0
votes
1
answer
122
views
Failover and DNS propagation delays
When a DBMS fails over after a failure, if it fails over to a server in a different and unrelated data center, then the IP address of the subdomain name of that database will need to be changed in ...
- 179
0
votes
0
answers
449
views
pgpool-II and Postgres docker image : automated failover and online recovery via rsa key
I've been following this documentation for pgpool-ii
https://www.pgpool.net/docs/latest/en/html/example-cluster.html
I'm having a hard time setting up rsa on my postgres streaming cluster built in ...
0
votes
1
answer
293
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 ...