Skip to main content

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
2 votes
1 answer
2k views

Repmgr: Error to promote Standby Cluster to Master Cluster in failover

I maked the configuration of the failover system based in Repmgr, but i don't haved success to promote the Standby Cluster to Master Cluster in case of failover. Following my configurations, this ...
3 votes
1 answer
412 views

SQL Server 2014 Availability Group failed

I have 3 servers on VMware workstation: Win 2012 R2 as ADDC -Cluster service. Win 2012 R2 as SQL server primary replica . Win 2012 R2 as SQL server secondary replica (auto fail-over). My ...
0 votes
1 answer
1k 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 ...
0 votes
0 answers
20 views

SQL server is already part of a cluster error; cannot re-add after removing offline SQL node

I'm new here but I've run out of options for my search on this issue my team is having. To give a relatively short backstory; I know almost nothing about SQL beside what I've learned from a short time ...
2 votes
1 answer
606 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 ...
0 votes
1 answer
324 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
365 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 ...
0 votes
1 answer
116 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&...
-2 votes
1 answer
68 views

ALTER AVAILABILITY GROUP in T-SQL not working

I am trying to set up a maintenance job in my SQL Server 2016 database that runs a check to see if one of my secondary nodes is the primary, if it is, I want it to failover to the actual server that ...
0 votes
1 answer
782 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 ...
0 votes
1 answer
56 views

SQL Server Failover Cluster Data Loss on failover

Currently running several databases on an Active/Passive SQL Server 2014 Failover Cluster on Windows Server 2012 R2. Recently there was an event that caused the active server to failover. The failover ...
5 votes
1 answer
926 views

Replication throw an error after failover mirror partner is down in SQL Server

Received an error mentioned below after failover when mirror partner is down. Error : to fail over to a database which is not configured for database mirroring. code: 22037, text: 'Invalid ...
0 votes
1 answer
837 views

Load Balancing SSRS inside an AlwaysOn Availability Group

We have 3 nodes in an Availability Group in SQL 2014: Primary Site: Server1 (synchronous primary) Server2 (synchronous, readable secondary) DR: Server3 (async, nonreadable secondary) We use ...
0 votes
1 answer
20 views

Do the vCores in my Read-Replica process the synchronization activity?

My initial understanding of my read-replica is that it would be less busy than the primary. After all, the primary is processing all the reads, inserts, updates and deletes which are supporting my ...
1 vote
1 answer
9k views

SQL Server Cluster Service Online Pending Status

I have 2 Nodes of SQL Cluster running SQL 2012 Ent over Windows 2012 R2 and i don't know suddenly what happened the service is not coming online. Under Failover Cluster Mannager > Roles > SQL > ...
0 votes
1 answer
20 views

Can I create a Geo Replica of a Named Replica?

For clarity, we have two databases on a server in a given region. One database is the primary for the read/write workload, and one is a replica for the read-only workload. I'm trying to set up a ...
1 vote
1 answer
39 views

Why can't I create more than 1 geo replica for my primary database?

I have a primary database in the Premium service level. I am trying to create a second geo replica to a different region. The primary is in the East Coast, The first replica is in South Central, and ...
0 votes
1 answer
61 views

What happens to my read-replica database in failover mode?

I have a few basic questions about Azure failover. I am new to failover. I've been reading the literature and I'm ready to give this a shot. Before I take the plunge, I'd like to have a better ...
5 votes
1 answer
15k views

Problem adding a new node to a SQL Server 2012 Failover Cluster

I tried to add a new node to SQL Server (2012 Standard) Failover, that is already installed on another node in Windows2012 Failover Cluster I have an issue with non editable field wiht input for SQL ...
2 votes
1 answer
209 views

SQL 2014 Availability Group Cluster or Listener

We recently deployed a setup of SQL 2014 availability groups and we are having some difficulty with the failover. Setup: Two windows server 2012R2 VMs in a windows cluster with a CNAME pointed at the ...
0 votes
1 answer
4k 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 ...
0 votes
1 answer
106 views

Will a 2-node windows server failover cluster go down if the disk witness owner crashes?

In a 2 node WSFC where Node 1 owns the disk witness, would Node 1 crashing result in the entire cluster going down (loss of quorum because only 1/3 votes remain)? Or does disk witness ownership ...
0 votes
1 answer
18 views

Why is my 4-node replicaset setup is not working?

I have a 4 Node setup which is being hosted On-Prem by 2 Host Servers (DC1, DC2) 192.168.0.1 - Primary (Located in DC1) 192.168.0.2 - Secondary (Located in DC2) 192.168.0.3 - Arbiter (Located in DC2) ...
0 votes
0 answers
301 views

