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.


Comments

Popular posts from this blog

Check MySQL query history from command line

Installing chocolatey on Windows