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.
364
questions
3
votes
1
answer
911
views
SQL Server 2005 - Map login to pre-existing user
The short of it is that we have several databases that are synchronized between two failover instances. The primary contains logins that are mapped to the users in the databases, and everything's ...
- 243
2
votes
0
answers
94
views
JBoss/Alfresco cannot write on slave after failover [duplicate]
Possible Duplicate:
JBoss don't fail over MySQL slave using datasource
I'm trying to set up an high available MySQL "cluster", using a Master / Slave Replication configuration. I want to the ...
- 188
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
1
answer
471
views
PostgreSQL synchronized commit performance
I'm setting up a pair of PostgreSQL servers. Because cash is short I can only afford one high class server and some crapy backup box. If the expensive high end box should catch fire, operations can ...
- 567
3
votes
1
answer
1k
views
Dual management node for mysql clustering
I currently have mysql cluster setup and running.
Here is my current setup:
1 - management node
2 - data nodes
2 - mysql nodes
I wish to incorporate a failover for the management node. The ...
10
votes
2
answers
25k
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?
- 2,323
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
2
answers
2k
views
Is this procedure to Failover to Logshipped secondary and Fail back again procedure correct?
I have a primary database in Amsterdam (AMDB), and a secondary in London (LNDB). I want to fail over from AMDB, to LNDB and then back again, without having to make another full backup (because the ...
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
15
votes
1
answer
6k
views
PostgreSQL failover and replication
I'm evaluating PostgreSQL 9.1 and have few questions related to failover and replication details.
I have few test scenarios. First one with a Master server and few Slaves. In case Master crashes I ...
- 253
1
vote
2
answers
800
views
Microsoft SQL 2008 Cluster with replication
i am in the process of setting upi a SQl Server 2008 64 bit Failover cluster.
A lot of the database queries that we are running during the days are db intensive and lock a lot of the tables while ...
- 183
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
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
4
votes
2
answers
3k
views
SQL Server DR Plan - Test Documentation
I have been tasked with creating a document for the testing of our DR/BC Plan for our SQL Servers. We are using DB Mirroring (tier-1) and transaction log shipping (tier-2) and for tier-3 databases we ...
- 161