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
73
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
0
votes
1
answer
63
views
Mysql ubuntu solution (failover, failback)
I am a newbie SQL DBA and I am working on a mysql server based on ubuntu operating system.
I need to solve the following problems. Is there a way to solve all the following problems with a single ...
1
vote
1
answer
134
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
100
views
Is it possible to add a PostgreSQL hot standby using pg_createcluster to a primary created with initdb?
Hi we are using PostgreSQL 16 on Ubuntu 22 LTS and have built a cluster using initdb. I'm wondering if it's possible to rebuild a standby using pg_createcluster instead to take advantage of various ...
- 3
0
votes
1
answer
211
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
0
votes
0
answers
92
views
PostgreSQL: Is there any way to further optimise ASYNC replication towards less data loss during failover?
We are looking to see if there any further optimisations that can be done in PostgreSQL(13) ASYNC replication to make data loss near to zero as possible when a failover is triggered during disaster. ...
- 700
-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
179
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 ...
0
votes
1
answer
51
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
1
vote
1
answer
138
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 ...
- 369
0
votes
1
answer
58
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
2
answers
839
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 ...
- 369
0
votes
1
answer
590
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
1
answer
40
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)
...
- 137
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