User Tools

no way to compare when less than two revisions

Differences

This shows you the differences between two versions of the page.


—mysql-replica [2024/06/30 16:45] (current) – created norman
Line 1: Line 1:
 +====== Mysql Replicator helpers ======
  
 +
 +====== Master Side ======
 +
 +Get current status and position:
 +<code>SHOW MASTER STATUS\G</code>
 +or
 +<code>show master status;</code>
 +{{::screenshot_2024-06-30_17-40-02.jpg?400|}}
 +
 +====== Slave Side ======
 +
 +First time (I think) should be:
 +<code>CHANGE MASTER TO MASTER_HOST='10.20.10.1', MASTER_USER='user', MASTER_PASSWORD='password', MASTER_LOG_FILE='master1-bin.000004', MASTER_LOG_POS=8044078;</code>
 +
 +
 +Change file and position:
 +<code>CHANGE MASTER TO MASTER_LOG_FILE='master1-bin.000004', MASTER_LOG_POS=8044078;</code>