Mysql 复制步骤

最新推荐文章于 2024-12-12 09:43:13 发布

hikelee

最新推荐文章于 2024-12-12 09:43:13 发布

阅读量299

点赞数

分类专栏： Mysql

本文链接：https://blog.youkuaiyun.com/hikelee/article/details/17409893

版权

Mysql 专栏收录该内容

3 篇文章

订阅专栏

Master side:192.169.0.205
     1.edit /etc/mysql/my.cnf
          [mysqld]
          log-bin=mysql-bin
          server-id=1
     2.sudo service mysql restart
     3.creating a user for replication
               1)mysql>CREATE USER 'repl'@'%' IDENTIFIED BY 'slavepass';
               2)mysql>GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%';
     4.mysqldump -uroot -p123456 testdb >test.sql
     5.show master status\G;
            File: mysql-bin.000003
Position: 4049
--------------------------------------------------------------
Slave side:192.169.0.206
     1.edit /etc/mysql/my.cnf
          [mysqld]
          server-id=2
     2.scp -P 22 hike@192.169.0.205:/home/hike/test.sql /home/hike/test.sql
     3.mysqldump –uroot –p123456 testdb <test.sql
     4.mysql>change master to master_host='192.168.0.205', master_user='repl', master_password='slavepass', master_log_file=' mysql-bin.000003 ', master_log_pos= 4049 ;
     5.mysql>start slave;
     6.mysql>show slave status\G;