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
8
votes
1answer
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 ...
3
votes
3answers
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 ...
11
votes
2answers
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 ...
3
votes
3answers
3k 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 ...
3
votes
1answer
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 ...
48
votes
4answers
34k 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 ...
18
votes
3answers
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 ...
6
votes
2answers
3k 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 ...
5
votes
1answer
843 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, ...
3
votes
1answer
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....
2
votes
1answer
277 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 ...
2
votes
2answers
3k views

Change port number for SQL 2012 Cluster

I have been trying to change the port number of a SQL 2012 cluster with little success. I had thought that I could just do this the same way as normal through configuration manager however, even with ...
2
votes
2answers
436 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
vote
1answer
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 ...
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 ...
5
votes
1answer
14k 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 ...
3
votes
1answer
3k views

How do I switch master with slave and vice versa on MySQL?

I have two instances of MySQL, one master and one slave. How can I switch them to make the slave the master and vice-versa while avoiding downtime?
2
votes
3answers
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 ...
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 ...
1
vote
2answers
664 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 ...
1
vote
0answers
334 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 ...
1
vote
2answers
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 ...
0
votes
2answers
1k 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 ...
0
votes
1answer
711 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 ...