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.

Filter by
Sorted by
Tagged with
1
vote
0answers
33 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 ...
0
votes
0answers
41 views

Preferred owner failover change in FCI

I've inherited a few Windows servers with SQL Server installed. Some of them are in failover cluster which is perfect in case of outages. However I do not have much experience with SQL Server ...
0
votes
1answer
85 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 ...
1
vote
1answer
78 views

Quorum disk conundrum

I'm having a problem with a 2-node active-active cluster which has been failing over lately but not bringing resources back online. We've had a Microsoft engineer look at it and, among other things, ...
2
votes
2answers
2k 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 ...
0
votes
2answers
403 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 ...
0
votes
0answers
16 views

How to promote a PostgreSQL standby server by repmgr automatically with pgbouncer and barman?

Now using these servers: Node1: pgbouncer1 Node2: pgbouncer2 Node3: repmgr primary Node4: repmgr standby Node5: repgmr standby Node6: repmgr standby Node7: barman primary Node8: barman passive ...
0
votes
2answers
59 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 ...
0
votes
0answers
11 views

Postgres replica out of sync

we have a postgres 9.6 replica configured among 2 servers. We used the following configuration to create the replica: postgresql.conf wal_level = hot_standby max_wal_senders =...
5
votes
1answer
449 views

Mysqlfailover command - No slave is listed in health status

I have successfully created replication using GTID_MODE. It works perfectly. Now I need to setup automatic failover feature in it. I have run the following command. mysqlfailover --master=root:abc@10....
2
votes
1answer
584 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 ...
0
votes
1answer
208 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 ...
0
votes
2answers
51 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 ...
3
votes
1answer
325 views

SQL Server 2014 Availability Group failed

I have 3 servers on VMware workstation: Win 2012 R2 as ADDC -Cluster service. Win 2012 R2 as SQL server primary replica . Win 2012 R2 as SQL server secondary replica (auto fail-over). My ...
1
vote
1answer
14 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 ...
0
votes
1answer
25 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 ...
0
votes
1answer
94 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 ...
1
vote
1answer
4k 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 > ...
0
votes
1answer
574 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-...
2
votes
1answer
28 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: ...
5
votes
1answer
684 views

Replication throw an error after failover mirror partner is down in SQL Server

Received an error mentioned below after failover when mirror partner is down. Error : to fail over to a database which is not configured for database mirroring. code: 22037, text: 'Invalid ...
2
votes
2answers
2k views

MySQL failover - Master to Master Replication

My company is trying to implement a MySQL failover mechanism, to achieve higher availability in our webservices tier - we commercialize a SaaS solution. To that end we have some low-end VMs scattered ...
1
vote
2answers
517 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, ...
0
votes
0answers
18 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 | ...
-2
votes
3answers
181 views

How to maintain a Database with stored procedure that runs forever?

I have an interesting question and I cannot find a reply. I would like to create a database of prime numbers. On this page Prime numbers in a given range , I can find various examples of SQL code ...
2
votes
2answers
204 views

Agent service account shows as not clustered

One of the SQL Server 2008 R2 instances I administer is running on a two node Windows Cluster (Windows Server 2008 R2 Enterprise) When I run the DMV sys.dm_server_services, SQL Server Service Account ...
0
votes
1answer
48 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 ...
0
votes
3answers
99 views

Need to configure Availability Groups between three different SQL failover instance

We have total 6 Nodes and 3 failover cluster (Each with two node). Cluster1.TestAD.com(Node1,Node2) - SQL Failover Instance (SQL1) - 1 TB Shared storage Cluster2.TestAD.com(Node3,Node4) - SQL ...
0
votes
1answer
6 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 ...
2
votes
2answers
81 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 ...
0
votes
1answer
66 views

Failover Mirror

My question is about the failover process in SQL Server Mirror. If just the database, not a instance or a server, goes offline or is unreachable, will failover occur to the secondary server or is it ...
-1
votes
1answer
214 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 ...
0
votes
0answers
28 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 ...
1
vote
1answer
376 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 ...
1
vote
1answer
438 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 ...
0
votes
1answer
36 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
vote
2answers
312 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 ...
0
votes
1answer
589 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 ...
3
votes
1answer
1k views

SQL Server 2012 failover cluster node won't start cluster services

We have 2 node SQL server failover cluster setup in our environment. Node2 SQL server machine got shut down. I turned it back on and connect back to the failover cluster. It successfuly ...
0
votes
0answers
121 views

Repmgr service crashes during automatic failover, slave's upstream node points to failed master - PostgreSQL

We are using Centos7 with PostgreSQL 11.5 and Repmgr 4.4 in our system. We have setup an automatic failover system using Repmgr with a 3 node cluster (1 master - Server A, 2 standbys - Server C and F) ...
4
votes
1answer
11k 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
votes
1answer
339 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 ...
1
vote
1answer
83 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 ...
2
votes
2answers
83 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. ...
2
votes
1answer
258 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?
6
votes
1answer
2k views

The definition of object '[sp_name]' has changed since it was compiled on fail-over to mirror database

We have two SQL 2012 database servers configured in a mirror with a witness for automatic fail-over. Yesterday the primary server suffered a HDD degradation which triggered the fail-over, however ...
2
votes
1answer
147 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 ...
10
votes
2answers
22k views

What are the differences between Mirroring and Failover Clustering and when is each one recommended over the other?

What are the main differences between Mirroring and Failover Clustering? What kind of problem each one solves and in what kind of scenarios is each one recommended over the other?
0
votes
0answers
150 views

Not able to add a node into windows failover cluster

I had two node cluster but due to disk corruption one node was removed. After maintenance when second node came back we tried to add it into the cluster but getting exception. I checked the even log ...
3
votes
1answer
129 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 ...

1
2 3 4 5 6