Difference between revisions of "Development:TestReplicationSetup"
Jason Parmer (talk | contribs) (New page: 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...) |
|||
| Line 25: | Line 25: | ||
Master is setup on port 3307, slave on port 3308 | Master is setup on port 3307, slave on port 3308 | ||
| + | |||
| + | <pre> | ||
| + | change master to master_host = 'localhost', master_port = 3307, master_user='replication', master_log_file = 'mysql-bin.000020', master_log_pos = 13804 | ||
| + | </pre> | ||
Revision as of 08:47, 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
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
