Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. 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 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.

share|improve this question

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.

share|improve this answer

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:

For MySQL Cluster, the evaluation guide provides insight into Cluster use cases and best practices for building a PoC:

share|improve this answer

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

For instance, turns up a huge amount of relative and timely pages for your perusal.

For starters, I would read which is literally the book on clustering.

Here's another great one:

share|improve this answer

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.