What are the best resources you've read or watched about setting up master/slave or clustering for database replication?

I don't know much about this. I have a database that is getting rather large and would like to make sure that if something goes wrong, I at least have some basic database infrastructure going on so I can recover data.

I'm using MySQL. I'm guessing that I do just as many reads as writes.

3 Answers 3


Forgive me for sounding somewhat biased, but you can learn about setting up Master/Slave and Master/Master Replication right here in the DBA StackExchange.

Here are some of my posts

I also have posts concerning

Click here to see all MySQL Replication posts in the DBA StackExchange (not just mine)

There is only one thing I cannot give advice on : MySQL Cluster

While I have answered some questions, there are three MySQL Cluster Experts here

Feel free to post your MySQL Replication questions or simply search through the already posted questions. You may find that what you are looking for is already answered.


Disclosure: I work with the MySQL replication and MySQL Cluster teams

The best resources to get started for Replication are the Intro and Tutorial whitepapers posted here: http://www.mysql.com/why-mysql/#en-0-38

For MySQL Cluster, the evaluation guide provides insight into Cluster use cases and best practices for building a PoC: http://www.mysql.com/why-mysql/white-papers/mysql-cluster-evaluation-guide/


A great place to start is an Internet search, using your browser.

For instance, https://duckduckgo.com/?q=mysql+clustering turns up a huge amount of relative and timely pages for your perusal.

For starters, I would read https://www.mysql.com/cluster which is literally the book on clustering.

Here's another great one: http://www.howtoforge.com/loadbalanced_mysql_cluster_debian

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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