MySQL加入复制replication服务器

MySQL加入复制replication服务器

master:

1.stop httpd

2.mysql>show master status;

记下文件名和position,

3.stop master

4.scp /mysql/bbs/*.* root@slaveIP:/mysql/bbs

slave:

1.vi /etc/my.cnf

加入

server-id=xxx //id 不要和master及其它slave服务器ID重复

master-host=x.x.x.x

master-user=replication_user

master-password=xxxxxxxx

master-port=3306

replicate-do-db=bbs

2.mysql>change master to master_host='x.x.x.x';

mysql> change master to master_log_file='bbs.000009',master_log_pos=24178378;

(仅示例，文件和位置就按master上的改)

mysql>slave start;

mysql>show slave status;