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

1
2 3 4 5
7