mysql 主从复制 建立新的slave

创建slave

1，备份master数据库：

master>mysqldump -uroot -p test > /root/master.sql

2，复制到slave服务器：

<pre name="code" class="sql">master><span style="font-family: Arial, Helvetica, sans-serif;">scp master.sql root@192.168.85.100:/root</span>

3，将数据导入到slave上：

slave>mysql -uroot -p test < /root/master.sql

4，查看master当前活动日志和pos位置：

master>show master status;

+------------------+----------+--------------+------------------+

| File             | Position | Binlog_Do_DB |Binlog_Ignore_DB |

+------------------+----------+--------------+------------------+

| master-bin.000008|      888 |              |                  |

+------------------+----------+--------------+------------------+

5，slave上停止slave

slave>stop slave;

6，slave连接到master服务器连接

<pre name="code" class="sql">slave>change master to master_host='192.168.85.100',master_port=3306,master_user='u_repl',master_password='mypassword',master_log_file='master-bin.000008',master_log_pos=888;

7，开启复制

slave>start slave;