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.

83 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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....
Aneesha's user avatar
  • 51
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 ...
Nandini's user avatar
  • 51
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 ...
Paresh's user avatar
  • 213
4 votes
0 answers
4k views

MS SQL Server 2012 Failover Cluster connection issue

I was about to give up with this but I'll give it a go here if anyone can help. I've set up a fail-over cluster SQL Server with 2 SQL nodes, Domain controller and file witness. All seems to work fine,...
David Aleu's user avatar
3 votes
0 answers
2k 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 ...
RobinHood's user avatar
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 ...
Marcello Miorelli's user avatar
3 votes
1 answer
411 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 ...
danarj's user avatar
  • 169
3 votes
0 answers
375 views

PostgreSQL Streaming Replication Tools - Windows

Is there any clusterware available for PostgreSQL clusters running on Windows OS? I'm specifically interested in automatic failover and STONITH functionality. I've done a fairly extensive Google ...
Matt Hempleman's user avatar
3 votes
0 answers
556 views

Prevent SQL Server failback after cluster aware updating

We have SQL Server 2012 in a two-node cluster with Windows Server 2012 (node and disk majority). Neither of the nodes are marked as preferred owner and the "Prevent Failback" option is selected. ...
BobT's user avatar
  • 49
2 votes
1 answer
601 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 ...
Rob Dalzell's user avatar
2 votes
0 answers
98 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 ...
gfbaggio's user avatar
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 ...
Alessandro Cardoso's user avatar
2 votes
0 answers
1k views

Is is possible to convert SQL Server from single instance to failover clustered node?

