====== 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>