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
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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, ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 (...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 (...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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" ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
-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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 (...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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: ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar

1
2 3 4 5
7