Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- New data at MASTER gets saved to SLAVE as backup data
- MASTER > 192.168.1.5
- SLAVE > 192.168.1.8
- ### TEST CONNECTION on BOTH SIDES with $nc IP 3306
- # MASTER config
- $vi /etc/mysql/my.cnf
- * add
- bind-address = LOCAL_IP_ADDRESS
- server-id=1
- log_bin=/var/log/mysql-master-bin
- log_error=/var/log/mysql-master-bin.err
- binlog_do_db=tours
- *run
- $service mysql restart
- GRANT REPLICATION SLAVE ON *.* TO 'slave_user'@'%' IDENTIFIED BY 'bob';
- FLUSH PRIVILEGES;
- USE replicationDB;
- FLUSH TABLES WITH READ LOCK;
- SHOW MASTER STATUS; #### GET File & Position values
- $mysqldump -u root -p --opt replicationDB > replicationDB.sql ### EXPORT
- UNLOCK TABLES;
- QUIT;
- # SLAVE config
- CREATE DATABASE replicationDB;
- EXIT;
- $mysql -u root -p replicationDB < replicationDB.sql ### IMPORT
- $vi /etc/mysql/my.cnf
- * add
- server-id = 2
- relay-log = /var/log/mysql/mysql-relay-bin.log
- log_bin = /var/log/mysql/mysql-bin.log
- binlog_do_db = replicationDB
- $service mysql restart
- CHANGE MASTER TO MASTER_HOST='MASTER_IP_ADDRESS',
- MASTER_USER='slave_user',
- MASTER_PASSWORD='bob',
- MASTER_LOG_FILE='mysql-bin.000001', ### GOT FROM File value
- MASTER_LOG_POS= 107; ### GOT FROM Position value
- START SLAVE;
- SHOW SLAVE STATUS;
- ### IF ERROR: SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; SLAVE START;
- *** DONE ***
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement