Replication

Adding a Slave MySQL Server Using Percona Tools

Submitted by Randall Box on

The ability to create replicated servers using MySQL is one of the most useful features. You can create slave servers for redundancy, load balancing, development or testing purposes, and MySQL takes care of keeping the servers in sync. I will review simple slave server setup using the binary log (transactional) method.

Assumptions

The procedures below will work in many environments, but I outline mine as a reference point. You may need to alter the commands to work in yours.