Mar 9, 2018

MySQL replication related commands

refer to

change master to MASTER_HOST='192.168.1.5', MASTER_USER='i88ca', MASTER_PASSWORD='password', MASTER_LOG_FILE='mysql-bin.000106', MASTER_LOG_POS=1050857999;

CREATE USER 'repl'@'%' IDENTIFIED BY 'password';

GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%';


mysql> show master status;
+------------------+----------+--------------+------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000003 |      918 | |            |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)


for compatibility, such as different version, try mysqldump

only replicate to higher version sql server. (slave should have higher version)

for replication compatibility, upgrade slave to higher version than master.