Where can I learn about MySQL master/slave, master/master, or clustering setups?

Question

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.

score 3 · Answer 1 · edited Apr 13 '17 at 12:42

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

May 26, 2012 : Trying to understand SHOW SLAVE STATUS\G
Jan 05, 2012 : MySQL Replication Error
Dec 23, 2011 : How to make MySQL replication reliable?
Dec 19, 2011 : Best way to setup master to multi master replication
Feb 23, 2011 : MySQL Replication - Introduce new Slave to replication

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.

score 2 · Answer 2 · answered Mar 13 '13 at 17:27

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/

score 1 · Answer 3 · answered Mar 13 '13 at 14:21

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

Where can I learn about MySQL master/slave, master/master, or clustering setups?

3 Answers3