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.
363
questions
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
2
answers
674
views
SQL Server 2014 Standard FCI Does Not Failover
Have a peculiar case where a previously working FCI, after installing a large backlog of Windows updates, is now failing often and not failing over. On occasion, and this appears to happen around ...
- 123
1
vote
2
answers
2k
views
How do I automatically enable or disable report jobs at AOAG failover?
I have an AlwaysOn Availability Group with 2 DB servers. I'm attempting to use SQL Server Agent Alerts to programmatically disable a handful of SQL Server Agent jobs (that must not run on a secondary) ...
2
votes
1
answer
876
views
Migrating Production SQL Servers (Availability Group) from one data center to another - questions
We have two SQL servers combined into Availability Group in data center 1 (dc1):
dc1 server 1: SQL Server 2012 SP3 on Windows Server 2016
dc1 server 2: SQL Server 2012 SP3 on Windows Server 2012 R2
...
- 5,462
0
votes
2
answers
3k
views
MongoDB Replica Set Failover due to unreachable SECONDARY resulted in Rollback
I have a 3 member replica set with 1 primary, 1 secondary and 1 arbiter. Due to some apparent network issue, the secondary was unreachable. After some time, the secondary became the primary and caused ...
- 101
3
votes
1
answer
776
views
do single AZ AWS RDS instances self heal?
I'm aware of "multi AZ" databases "auto failing over" if one side goes down. My question is, if you have a single AZ RDS database, and the database box "dies" does AWS automatically spin up a new one ...
- 1,224
3
votes
2
answers
3k
views
Availability Group, asynchronous mode, manual/forced failover - handling identity overlap
We have a two replica 2017 Standard Availability Group in asynchronous mode. With a failover (manual/forced, since can't do automatic), we have the potential for overlapping/reused identity values if ...
- 83
0
votes
1
answer
760
views
Log Shipping failover when Primary is not accessible
Log Shipping Fail-over
I have set up log Shipping with Cluster. In this scenario I want to simulate a situation when the whole cluster becomes inaccessible.
My Steps for fail-over will be
Copy and ...
- 1,039
2
votes
1
answer
981
views
Why configuring automatic failover for SQL availibility group feature on sql failover cluster instance not allowed
I have set up an availability group where a primary is standalone server and replica is SQL failover cluster. This setup allows me only manual failover and when ever I try to set it automatic in FCI ...
- 167
0
votes
1
answer
2k
views
Can auto failover cause split-brain? (SQL AlwaysOn)
I have been studying Cluster voting and AlwaysOn failover. The topic of split-brain comes up and sounds terrible. This following from Microsoft seems to indicate that only a person with SA, doing ...
- 6,178
0
votes
1
answer
450
views
How to prevent data loss during intra-site failover
We are looking to build a MS SQL server (either SQL server 2016 standard or enterprise edition) solution but are having some troubles. This post can be lengthy and if you think it is TLDR, our ...
- 11
0
votes
2
answers
1k
views
SQL Failover Clustering with Availability Groups: Single or Multiple Databases
Company wants to implement AlwaysOn SQL Failover Clustering with Availability Groups, for server level and data protection.
Are arrangements below, only possible if 1 database is on the server, or ...
user129291
0
votes
1
answer
974
views
Migrate from SQL Server 2016 Failover Cluster to Availability Groups
We have a 16 node SQL Server 2016 failover cluster with around 20 SQL Server instances and total number of databases around 600.
Since we are upgrading our hardware to Hyper-Converged infrastructure ...
- 111
1
vote
1
answer
896
views
SQL Always on availability with failover and mixed authentication
I have 2 boxes running SQL Server 2016, and set up using Always On Availability. I have a listener set up to choose which server to talk to in case of a failover, which seems to work fine, except for ...
- 277
3
votes
2
answers
2k
views
In 2-node cluster using failover with Dynamic Quorum, is Witness needed?
I have a 2-node cluster on SQL Server 2016 Standard with failover clustering configured with Dynamic Quorum.
There is one thing that made me confused: do we really need a Witness in this case?
Since ...
- 145
0
votes
1
answer
1k
views
SQL Server Standard Edition Failover Cluster Installing Windows Updates
i have a question concerning the installation of sql server updates on a sql server 2012 standard edition failover cluster.
For example a service pack installation. Is it possible to install the ...
- 81
0
votes
2
answers
3k
views
Always on Failback
Does always on supports automatic failback like sql cluster? Since the preferred owners and possible owners are controlled by the AG how can a particular node be set as preferred primary when failback ...
- 644
0
votes
1
answer
318
views
Automatic failover support on SQL Server having only two servers
We have two servers each one occupied by a dedicated storage. I am looking for the a way to setup these two servers to provide a database on MS SQL Server with automatic fail-over support.
Using ...
- 101
0
votes
1
answer
2k
views
SQL Clustering Preferred Owners
I noticed that in the sql failover clustering under the possible owners none of the nodes has been checked, I have a two node cluster does that mean in the event of failover it will failover to any of ...
- 644
0
votes
1
answer
519
views
Sql clustering sql server account
Does both the sql cluster nodes needs to use the same service account ? In my environment I saw one one was using a service account and another was using a local account although the sql agent was ...
- 644
1
vote
1
answer
502
views
SQL server standard 2016 fail over cluster Amazon AWS
I am in the process of migrating to Amazon AWS and need a SQL server high availability solution. The current licence that I have is SQL standard 2016. At this time Amazon does not support shared ...
- 111
1
vote
1
answer
1k
views
Always on Failover Cluster
This is the error message I get on my replica when there is a connection timeout for few seconds with the Primary. Can anyone tell me whats going on and why are the available storage being moved as ...
- 644
0
votes
1
answer
1k
views
Connectivity timeout between cluster nodes
I lose communication between my clusters almost 1 am to 1.30 am and it shows errors like 35206 on primary, 976 on clusters, sometimes the cluster is removed due to lost heartbeat leading to 1135 error ...
- 644
0
votes
1
answer
984
views
Managing failover for MySQL nodes using HA Proxy
We have an S1<-M1<->M2->S2 setup of MySQL replicated nodes. These are now to be brought to the back-end of an HA Proxy server to split read from writes. We also intend to achieve automatic fail-...
0
votes
1
answer
2k
views
Postgresql failback without resync the data directory
Im using Master slave streaming replication in PostgreSQL. Repmgr is configured to handle automatic failover.
Once the failover happened I need to make the old master as a slave without doing any ...
- 1,910
-1
votes
1
answer
301
views
MySQL replication with DRBD - Can we use Old master as slave after failover?
I have configured MySQL replication with DRBD, and now its working fine, Incase if something happens to my master then Slave will promote as Master.
My question is after the failover(lets assume ...
1
vote
2
answers
1k
views
How is ‘tempdb’ getting used when Always On Failover happens?
How is tempdb utilized as Failover occurs?
Let's say there are two servers, server 1 is primary and server 2 is secondary. Suddenly, Failover happens, so, how does tempdb behave during this ...
- 251
2
votes
2
answers
842
views
MongoDB failover when master is stuck on IOWait?
We host a MongoDB 3.4 replica set in AWS with three nodes: a primary, secondary failover and an arbiter. Normally, if the primary instance dies, the failover to the secondary is pretty quick (10-30 ...
- 155
0
votes
2
answers
4k
views
Stopping SQL Services on Active Node [closed]
I have an active passive SQL Cluster. When I stop the SQL services on active node from SQL Server Configuration Manager, the SQL cluster doesn't failover instead shows as Partially online.
If SQL ...
- 23
2
votes
1
answer
699
views
Reaching SQL Server AlwaysOn HA listener from the Internet
I've successfully created a SQL Server AlwaysOn High Availability Group between two servers and everything seems to be working great internally. Each replica is on a separate physical location, behind ...
- 21
0
votes
1
answer
1k
views
Why primary node disconnect when set automatic failover with PostgreSQL and Pacemaker?
OS: CentOS 7.3
PostgreSQL: 9.6
/etc/hosts:
192.168.0.1 node1
192.168.0.2 node2
192.168.0.3 # VIP
192.168.0.4 # VIP
Follow this guide did PostgreSQL replication:
https://www.digitalocean.com/...
- 343
0
votes
1
answer
77
views
Can't run pcs -f cluster1.xml stonith create with PostgreSQL 9.6 on CentOS 7.3
Follow this guide to do PostgreSQL Automatic Failover:
https://dalibo.github.io/PAF/Quick_Start-CentOS-7.html
At this step:
pcs -f cluster1.xml stonith create fence_vm_srv1 fence_virsh ...
- 343
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
2
votes
1
answer
386
views
SQL Server AlwaysOn FCI vs AG Doubts
I have a big confusion between Always On FCI/AG. I know that for FCI you need to have shared disks and in-case of Hardware failure or OS failure or System reboot the instance with db, logins etc will ...
- 31
3
votes
5
answers
8k
views
Who or what initiated the failover
We have our clusters set to High Availability and manual failover. I have an alert to email DBAs whenever a failover occurs. What we would like to also see in the email is WHY and/or WHO. We have ...
- 97
2
votes
1
answer
3k
views
How to script alerts in SQL Server?
after trying out this script: Script out all alerts By Carolyn Richardson
or even the traditional way of ssms -> right click -> script alert as
none of these methods are fully comprehensive because ...
- 15.8k
3
votes
1
answer
537
views
Reporting services existing in SQL Cluster instance but unable to see on SSMS? [closed]
This is first time I am working on SQL Failover Cluster environment and I installed Reporting services on SQL server Failover Cluster Instance both Active Nodes(Node1 & Node2) and configured ...
- 1,477
5
votes
1
answer
696
views
Should Full Text Filter Daemon Service be a cluster resource?
Our newly installed and configured SQL Server Always On Availability Failover Cluster with SQL Server 2016 Enterprise Edition runs with four instances and six nodes. It includes the DB Engine Service ...
- 4,757
2
votes
1
answer
6k
views
How long does a failover for SQL Server Availability Groups take? [closed]
In trying to determine the most appropriate High Availability option we are focused on reducing downtime (either planned or unplanned). I've been able to gather stats (from reading lots of MSDN ...
- 3,234
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
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
8
votes
4
answers
2k
views
Is "AlwaysOn" not always "Always On?"
We created a Windows Failover Cluster, then added two instances of SQL Server as nodes of a SQL Server failover cluster.
We set the servers to use "AlwaysOn Availability Groups" in SQL Configuration ...
- 187
2
votes
0
answers
91
views
Fault tolerant cross datacenter MySQL replication & failover strategy [duplicate]
Which of the following method is the most fault tolerant way to achieve cross datacenter MySQL replication using DNS failover and why?
MySQL master-master replication with one primary/active node and ...
- 121
3
votes
1
answer
596
views
High availability SQL Server without Active Directory
I'm fairly new to SQL Server. I'm looking to achieve a highly available SQL Server setup where if the primary database fails, the backup database takes over. What would you guys recommend?
I'm ...
- 179
3
votes
3
answers
2k
views
MySQL H.A with automatic failover
MySQL has a lot of different highly available solutions, I would like to know what are the differences between all the current implementations, here are the implementations that look currently up to ...
- 173
2
votes
3
answers
3k
views
Risks of manual failover in Always On Availability Groups
In my environment, I have SQL 2014 with Always On Availability Group for databases in asynchronous with manual fail over.
We have 1 primary and 2 secondary replicas--secondary1 and sec2.
I have to ...
- 45
1
vote
2
answers
1k
views
How can MongoDB elect a new primary when a datacenter has failed?
I am curious about the following situation when setting up a MongoDB cluster.
2 Datacenters, 2 nodes in each data center for a total of a 4 node replicaset. One of the two datacenters has become ...
- 600
1
vote
1
answer
5k
views
How does trigger file in recovery.conf work?
Can someone explain how the trigger_file in recovery.conf works?
As far as I know the standby server will become the primary server when it detects the trigger_file. But how will the trigger_file be ...
0
votes
1
answer
93
views
Storage does not failover in Windows cluster
I created a lab setup for a 2 node cluster using Windows 2012 R2. I first configured the quorum and performed a failover between both the nodes, the quorum would also map to the respective node. But ...
- 625
0
votes
1
answer
758
views
Adding secondary replica from different subnet for AlwaysON
If I understood the configuration of setting up a multi subnet AG setup where 2 nodes are in one datacenter and the 3rd node in another, I was under the assumption that we require 2 listner ip's - 1 ...
- 625