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.
346
questions
1
vote
1
answer
38
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 ...
- 23
0
votes
1
answer
51
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 ...
- 23
0
votes
0
answers
10
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
15
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 ...
- 23
0
votes
2
answers
169
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
55
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,183
0
votes
2
answers
55
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
67
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
30
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
137
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
694
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,708
0
votes
0
answers
35
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,708
0
votes
2
answers
132
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
40
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
1
vote
1
answer
129
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 ...
- 491
0
votes
1
answer
71
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
1
vote
1
answer
172
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
1
answer
72
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
350
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
62
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
264
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
116
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
216
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 (...
- 145
2
votes
0
answers
251
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
529
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
101
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
491
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
207
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
714
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
242
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
237
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
61
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
172
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,137
0
votes
1
answer
381
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
55
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 ...
- 970
-1
votes
1
answer
231
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
38
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
70
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
902
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
175
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
26
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
276
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
305
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
605
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
471
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 ...
- 969
-1
votes
2
answers
585
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
169
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
480
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 ...