The "Howto Forge" site has published yesterday a good article entitled "How To Set Up Database Replication In MySQL". It is a step by step tutorial about MySQL replication feature. The article discribes all required steps on systems running "Debian Sarge", however the configuration should apply to almost all distributions with little or no modification.

This is a "copy & paste" HowTo! The easiest way to follow this tutorial is to use a command line client/SSH client (like PuTTY for Windows) and simply copy and paste the commands (except where you have to provide own information like IP addresses, hostnames, passwords,...). This helps to avoid typos.


URL: http://www.howtoforge.com/mysql_database_replication