Development:TestReplicationSetup
On till:
master + slave sub servers, setup as chroot jails.
the chroots live in /www/mysql-replication, under master and slaver servers respectively.
chroot setup is as follows: proc entries are in till's master /etc/fstab to mount the /proc filesystem in the chroots
proc /www/mysql-replication/master/proc proc defaults 0 0 proc /www/mysql-replication/slave/proc proc defaults 0 0
1) Install the OS files
sudo debootstrap --arch amd64 etch /www/mysql-replication/slave http://mirror.xmission.com/debian
2) enter the chrooted system
sudo chroot /www/mysql-replication/master
3) install locales support and MySQL
apt-get install locales-all apt-get install mysql-server-5.0
Master is setup on port 3307, slave on port 3308 on the master, add permission for the replication user:
grant replication slave, super, reload on *.* to 'replication'@'localhost'
on the slave, to start replication:
change master to master_host = '127.0.0.1', master_port = 3307, master_user='replication', master_log_file = 'mysql-bin.000066', master_log_pos = 14218; start slave