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.
75
questions with no upvoted or accepted answers
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....
- 51
5
votes
1
answer
5k
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 ...
- 51
5
votes
1
answer
905
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 ...
- 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,...
- 151
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 ...
- 49
3
votes
1
answer
11k
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 ...
- 15.8k
3
votes
1
answer
402
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 ...
- 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 ...
3
votes
0
answers
541
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. ...
- 49
2
votes
0
answers
477
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 ...
- 746
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 ...
- 21
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 ...
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 ...
- 4,310
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 ...
- 121
1
vote
0
answers
178
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 ...
- 167
1
vote
0
answers
76
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
1
vote
0
answers
384
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
0
answers
901
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 ...
- 11
1
vote
0
answers
584
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
...
- 11
1
vote
0
answers
128
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 ...
- 11
1
vote
1
answer
48
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 ...
- 11
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 ...
- 41
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 ...
- 1,580
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 ...
- 11
1
vote
1
answer
8k
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 > ...
- 31
1
vote
1
answer
263
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 ...
- 179
1
vote
0
answers
114
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 ...
- 163
1
vote
0
answers
545
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 ...
- 121
1
vote
0
answers
394
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 ...
- 121
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 ...
- 111
1
vote
0
answers
615
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 ...
- 11
1
vote
0
answers
598
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 ...
- 11
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 ...
- 129
1
vote
0
answers
225
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 ...
- 151
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/...
- 21
1
vote
0
answers
447
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 ...
- 211
1
vote
0
answers
168
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 ...
- 133
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 ...
- 597
1
vote
1
answer
348
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 ...
- 329
1
vote
1
answer
760
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 ...
- 11
0
votes
0
answers
28
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 ...
- 42
0
votes
0
answers
25
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 ...
- 628
0
votes
0
answers
60
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
98
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 ...
- 317
0
votes
0
answers
27
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?
0
votes
0
answers
50
views
MySQL Master Slave Asynchronous GTID Replication Failover 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 ...
0
votes
0
answers
30
views
Prevent Sql Server sending Failover partner to connecting clients
I have 2 Sql Server 2008R2, enterprise edition servers setup in an asynchronous (High Peformance) mirror setup. There is no witness.
Intermittently I find that a client will attempt to connect to the ...
- 141
0
votes
0
answers
42
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&...
- 630
0
votes
0
answers
35
views
Whenever a failover occurs, either manually or automatically Immediately blocking problem occurs
I have a table log_table, and I have two stored procedures: insert_sp for inserting log entries into the table, and update_sp for performing update operations.
I have a SQL Server failover cluster ...
0
votes
1
answer
36
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 ...
- 1