MySQL Replication
Jump to navigation
Jump to search
Open two windows to the Master Server and one window to the Slave Server
On the MASTER Server MAIN WINDOW
- # service mysqld stop
- # vi /data/chroot/etc/my.cnf
log-bin = mysql-bin server-id = 1
- # service mysqld start
On the SLAVE Server
- # service mysqld stop
- # vi /data/chroot/etc/my.cnf
server-id = 2
- service mysqld start
On the MASTER Server MAIN WINDOW
- # mysql -p -uroot
- mysql> GRANT REPLICATION SLAVE ON *.* TO 'mysql-ha'@'<IP Address of Slave>' IDENTIFIED BY '<Password>';
- mysql> FLUSH PRIVILEGES;
- mysql> FLUSH TABLES WITH READ LOCK;
On the MASTER Server SECOND WINDOW
- Take a dump of the MySQL environment (optional).
- # mysqldump -p -u root --all-databases > alldb.sql
- SCP this information over to the slave server.
- # mysql -p -uroot
- mysql> SHOW MASTER STATUS;
- mysql> UNLOCK TABLES;
On the SLAVE Server
- # mysql -p -uroot
- mysql> CHANGE MASTER TO MASTER_HOST='<IP Address of Master>', MASTER_USER='mysql-ha', MASTER_PASSWORD='<Password>', MASTER_LOG_FILE='mysql-bin.<######>', MASTER_LOG_POS=<###>;
- mysql> START SLAVE;
On the MASTER Server MAIN WINDOW
- mysql> UNLOCK TABLES;