Using Replication

From Hashmysql
Jump to: navigation, search

Setting up Replication

This link should cover pretty much everything you need to know:

http://dev.mysql.com/doc/mysql/en/replication-howto.html

Setting up Replication with just one database

Modify the `GRANT REPLICATION SLAVE' command like this:

GRANT REPLICATION SLAVE ON db_to_replicate@* [...]

and make sure you have included the following option in the slave's my.cnf:

replicate-do-db=db_to_replicate