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.
287
questions
1
vote
1answer
12 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 ...
1
vote
0answers
38 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
42 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
0answers
18 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
12 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 =...
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 ...
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
99 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
1answer
29 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:
...
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 | ...
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 ...
-2
votes
3answers
182 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 ...
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
83 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
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
396 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 ...
0
votes
1answer
37 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
334 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
0answers
124 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) ...
3
votes
1answer
346 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
86 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
84 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
260 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?
2
votes
1answer
149 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 ...
0
votes
0answers
152 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 ...
2
votes
1answer
66 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). ...
3
votes
1answer
130 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 ...
0
votes
1answer
31 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 ...
0
votes
2answers
181 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
vote
1answer
49 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 ...
1
vote
1answer
261 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 ...
1
vote
0answers
2k 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 ...
1
vote
2answers
525 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
Windows 2016 Workgroup failover cluster
I am building a two node Window failover cluster for SQL Server AG. I am getting following errors in the cluster log.
Please help me to resolve the error.
Thanks
1
vote
2answers
92 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 ...
1
vote
1answer
727 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,...
1
vote
0answers
211 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
...
1
vote
0answers
46 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 ...
1
vote
0answers
18 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 ...
0
votes
1answer
89 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 ...
0
votes
0answers
147 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 ...
-1
votes
1answer
158 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
1answer
37 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 ...
0
votes
1answer
246 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
1answer
529 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 ...
0
votes
1answer
156 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
vote
1answer
153 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.
0
votes
1answer
62 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 ...
