Difference between revisions of "Development:TestReplicationSetup"
| Line 8: | Line 8: | ||
chroot setup is as follows: | chroot setup is as follows: | ||
proc entries are in till's master /etc/fstab to mount the /proc filesystem in the chroots | proc entries are in till's master /etc/fstab to mount the /proc filesystem in the chroots | ||
| − | + | <pre> | |
| + | proc /www/mysql-replication/master/proc proc defaults 0 0 | ||
| + | proc /www/mysql-replication/slave/proc proc defaults 0 0 | ||
| + | </pre> | ||
1) Install the OS files | 1) Install the OS files | ||
<pre> | <pre> | ||
Revision as of 08:48, 19 July 2007
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
change master to master_host = 'localhost', master_port = 3307, master_user='replication', master_log_file = 'mysql-bin.000020', master_log_pos = 13804
