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.
364
questions
0
votes
2
answers
2k
views
Failover Cluster Manager > Role > SQL Server (Node1 is owner) > Resources (SQL Server & SQL Agent)
I created 2 separate WFC, one for database (SQLClustr) and one for application (APPCluster). Each cluster has 2 nodes plus one disk witness in quorum. I can easily failover by rebooting the one of the ...
- 3
2
votes
1
answer
612
views
SQL Server Always On AG – Is a Passive Secondary Required for Automatic Failover?
It is my understanding that for automatic failover to occur in an Always On AG environment, the replicas just need to be configured with "automatic failover," "synchronous commit" ...
- 131
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
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
1
answer
494
views
Failover in MySQL Chain Replication
We have a 4 server setup, 1 master, 3 daisy-chained slaves, in the following setup:
A (master) -> B (slave) -> C (slave) -> D (slave)
(the servers B and C and D are running with ...
- 13
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
605
views
Longer time to bring SQL online after node failover
We had a strange issue post our regular OS patching for SQL servers.
Per best practices, we apply patch on Passive and do node failovers to make current passive, active and vice versa to complete ...
- 2,169
0
votes
1
answer
934
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 ...
- 257
0
votes
1
answer
97
views
How to optimize and estimate DB recovery times?
Would like to optimize recovery time for db's after failover to passive node in high availability cluster.
Assuming full recovery model...
What are the steps to take to optimize DB recovery time for a ...
- 1,087
-1
votes
1
answer
587
views
Availability Group is not failovering when a cluster core resource is failedover
I have created always on availability group.The cluster core resources failover is happening. The availability group (Automatic) failover is happening. But, when the cluster core resource is failed ...
- 15
0
votes
1
answer
60
views
AAG trigger a query when failing over
I'm running a Failover cluster on windows 2016 servers (2 nodes) where I set up an AG in SQL 14.0.2027.2
This works good and I'm happy. But when it failover I need to fix my logins so I need to run a ...
- 1
0
votes
1
answer
135
views
How to configure Oracle traffic director for full site failover to have high availability?
I have two server systems, each server having both Apache Tomcat server (deployed web app) and Oracle 11g database server. The database on the two servers is synchronised by Oracle Data Guard for high ...
1
vote
1
answer
4k
views
Error Failover in Always on high availability groups
We have a problem with Always on high availability groups in Microsoft SQL Server 2016 (SP2) , When we want to failover to the secondary node manually, it fails because of this error:
Failed to ...
- 41
1
vote
1
answer
2k
views
SQL Server AlwaysOn: Lost of heartbeat and connection with secondary replica
Virtual Enviroment description:
Hypervisor: VMWare
WSFC composed by two nodes with Windows server 2016 Standard
SQL Server AlwaysOn with synchronous replica and automatic failover
SQL Server 2014 (...
- 107
2
votes
1
answer
432
views
REPMGR - change reconnect_attempts and reconnect_interval not working
I configured PostgreSQL automatic failover with REPMGR. But, in my simulation the sleeping time is 1 second for each reconnect attempt:
If I consult official documentation the default value to ...
- 314
1
vote
0
answers
28
views
Notification for host failure and health status [closed]
I set up a MongoDB cluster with replica sets.
I wish to have something like a dashboard or a "health status". My current solution is to connect to the cluster and query the replication state ...
- 11
2
votes
1
answer
558
views
AlwaysOn failover DR testing
I have always-on group running on 4 node cluster. Each DC has 2 node running on it
Data Center1:
Node1: Sync Replica - Automatic failover
Node2: Sync Replica - Automatic failover
Data Center2:
...
- 117
0
votes
1
answer
1k
views
In Postgresql 12 how to I make the primary server a slave after a deliberate failover
I am using PostgreSQL 12 on Debian 10.6.
I have been reading up about replication and I have set up an asynchronous replication between one primary and standby. I wanted to test failover so I stopped ...
- 95
6
votes
2
answers
1k
views
Availability Group - how much data was lost after forced failover
Let's consider a SQL Server AlwaysOn cluster with two nodes in asynchronous replication.
Is there any way to calculate how much data was lost after forced failover?
I mean in terms of time, to be able ...
- 107
0
votes
1
answer
903
views
MongoDB 2 node cluster
I am trying to understand the implications of setting up a 2 node MongoDB cluster with the following configuration (Documentation does say a minimum of 3 nodes is required).
MongoDB Version is 3.2.
If ...
- 997
-1
votes
2
answers
2k
views
how to failover in log shipping?
I am reading the book 'Pro SQL Server 2019 Administration' from Carter, where in the Log shipping section he mentions:
"Unlike other high availability and disaster recovery technologies, an
...
- 261
7
votes
6
answers
2k
views
Why is there automatic failover for HA and manual failover for DR?
I am reading this summary from the book 'Pro SQL Server 2019 Administration' from Carter:
And it specifies:
hot → automatic failover → used for high availability (HA)
warm → manual failover → used ...
- 261
0
votes
1
answer
554
views
Failover and DNS propagation delays
When a DBMS fails over after a failure, if it fails over to a server in a different and unrelated data center, then the IP address of the subdomain name of that database will need to be changed in ...
- 189
0
votes
1
answer
639
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
125
views
What is difference between Lease Timeout and HealthCheck Timeout in AlwaysON?
this question was asked twice here but still there is no satisfied answer. Could someone explain the main difference between these two timeouts?
- 1,253
1
vote
2
answers
87
views
SQL Server cluster node fail over details
I would like to know the SQL Server cluster node fail over details immediately as soon as the passive node is active as I have some dependency on active node. For that, I see sys.dm_os_cluster_nodes ...
Sriram
0
votes
1
answer
163
views
Automatic Failover At Always On High Avability Group SQL SERVER
after i read on documentation
https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-clustering-and-always-on-availability-groups-sql-server?view=sql-server-ver15
i ...
- 47
0
votes
1
answer
722
views
MS SQL Server 2016 - Always On Node-2 Stuck In Resolving State
For testing the Always On structure; we suddenly shut down the machine on which Node-1 was running. So we wanted to see that Node-2 turns primary. However, Node-2 was stuck in resolving mode.
3 ...
- 55
0
votes
1
answer
2k
views
Good practices for patching SQL nodes in High Availability solution [duplicate]
Our database structure utilizes two roles in the Window Failover Cluster Manager.
One is for FCI - switching between the active/passive node in the Primary Data center.
One is for SQL Availability ...
- 202
0
votes
1
answer
77
views
SQL server Log Shipping
I have two node SQL server standard failover cluster.
I need to setup single node DR using log Shipping method.
Want to ask after switch over to DR how we can setup, plan so that application can ...
- 11
0
votes
1
answer
898
views
How to stop all nodes on FCI SQL server?
My Setup: We have two nodes SQL setup with Active/Passive Windows Failover Cluster instance.
My Goal: To stop the running SQL Server service on the active node and prevent failover from happening for ...
- 202
2
votes
1
answer
195
views
SQL Server Assembly on Failover cluster after Framework update
We have database that relies on a CLR assembly. The assembly references other assemblies. After a Windows Framework update we need to drop and reinstall the assembly to have it work.
Now the issue is ...
- 133
0
votes
1
answer
104
views
Increase TempDB Files, Shrink VLF's with FCI
I am planning to resize and increase the number of tempDB files and shrink the VLF's on an FCI. In this case, the tempdb files are stored on the network drive, rather than the local disk. I couldn't ...
- 1
1
vote
2
answers
475
views
What are the benefits of using Manual Failover Mode in an AlwaysOn Availability Group instance as opposed to Automatic Failover Mode?
Why wouldn't I want to use Automatic Failover as the Failover Mode for an AlwaysOn Availabiltiy Group instance?
Are there pros for Manual Failover Mode that don't exist for Automatic Failover Mode?
- 35.2k
0
votes
1
answer
437
views
Postgresql Streaming Replication on Windows failover
Hello i have setup streaming replication using PostgreSQL 11 on Windows working OK.
How can i manually use the replica ( it is hot_standby=on ) in case Master fails ?
What are the steps i have to ...
- 21
0
votes
0
answers
940
views
Why is my Availability Group in an unhealthy state and showing synchronizing?
I have an active directory and 3 SQL Server nodes in an availability group.
The primary and secondary node are on different subnet to active directory: 104.92.173.x
The third node which is in async ...
- 111
1
vote
2
answers
111
views
MySQL replication master-slave
I'm learning master-slave replication with MySQL and I could get it to work and also use the Percona backup tool to restore a slave. I learnt from this project https://github.com/vbabak/docker-mysql-...
1
vote
1
answer
86
views
64 Availability groups max on SQL STD : Failure when attempting to create a new NetBIOS interface while bringing a resource online
I was patching our DB Servers this morning and encountered a really strange error when failing over some Availability Groups :
In our environment, we are running a somewhat unconventional setup, but ...
- 540
0
votes
0
answers
45
views
How does sql server FCI respond to failure?
Taking windows role default settings - (n-1) failovers ok within 6 hrs , where n=# of nodes, if nodes = 2, 1 failover within 6 hrs is allowed.
Taking resource default settings - Within 15mins period, ...
- 21
1
vote
1
answer
26
views
ALTER USER statement modifies users on off-air node
I had previously asked a question about Orphaned Users here and was directed to this link in an effort to fix it, but this didn't seem to answer my questions, so I am re-asking after some further ...
- 37
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
0
votes
2
answers
528
views
PostgreSQL failover: Who is responsible for handling it? How do clients connect to the new leader?
On a high level, consider two PostgreSQL instances on two separate nodes: the leader and its hot standby. Replication from leader to follower is configured.
Consider that the leader node crashes. Two ...
- 101
0
votes
2
answers
999
views
If I manually failover my AlwaysOn AG primary replica to the secondary and take the primary database offline will it auto-sync when back online?
I have an AlwaysOn AG setup between Database A (primary replica) on Server 1 and Database B (secondary replica) on Server 2.
If I force a manual failover from my primary replica on Server 1 to the ...
- 35.2k
1
vote
1
answer
28
views
Database Mirroring - Will forcing the service only lose non-committed data?
I have a database mirroring session in high safety mode between Server1 (Primary) and Server2 (Secondary)
According to this, synchronous data mirroring means
every transaction committed on the ...
- 1,928
0
votes
1
answer
41
views
Does this plan work as a Failover strategy-SQL Server 2016 Standard Edition
We have two SQL Server 2016 Standard edition (standard edition due to budget issues) configured one as primary sql server and another one as fail-over server.
I have implemented Transactional ...
- 1,305
0
votes
1
answer
533
views
PostgreSQL 9.6 pg_rewind - takes a long time to replicate
I use Streaming Replication,and Replication works normally.
Two servers are HA and PostgreSQL DB is replicated.
The data in the DB is about 40G.
When a failover occurs, the slave is successfully ...
2
votes
1
answer
404
views
Trigger SQL Agent job based on text in error log for an AG failover
I have a 2 node AG setup (Not an FCI). I need to configure an alert to trigger a job based on a string found in the error log showing that the node is now the new primary.
The string I want to use is:
...
- 257
0
votes
0
answers
156
views
How to set an IP for automatic failover with repmgr can been accessed from application?
OS: CentOS
DB: PostgreSQL
By repmgr, set replication and automatic failover on 2 database servers successfully.
ID | Name | Role | Status | Upstream | Location | Priority | Timeline | ...
- 309
0
votes
1
answer
333
views
HA and Automatic Failover with PostgreSQL
The most popular third-party tools are pgpool and regmgr.
pgpool can do HA and automatic failover, regmgr can also do replication and automatic failover. Some articles show using both of them to do ...
- 309
-1
votes
3
answers
374
views
How to maintain a query that runs forever?
I would like to run a query that finds prime numbers, and I would like to run it forever.
@Solomon Rutzky on this page Prime numbers in a given range , give us a good example of the Sieve of ...
- 1,504