If SQL Server 2014 Enterprise has already been installed, can it still be converted/added to a failover cluster? Specific scenario - Amazon EC2 instance of Windows 2012 + SQL Server 2014 (license ...
孔夫子's user avatar
  • 4,330
2 votes
0 answers
662 views

Redis Cluster monitoring

In some limited testing with Redis Cluster I've identified the following conditions where a failed master would be unable to failover: The obvious, all the slaves have failed All of a master's slaves ...
Garrett Greer's user avatar
1 vote
1 answer
96 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 ...
AllYourBaseAreBelongToUs's user avatar
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 ...
mbielsa's user avatar
  • 66
1 vote
0 answers
225 views

Multi master with some slaves vs single master with some slaves

I need some advice on architecture. I have a national database that relies on postgres and some architectural design that involves orchestrating several components, very much similar to the picture ...
padjee's user avatar
  • 187
1 vote
2 answers
360 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 ...
SQL_NoExpert's user avatar
  • 1,061
1 vote
0 answers
85 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 (...
NicSmith's user avatar
1 vote
0 answers
424 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 ...
Lucas Teong's user avatar
1 vote
0 answers
1k views

SQL server availability group cannot access database after disabling sql service

I've completed this setup: OS: Windows server 2016 Database: SQL Server 2017 2 node availability group configured with automatic failover on both nodes. Fileshare witness configured, both nodes ...
Duke's user avatar
  • 11
1 vote
0 answers
617 views

Sync PostgreSQL with Cloud and multi Local Locations

I need help with a complex (for me) multi server setup with PostgreSQL. I have to setup a Cloud Server and 3 Local Servers for our company. Each Server will have: Linux Ubuntu 16.04 Docker ...
Kevin's user avatar
  • 11
1 vote
0 answers
146 views

Enabling FileStream in existing clustered servers in SQL Server 2012

I have heard that enabling FileStream in an already existing clustered environment is tough. I'm working on a consolidation project and currently analyzing the impact it will have if we migrated DBs ...
dbbk's user avatar
  • 11
1 vote
1 answer
76 views

AlwaysOn Replicas set to manual but failing automatically

My two synchronous-commit SQL AO replicas are set for manual failover mode but are failing over automatically. When I look through the logs and extended events, it looks just like what would happen if ...
Matt Davis's user avatar
1 vote
0 answers
62 views

Why use Failover replica on Google Cloud RDS?

we are thinking of migrating our MySQL database from our dedicated server to a Google Cloud RDS instance. However I would like to clarify the below: 1) What is the purpose of creating a failover ...
Leonidas's user avatar
1 vote
0 answers
492 views

Switch-SQLAvailability error during DB Restore in AlwaysON Group

Can anyone share your inputs on below and how to fix the issue and possible causes of failure? I am trying to restore a DB using PS script and at one step it is failing during the role change test ...
Learning_Learning's user avatar
1 vote
0 answers
1k views

VMWare Windows Failover Clustering - Cluster Node Removed

We have a 2012 Windows failover Cluster set up for SQL Server 2014 on VMWare ESXi, 6.0.0, 3620759. A couple weekends ago, our Server Admin made some updates to the the UCS Manager software, which in ...
Ted's user avatar
  • 11
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 > ...
Danish's user avatar
  • 31
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 ...
joebegborg07's user avatar
1 vote
0 answers
129 views

Losing records during transitioning to a failover cluster

Recently we had an outage in our primary SQL Server cluster and traffic was directed to the fail-over cluster. This process has taken a few seconds. The funny thing is that application logs show we ...
Mori's user avatar
  • 163
1 vote
0 answers
564 views

Connect to a SQL Server Mirror from Oracle Database

I know we can create a database link to connect to a Microsoft SQL Server from Oracle database. But the problem which I faced with is the SQL database which I want to connect to has a mirror fail-over ...
Reza Aghaei's user avatar
1 vote
0 answers
400 views

Oracle Database Gateway for SQL Server - Connect to a SQL Server Mirroring Session

An Oracle Database server is using Oracle Database Gateway for SQL Server to define a Link Server to a Microsoft SQL Server. For the database on Microsoft SQL Server, Mirroring has been configured. So ...
Reza Aghaei's user avatar
1 vote
0 answers
58 views

Failover stragtegy for replicant db via 3rd party

We use a Multi-tenant SaaS product hosted in the providers network. They provide us a 3 replicate db for our data, updated approximately every 30 min. We used this replicant database for our read ...
Justin Homes's user avatar
1 vote
0 answers
655 views

Firewall Rules, IP address failover cluster

We are having issues with some applications running and connecting to a failover cluster through a firewall (not Windows firewall). In the firewall settings we configure the IP addresses from the ...
Martijn1989's user avatar
1 vote
0 answers
602 views

How to modify an existing AlwaysOn Availability Group IP

I have an unusual question regarding AlwaysOn Availability Group configuration. I have built out an AOAG cluster on a VM. The build out did not use a Heartbeat network as I had originally requested ...
Miles Schor's user avatar
1 vote
0 answers
46 views

Windows Clustering 2008 R2

I'm trying to build a Windows cluster with 3 nodes, 2 Active and 1 Passive, And If I have to build in a way like N1 Active - N3 Passive will be refer as "cluster network 1" and N2 Active and N3 ...
Sai's user avatar
  • 129
1 vote
0 answers
226 views

Failover cluster connection issue

I'm trying to run SQL Server Failover cluster in Azure. I have NODE1 and NODE2 in a cluster and another SERVER in the same network trying to connect to the database server using the instance from ...
David Aleu's user avatar
1 vote
0 answers
2k views

AlwaysOn Availability Group: Users on Secondary Server

We have an AlwaysOn Availability Group setup (DB1+DB2) and also a web server (Web1) outside of the domain that we need to connect to the AG using Windows Authentication. The following Windows Users/...
Stuart's user avatar
  • 21
1 vote
0 answers
456 views

Postgresql Streaming Replication - pgpool2 - failover

In my scenario I want pgpool to forward read only queries to slaves when the master goes down - I want my app to be in the "read only mode". How do I setup pgpool to accept read only queries when ...
g00fy's user avatar
  • 211
1 vote
0 answers
173 views

Any solution to fix circular replication fail-over?

I've developed a point-of-sale system for our corporation, which has 25+ branches across the country. Each branch has its own MySQL POS database on a WAMP server. I want every event that occurs in ...
CairoCoder's user avatar
1 vote
0 answers
613 views

SQL Server 2012 Failover Cluster and attached SAN

I have three servers in a Windows Server failover cluster. SQL Server 2012 Failover Cluster is installed on all nodes. I have an issue with shared disks attached from SAN. overview with the same ...
mKorbel's user avatar
  • 597
1 vote
1 answer
357 views

azure sql failover duration

I have a azure sql database in North Europe Region. It is almost 5 MB and it has Basic Pricing Tier. That database is not in Azure VM. I am using PaaS environment. I configured Geo-Replication ...
Banu Akkus's user avatar
1 vote
3 answers
959 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 ...
Bif Stone's user avatar
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 ...
Anthony Schwab's user avatar
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 ...
Yossi Geretz's user avatar
0 votes
1 answer
19 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 ...
Yossi Geretz's user avatar
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) ...
JRA's user avatar
  • 149
0 votes
0 answers
277 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, ...
mymarcelsql's user avatar
0 votes
2 answers
47 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 ...
Yishai's user avatar
  • 1
0 votes
0 answers
38 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 ...
user202752's user avatar