Previous Next

MySQL Replication

Setup 5 of 6

Configure the slaves:
[mysqld]
server-id=XXX
read-only
Start the slaves, and then tell them about the master:
mysql> CHANGE MASTER TO
       MASTER_HOST='master.washington.edu',
       MASTER_USER='repl',
       MASTER_PASSWORD='??',
       MASTER_LOG_FILE='XXXXX',
       MASTER_LOG_POS=XXXXX;

mysql> START SLAVE;