Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What are the options for having multiple mysql servers with the same database and data. I know there is replication but I have been reading that it can have issues especially if there are connection issues. Are there any alternatives to the built in replication that are reliable? Someone suggested getting a server on the same network so the mysql server can be accessed by all the servers over lan, but currently that is not an option for me.

Is mysql just not meant for replication? Is there another sql engine that is better for it?

share|improve this question
up vote 2 down vote accepted

There are a few options for replicating a MySQL database. Here are a few no-cost options:

Tungsten and Linux HA both provide failover so that the master database will automatically move to another machine if the primary master fails. However, with DRBD, the second machine is typically passive, meaning that it doesn't serve any traffic at all, while with native MySQL or Tungsten you can use the slaves for reading data.

share|improve this answer
If the slave only needs to be able to read from a single table what would you recommend? – Will Aug 18 '11 at 16:54
In order to make a choice a lot more detail is needed around your infrastructure and what you are trying to achieve. – sreimer Aug 18 '11 at 18:14
I have a vbulletin forum and want to be able to use the user information from a remote server for a WCF service. I guess I could add an api to vbulletin to request information but the issue is that the forum server goes down a lot and I would like the program that uses the user table to not go down when the forum goes down. – Will Aug 18 '11 at 18:52
In that case, default mysql replication would be fine. You can even specify the slave server to only replicate a single server – sreimer Aug 18 '11 at 23:09

The obvious answer would be MySQL Cluster Manager, it costs though.

share|improve this answer
Do I need MySQL Cluster Manager for this or can I just manually configure MySQL Cluster? – Will Aug 18 '11 at 15:21

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.