Differences

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

--- mysqlreplication [2019/02/19 11:31] – created z0hpvk
+++ mysqlreplication [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 2: / Line 2: @@
 <code>
-create user 'repl'@'ubuntu-slave' identified by 'ipswich';
+.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 'teapot';
 grant replication slave on *.* to 'repl'@'ubuntu-slave';
 </code>
+==== Lock Tables on Master ====
 <code>
 flush tables with read lock;
 </code>
+==== Display Details of Binary Log ====
 <code>
 show master status;
@@ Line 19: / Line 35: @@
 </code>
+==== Backup / Restore ====
 <code>
 mysqldump -uroot -p --all-databases --master-data --add-drop-database > ubuntu-master.dmp
@@ Line 25: / Line 42: @@
 </code>
+==== Configure Replication on Slave ====
 <code>
 mysql> CHANGE MASTER TO
        ->     MASTER_HOST='ubuntu-master',
        ->     MASTER_USER='repl',
-       ->     MASTER_PASSWORD='ipswich',
+       ->     MASTER_PASSWORD='teapot',
        ->     MASTER_LOG_FILE='binlog.000011',
        ->     MASTER_LOG_POS=904;
@@ Line 36: / Line 54: @@
 </code>
+==== Monitoring and Administration ====
 <code>
 mysql> show slave status\G