1
vote
1answer
394 views

2 servers, high availability and faster response

I recently bought a second webserver because I worry about hardware failure of my old server. Now that I have that second server I wish to do a little more then just have one server standby and ...
1
vote
3answers
351 views

MySQL HA Solutions

I am evaluating the options to build MySQL HA and found the below solutions Percona XtraDB Cluster, Tungsten Replicator, and MySQL Cluster. Could you please help me to choose the best one with ...
6
votes
1answer
4k views

MySQL: Pacemaker cannot start the failed master as a new slave?

pacemaker-1.0.12-1 corosync-1.2.7-1.1 I'm going to setup failover for MySQL replication (1 master and 1 slave) follow this guide: ...
3
votes
1answer
987 views

MySQL on VMware for High Availability

Given a choice between the current database-level HA options for MySQL, like Master-Master, Cluster, or Galera, and vSphere HA for the machine running the MySQL master, which would you use or combine ...
1
vote
3answers
720 views

MySQL / InnoDB replication: how to perform crash recovery?

How do I perform crash recovery in a MySQL/InnoDB Master-Slave asynchronous replication setup? Specifically: If a slave crashes, how do I make it syncs up with the master after I bring it back up? ...
1
vote
3answers
803 views

When to use MySQL replication or DRBD for HA on Xen VM?

I'm setting up a database which needs to be needs to provide High Availabilty. My primary concern is high performance and robustness (I don't want something that will fail fast and badly). The ...
4
votes
7answers
1k views

Mixing Multi-Master Replication (MMR) with Linux-HA

I'm interested in using MMR (http://mysql-mmm.org/) for high availability and replication purposes. The problem is, I'm also interested in using Linux-HA for other services, such as Apache. The two ...