Take the 2-minute tour ×
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.

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
add comment

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.

share|improve this answer
add comment

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

share|improve this answer
add comment

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/

share|improve this answer
add comment

Your Answer

 
discard

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.