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.
382 questions
0 votes
1 answer
72 views
ADO.NET client occasionally attempts connection to SQL Server mirror partner even when principal is online
We're running SQL Server 2016 Standard Edition with database mirroring in synchronous mode and automatic failover enabled. Our .NET applications use connection strings with Failover Partner. ...
- 1
1 vote
1 answer
130 views
Can I use MSSQL's Failover Partner parameter without configuring database mirroring?
I have 2 MSSQL databases that are not part of the same cluster but they are synchronized manually (without database mirroring configured) I want my client applications to try connecting to the first ...
- 113
0 votes
1 answer
209 views
MariaDB Galera and Geo redundancy
I am trying to simulate 2 clusters in different datacenters/different locations, using VMWare VSXi and 6 VMs: 3 are located on DC1 and other 3 on DC2. All nodes are RHEL 9. Both DCs communicate ...
- 11
-2 votes
1 answer
212 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 ...
- 1
0 votes
1 answer
50 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 ...
- 369
0 votes
1 answer
57 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 ...
- 369
0 votes
1 answer
586 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 ...
- 89
0 votes
0 answers
1k 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, ...
- 21