Patroni failed to get list of machines from etcd

I am running a patroni cluster (3.4) on linux with an etcd cluster. Normally the cluster runs perfectly fine but sometimes I get some errors saying Request to etcd server failed (ReadtmeoutError, ...
5 votes
1 answer
6k views

Postgres Streaming Replication: How to re-sync data in master (with standby) after failover

I am absolutely new to postgres 9.1 replication mechanisms. I have managed to set up streaming replication between a master and standby postgres (Both have x number of records). At one point when ...
3 votes
1 answer
13k views

DATABASE lacks a quorum of nodes for high availability

Just after setting up successfully alwayson - availability group, testing the failover, I get this error message: TITLE: Microsoft SQL Server Management Studio Failed to resume data movement in ...
0 votes
2 answers
1k 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 ...
0 votes
1 answer
97 views

MySQL Master Slave Asynchronous GTID Replication Failover/Switchover 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 ...
1 vote
3 answers
966 views

Manually specifying candidate masters in Maxscale

Looking over the documentation, I haven't quite been able to find if its possible to manually set the candidate master status of a server in Maxscale. The reason I am looking for this is because some ...
5 votes
1 answer
511 views

Mysqlfailover command - No slave is listed in health status

I have successfully created replication using GTID_MODE. It works perfectly. Now I need to setup automatic failover feature in it. I have run the following command. mysqlfailover --master=root:abc@10....
0 votes
2 answers
51 views

AD DNS manager records duplication with SQL always on failover cluster

We are managing our SQL Always On listeners records in 2 active directory servers (they are syncing each other) and we came across an issue which we couldn't pinpoint the cause for.We are testing ...
1 vote
1 answer
98 views

SQL availability group failover latency experienced is 35 seconds, which is 10 seconds higher than older SQL Mirror failover

Encountered problem: Our use-case has 3 x Server 2022 in a topology of a domain controller with two node cluster. This is a SQL Always On AG architecture. The cluster hosts the SQL availability ...
0 votes
1 answer
22 views

How can I minimize data loss & data transfer when I failback with the requirement that I promote the old primary back to its primary status?

The definition of failback according to IBM docs is "the process of returning production to its original location after a disaster or a scheduled maintenance period". From my reading of ...
0 votes
1 answer
109 views

Does application need to do anything to handle database failover?

I'm trying understand database failover (mainly in SQL Server) and what handling is required from application side to have zero downtime (no failures) to handle DB failover? Assuming that DBAs have ...
0 votes
0 answers
43 views

MongoDB WiredTiger History Store File Growth Observed During Failover

We are currently undergoing a migration from MongoDB version 4.4 to 5.0, and during this process, we have encountered some intriguing observations that deviate from our anticipated outcomes. Despite ...
6 votes
3 answers
13k views

Understanding two NICs requirement for SQL fail over cluster

I am trying to make an SQL Server 2012 failover cluster. I have two DB machines. I understand that both machines need 2 NICs each. In my organization the IP scheme assigned is something like 192.168.1....
0 votes
0 answers
101 views

Database disappear from Failover Group

I run an Azure subscription with a main SQL Server in West Europe and a georeplicated SQL Server in North Europe with a failover group. In these servers I have two elastic pools with the same name. ...
0 votes
1 answer
54 views

Clarification on Automatic Failover Rules in SQL Server Availability Groups

I'm configuring a SQL Server Availability Group with three replicas: node1\inst, node2\inst, and node3\inst. I have set node1\inst for automatic failover with synchronous commit, while node2\inst and ...
1 vote
0 answers
54 views

Always-On listener not working correctly

I have an Always-On architecture with two nodes and two AG. One of AG working correctly but other AG's listener only directs to the primary node. When I fail it to the secondary node, the application ...
0 votes
0 answers
107 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 ...
0 votes
0 answers
292 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
261 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 ...
0 votes
0 answers
65 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?
1 vote
1 answer
265 views

Automatic MYSQL failover

We have a wordpress environment however this is not a wordpress question. Our scenario is that front Ends connect to a MYSQL backend (MYSQL VM1) which is replicated to a backup vm (MYSQL VM2). The ...
0 votes
1 answer
42 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 ...
0 votes
1 answer
85 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 ...
-2 votes
1 answer
42 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?
0 votes
1 answer
36 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 vote
2 answers
536 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 ...
1 vote
1 answer
172 views

SQL Network Name owned by Available Storage OwnerGroup in Server 2012 FCI

I did a simple get-clusterresource and noticed the 'owner group' is 'available storage'. Not SQL Server (instance)for the SQL Server Network Name (instance). I want to fix this ASAP but I'm having a ...

1
2 3 4 5
8