MySQL Master-Slave Replication: Setting Up

http://www.sitepoint.com/mysql-master-slave-replication-setting-up/

By Panayotis Matsinopoulos | February 15, 2012 | Open Source | PHP & MySQL Tutorials | Web Tech

8

• Email
• Print

Very recently, at Fraudpointer.com, having reached a database of 25Gb after just six months of operation, we decided to start using replication for our backend persistent storage.

Why would you want to do that

Replication of MySQL can be a solution to various problems that you might want to solve:

• Scale-out solutions
• Data security
• Analytics
• Long-distance data distribution
• Backup taken from slaves, rather than from master

MySQL documentation on replication, that can be found here, is quite explanatory and gives more detail about these uses.

Where have we been?

Before implementing replication, we had a configuration such as the following:

• how to remote access mysql server