This guide is provided for users who want to test these in testing environment. Please use this guide at your own risk.
Part 4 will focus on setting up a secondary server as a backup server.
Configure MySQL replication
* For detailed information, please refer to MySQL manual
Create a replication user in primary MySQL server
mysql> GRANT REPLICATION SLAVE ON *.* TO 'replication'@'%.mydomain.com' IDENTIFIED BY 'password'
Assign Server ID and enable binary log in primary – phpmyadmin DB will not be replicated (you may want to exclude mysql DB depending on your need) Read more »
