Differences

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

--- mysqlreplication [2019/02/19 11:37] – z0hpvk
+++ mysqlreplication [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ===== MySQL Replication =====
+<code>
+.168.56.102  ubuntu-master
+.168.56.103  ubuntu-slave
+</code>
+==== Set Server ID on Slave ====
+<code>
+set persist server_id = 2;
+service mysql restart
+systemctl restart mysql
+</code>
 ==== Create Replication User on Master ====
 <code>
-create user 'repl'@'ubuntu-slave' identified by 'ipswich';
+create user 'repl'@'ubuntu-slave' identified by 'teapot';
 grant replication slave on *.* to 'repl'@'ubuntu-slave';
 </code>
@@ Line 34: / Line 47: @@
        ->     MASTER_HOST='ubuntu-master',
        ->     MASTER_USER='repl',
-       ->     MASTER_PASSWORD='welcome123',
+       ->     MASTER_PASSWORD='teapot',
        ->     MASTER_LOG_FILE='binlog.000011',
        ->     MASTER_LOG_POS=904;