Digital Marketing

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

Fixed WSL sshd: no hostkeys available -- exiting

PowerMTA pmta command

How to fix: mv: failed to preserve ownership