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) Continue reading “Build Ubuntu Server 9.10 64 bit All-in-One LAMP server – Linux Apache MySQL PHP Subversion Trac and Samba – Part 4”