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.
28
questions
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 ...
- 568
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 ...
- 974
49
votes
4
answers
37k
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 ...
- 8,912
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 ...
- 8,437
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
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 ...
- 188
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 ...
- 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 ...
- 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 ...
- 9,630
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 ...
- 789
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 ...
- 203
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 ...
- 597
5
votes
1
answer
861
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, ...
- 193
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
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....
- 606
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
2
votes
2
answers
684
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 ...
- 1,157
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
2
votes
1
answer
704
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
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 ...
- 163
1
vote
1
answer
674
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 ...
- 563
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 ...
- 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 ...
- 815
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
0
answers
394
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 ...
- 121
0
votes
1
answer
855
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 ...
- 111
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
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