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
1
answer
24
views
SQL Replication groups in Windows failover clusters RRS feed
I have a scenario where there is a Cluster of 2 Windows servers that have SQL Standard. Between those servers is replication, and we need to use replication groups for each database, what is the best ...
King Joe Joseph El-Housseini
2
votes
2
answers
1k
views
what happens to user connections when an AG fails over?
I'm not sure quite how to word this, but I am looking for anything a DBA can do (things outside of changing code in the application) to reduce the impact to users when an AG fails over.
We have a 2 ...
- 257
0
votes
0
answers
169
views
Mongo primary failover causes rollback
I have a replicaset that processes largish batches of inserts (a few million) every night. Last night, the primary failed over and went into a rollback state. All clients which access this replicaset ...
- 135
2
votes
1
answer
6k
views
I would like to understand better the difference between "sql server stand alone" and "sql server failover instance"
AS these question asks:
Are "Always On Failover Cluster Instances" and "SQL Server Failover Clustering" the same thing?
Shouldn't Windows Server Failover Clustering already ...
- 7,374
0
votes
1
answer
206
views
MariaDB Master / Slave failover / failback automation
Good day all, I'm hoping someone might be able to point me in the right direction.
I'm working on a new dual data center project, and I'm trying to come up with a plan for failover (for patching and ...
- 1
3
votes
2
answers
6k
views
SQL Server Always-On Availability Groups LeaseTimeout
One of my AG environments encountered the error
The lease between availability group XXXXXXX and the Windows Server
Failover Cluster has expired. A connectivity issue occurred between
the ...
- 193
3
votes
1
answer
978
views
Availability Groups automatic failover is not so automatic
Behavior when I stop SQL Server Service :
The availability group fails (resolving on SECONDARY SQL SERVER and fail state on Cluster management).
SQL Server does not connect with the Cluster ip (I'm ...
- 7,374
1
vote
1
answer
152
views
TFS Installation Fails over to mirroring secondary despite not having a Fail-over partner specified
We have TFS Version 15.105.27412.0 installed on a server (Server A) and have it configured to point at our database server (Server B).
We have the two TFS databases (tfs_defaultcollection and ...
- 1,928
2
votes
2
answers
205
views
Failover strategy for SQL Server 2016 Standard Edition
I am using SQL Server 2016 Standard Edition.
I have two database servers, SQL01 and SQL02 with only one database, and I am utilizing transactional replication for bringing data from SQL01 to SQL02.
...
- 1,305
3
votes
2
answers
2k
views
History of cluster failover
Is it possible to get a history of when a cluster failed over and which node became the active node?
- 437
2
votes
1
answer
458
views
Database level health check did not trigger failover on losing a disk
I'm testing the new database level detection option in 2016 SQL Enterprise SP2 CU7 edition, and it does not seem to be working as expected. We have a 2 node setup, synchronous commit, automatic ...
- 257
3
votes
1
answer
129
views
SQL Server takes an hour to fail over to secondary node
I am at a new job, we have a 2008 R2 (SP1) WSFC which hosts SQL Server 2008 FCI.
Each node has it's own storage, nodes are 32 core with 32 GB memory (don't ask me why it is configured this way). ...
- 39
3
votes
1
answer
306
views
Unexpected failover of RDS-MySQL server
We have a 16GB RDS-MySQL Multi-AZ instance. Of late, it has unexpectedly failed over multiple times causing the dependent application to be offline for over 15 minutes.
AWS-Support blamed it on high ...
- 418
0
votes
1
answer
90
views
Fail-over or switching the Reporting server database
I have two databases in server, dbs-01.One is a transactional database and a reporting server database.Reporting is minimum,that is why we have it together in the same instance.
I have transactional ...
- 1,305
0
votes
2
answers
698
views
Transaction Replication as DR solution
I have a production database server and a failover database server set up.
All the transactions from the primary production db server is being replicated(transactional replication with initialize ...
- 1,305
1
vote
1
answer
76
views
How To Prevent Live Servers From Detecting a Forced Failover?
We are using an AlwaysOn Availability Group in SQL 2017 on Windows Server 2016 which consists of two servers on our primary site and one DR server on a remote site.
We recently did an internal IT DR ...
- 13
1
vote
1
answer
2k
views
Data Loss when forced failed over to secondary replica on Sql Server 2014
Setup:
2 Availability Groups
2 Replicas on Synchronous Commits.
1 Replica on Asynchronous Commit.
Automatic Failover configured for the two replicas on Synchronous Commits.
Manual Failover ...
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
2
votes
2
answers
2k
views
How to fail over availability groups on multiple remote servers
We have many SQL Server installations with availability groups. During our maintenance window, we will need to fail over all the HA groups to secondaries, patch the primary servers, then fail back, ...
- 31
1
vote
2
answers
532
views
MySQL failover: how application can be switched to a new master in master-slave configuration?
In my case I have two MySQL servers. One is master and second one is slave.
When slave is not available, my application can read and write from/to master.
When master is not available, assume there ...
- 113
2
votes
1
answer
4k
views
PostgreSQL: pg_rewind complains about wal_log_hints = on not been set, it is
I'm rather new to pg so please bear with me.
I've set up two hosts and installed pg10 on both. Then I configured log streaming replication between them. This worked fine.
I wanted to test fail over,...
- 123
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
0
votes
1
answer
143
views
Availability Group Upgrade 2012 to 2016 Data Move
I'm working with a team to upgrade a four node AlwaysOn Availability Group from SQL Server 2012 to 2016. Two of the nodes are local and two are in Azure. The database holds a large amount of data (2 ...
- 101
0
votes
0
answers
333
views
TDE Enabled DB Always Going Into "Recovery Pending" on Secondary Node [duplicate]
I have a Windows Failover Cluster set up with SQL 2016 Enterprise SP2. TDE was implemented on a DB, on node1 the DB is able to start without issues. However, when a failover occurs, on node2 the DB ...
- 61
-1
votes
1
answer
682
views
Automate setting secondary node to primary when majority nodes are down-MongoDB
There are many ways to force a secondary node to become a primary when majority nodes are down in mongo replica set. But we need to do this manually. For eg, forcing reconfig:
cfg = rs.conf();
cfg....
0
votes
1
answer
187
views
Remove Windows FCI completely
When I built the cluster I forgot to uncheck the storage. It's now giving me all sorts of errors. How can completely remove the cluster so I can rebuild it?
This is a 3 node cluster and I evicted two ...
- 663
0
votes
1
answer
811
views
MultiSubnet Failover with RegisterAllProvidersIP 1
I am using a 2 node SQL AG (2014 EE) (each on a different subnet) and the Listener is configured with 2 Static IPs. The client application uses SQL Native Client 11.4.
My understanding is that this ...
1
vote
1
answer
3k
views
Listener IP not changing after failover
We have a multi-subnet AlwaysOn availability group. There are 2 subnets and those are listed on the cluster and also the listener. Whenever I fail over and ping by the listener name it still shows ...
- 1,039
0
votes
1
answer
429
views
File Share Witness with 4 Node Cluster
I am building a cluster of 4 nodes along with a file share witness. Every month due to server updates the server that holds the file share will need to be rebooted. My question is while the file ...
- 1,039
1
vote
1
answer
367
views
Sync Login PW across Multiple Instances
When attempting to failover many logins fail due to nonmatching passwords on both instances. Is there a way for me to replicate passwords to other servers for all logins which passwords do not match.
- 11
0
votes
1
answer
470
views
Azure automatic fail-over vs always on availability groups clarification
I am trying to understand automatic failover vs always on availability groups in Azure hybrid and geo-region situations:
Is it possible to have on-premises SQL databases, VM SQL databases and Azure ...
- 1,451
0
votes
1
answer
423
views
Why is my DR AG database in the "recovery pending" state?
I am trying to build an architecture where we get automatic failover for both HA and DR for our DBs using SQL Server 2016 AlwaysOn Availability Groups. When I tested this using only one Availability ...
0
votes
1
answer
767
views
Automatic fail over in Always on availability group with 3 Node in synchronous mode and 1 Node in Asynchronous Mode
I am laying out a plan where there will be 3 Node on site with automatic fail over with synchronous mode and 1 remote replica with asynchronous mode. My question is if the primary goes down which node ...
- 1,039
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
1
answer
2k
views
Edition upgrade on SQL Server failover clustered instance
We did Edition upgrade on our active node for the SQL Server instance SQL01 and that was successful.
I have a question/doubt --> Do I need to proceed the same on other node as well since SQL Server ...
- 2,169
0
votes
1
answer
919
views
IP address to use with FCI, Always On AG and Always On (AG) FCI
My understanding is that HA can be achieved using either of the below and my concern was which IP address should client applications use when connecting to SQL Server:
Failover Clustering: For this ...
- 3,440
0
votes
1
answer
517
views
Automatic failover (Clustering/Always On AG)
Let's says we have 2 nodes (N1, N2) clustered (say C1) on-site. And an Always On AG is configured between this cluster C1 and a new SQL server instance N3 (N3 is off-site).
Now, if there is a problem ...
- 3,440
0
votes
0
answers
799
views
Moving tempdb from shared to local drive in a failover cluster
We have an existing failover cluster that I would like to have the tempdb in local drive. I'm not sure how to proceed. My thought process is below:
Create two drives on each node one for tempdb and ...
- 1,039
3
votes
1
answer
4k
views
Always ON - What is the difference between the virtual cluster name and Listener
In clustering you specify DNS name/IP address of cluster that is then used by all applications. In case of failover, the same DNS name/IP address will point to the appropriate database server.
In ...
- 3,440
9
votes
1
answer
29k
views
Always On Failover Clustering vs Always On Availability Groups
I have some concerns over my understanding of SQL Server Always On. Kindly can you correct me (conceptually) where needed:
Always On Clustering and Always On Availability Groups are 2 separate ...
- 3,440
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
1
answer
2k
views
Availability Groups Failover Readinness "No data loss" and rollback of nonqualified transactions
I have Availability Groups with Synchronous Replication and Automatic Failover setup with SQL Server 2016 SP2 in my production environment.
I want to do a manual failover for patching and I have ...
- 1,477
1
vote
1
answer
2k
views
Pausing the secondary Replicas for a day in always on availability group
We are planning to make the DR as primary and do maintenance on the secondary site(Formerly Primary Site) and hence pausing both the secondaries in always on availability group for a day. I am aware ...
- 1,039
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 ...
3
votes
1
answer
121
views
Any Reason to have Regular Failover Clustering in Azure Cloud?
Is there a reason to have Regular SQL Failover Clustering when database is in Azure Cloud?
I understand the benefits having Availability Groups in Azure Cloud for Database-Level protection. People ...
user158823
1
vote
1
answer
350
views
Shouldn't Windows Server Failover Clustering already take care of SQLServer Failover Clustering?
After reading this question, Are "Always On Failover Cluster Instances" and "SQL Server Failover Clustering" the same thing?
If Windows Server Failover Clustering is installed, ...
user158823
1
vote
1
answer
791
views
Azure Failover Clustering vs On Premise Failover Clustering
Azure AlwaysOn FCI Failover Clustering IaaS VMs seem to have a different diagram compared to On-Premise Failover Clustering.
Azure has two storage for 2 Vms; Traditional On-Premise contains 1 Shared ...
user158823
1
vote
1
answer
208
views
Is it a common pattern in having two AlwaysOn Availability Groups for DR and Reporting?
We have a primary OLTP server in the cloud.
We intend to have Synchronous Alwayson Availability Group for Disaster Recovery,
and another Availability Group AAG for Ad-hoc Query Reporting.
This way ...
user158823