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 on *.* to repl@localhost
on the master, to find the log file / postion variables:
flush tables with read lock; show master status;
on the slave, to start replication:
change master to master_host = '127.0.0.1', master_port = 3307, master_user='repl', master_log_file = 'mysql-bin.000008', master_log_pos = 13804; start slave
on the master, to enable writes:
unlock tables;
