Skip to main content

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
9 votes
1 answer
4k views

PostgreSQL Failover - What tools should I use?

Here is the scenario: There are two machines running CentOS 6.2 - machine0 and machine1 Both have PostgreSQL 9.1 installed. One of them should be active, as a master system and through asynchronous ...
wingedrhino's user avatar
4 votes
4 answers
4k views

patching SQL Server with Availability Group and Secondary Replica

Scenario: SQL Server 2014 CU6. 1 AG with 2 databases (compatibility level 100). Failover Cluster with 3 nodes on Windows Server 2012 R2. Primary Availability Replica on node 1 and node 2. Secondary ...
Razvan Zoitanu's user avatar
49 votes
4 answers
38k views

Clustering vs. transactional replication vs. availability groups

Assuming you need to make sure your application that relies on SQL Server 2012 as its database backend is available around the clock, even if one server machine fails. As a developer and not a DBA, I ...
marc_s's user avatar
  • 8,972
11 votes
2 answers
2k views

If I fail over one database, do the others that share the same mirror endpoint fail over as well?

We have two databases setup for mirroring on a single SQL Server instance: a test database and a production database. Both get mirrored to another server using the exact same endpoints. If I go into ...
Rachel's user avatar
  • 8,487
3 votes
3 answers
3k 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 ...
Kedare's user avatar
  • 173
3 votes
1 answer
5k views

JBoss don't fail over MySQL slave using datasource

I'm trying to set up an high available MySQL cluster, using a Master / Slave configuration. I want to the slave become master (e.g. not read-only but writeable) if the first node come down (like in ...
Jean-Rémy Revy's user avatar
3 votes
3 answers
4k views

Does Change Data Capture (CDC) work in a SQL Server 2012 AlwaysOn Failover Cluster Instances setup?

Does Change Data Capture (CDC) work in a SQL Server 2012 AlwaysOn Failover Cluster Instances setup? There would be two nodes in the AlwaysOn Failover Cluster Instances setup and two Domain ...
Robert's user avatar
  • 95
2 votes
2 answers
4k views

Remove a node from Failover Cluster

We had 5 SQL Server 2012 servers configured with AlwaysOn. A few days ago we dismissed 2 of them, we removed them from the availability group and then stopped SQL services. We need to reuse these ...
maurice's user avatar
  • 41
18 votes
3 answers
29k views

Automating failover in PostgreSQL 9.1

How does one setup two identical servers for automatic failover in PostgreSQL 9.1. OS Centos 5 PostgreSQL 9.1 compiled from source The postgres user account exists on both machines and has a ...
Craig Efrein's user avatar
  • 9,660
6 votes
2 answers
4k views

Force a Member to Become Primary in mongodb

I looked into answers but nothing works for me in mongo 2.6.11 cluster 'nms' (members nms01m and nms02) below. I want my current secondary nms01m to become primary, and now nms02 is primary instead of ...
irom's user avatar
  • 203
6 votes
1 answer
5k 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 ...
QFDev's user avatar
  • 789
5 votes
1 answer
862 views

Database as a service (DbaaS) over dimensions--performance, scalability, & reliability?

MySql Database as a service: Amazon Xeround Another eg. PostgreSQL Database-as-a-Service. You can get the list of similar products here. Does anyone have details on their performance, reliability, ...
jeff musk's user avatar
  • 193
5 votes
1 answer
15k views

Problem adding a new node to a SQL Server 2012 Failover Cluster

I tried to add a new node to SQL Server (2012 Standard) Failover, that is already installed on another node in Windows2012 Failover Cluster I have an issue with non editable field wiht input for SQL ...
mKorbel's user avatar
  • 597
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 ...
The One's user avatar
  • 145
3 votes
1 answer
2k views

MySql Switching Masters During Failover with log-slave-updates

I am still pretty newbie to mysql. This question is regarding promoting slave with option --log-slave-updates to become a master. The typical schema of promoting slave to master was described in 15.3....
com's user avatar
  • 606
2 votes
2 answers
2k 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 ...
DBA Greg14's user avatar
2 votes
1 answer
779 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 ...
TooManyHats's user avatar
2 votes
2 answers
708 views

Get missed transactions from slave

I'm trying to write a disaster recovery plan, I have one way replication with 1 master(A) and 3 slaves(B,C,D) A /|\ / | \ B C D Let's say my master crash, and I loose all data on ...
altmannmarcelo's user avatar
2 votes
3 answers
4k 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 ...
user2011956's user avatar
2 votes
1 answer
2k views

SQL Server 2012 Cluster Service pack 3 fail to failover node

Roughly a year ago, i had this problem with an 2008R2 cluster. I asked about it here, but i didn't grab enough logs in the process. And now i have the same problem on my 2012 failover cluster. So i'm ...
Trones's user avatar
  • 163
1 vote
1 answer
382 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, ...
user avatar
1 vote
1 answer
830 views

High availability primary does not automatically take secondary role when back online

Setup: Basic high availability 2 replicas (1 primary, 1 secondary). DB01 => initial primary. DB02 => initial secondary Synchronous commit on both Both are in synchronized state There is no ...
MichaelD's user avatar
  • 563
1 vote
0 answers
400 views

Oracle Database Gateway for SQL Server - Connect to a SQL Server Mirroring Session

An Oracle Database server is using Oracle Database Gateway for SQL Server to define a Link Server to a Microsoft SQL Server. For the database on Microsoft SQL Server, Mirroring has been configured. So ...
Reza Aghaei's user avatar
1 vote
2 answers
3k views

MS SQL Server 2012 Log Shipping Questions

I have a few questions regarding Log Shipping in SQL Server 2012. If the primary database server dies, is it possible to allow users to connect to the secondary database so as to continue working ...
pgunston's user avatar
  • 665
1 vote
2 answers
2k views

Failover Cluster Instance work without quorum

I have a environment with three nodes with installed SQL Server on them. All three nodes are parts of FCI and quorum setting is Node Majority. In start, first node is role owner, and all three nodes ...
veljasije's user avatar
  • 815
0 votes
1 answer
19 views

Can I create a Geo Replica of a Named Replica?

For clarity, we have two databases on a server in a given region. One database is the primary for the read/write workload, and one is a replica for the read-only workload. I'm trying to set up a ...
Yossi Geretz's user avatar
0 votes
2 answers
4k 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 ...
Awanish Raj's user avatar
0 votes
1 answer
859 views

Automatic recovery on a 3 node AlwaysOn Multisite Cluster?

We are looking to build a 3-node AlwaysOn Windows 2012 R2 failover cluster with 2 nodes in our primary datacenter for HA, and a 3rd node replica in our DR datacenter for reporting. Given this is a ...
floyd's user avatar
  • 111
0 votes
1 answer
237 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 ...
Jimmy's user avatar
  • 1