1、主从库配置my.conf
whereis my.cnf
cd ...
vim my.cnf
log-bin=mysql_log_bin
server-id=1
server-id=2
service mysqld restart
2、主库创建账号并授权
mysql -uroot -p
create user 'replication'@'%' identified by 'da@123456';
grant replication slave on *.* to 'replication'@'%';
flush privileges;
3、主库进行锁表(用作备份)
flush tables with read lock;
4、主库找到log-bin的位置
show master status;
5、主库备份数据
mysqldump --all-databases --master-data > dbdump.db -uroot -p;
6、从库复制dbdump并加载
scp root@192.168.8.131:~/dbdump.db .
mysql < dbdump.db -uroot -p
7、主库进行释放表(接步骤3)
unlock tables;
8、在从库上设置主的配置
CHANGE MASTER TO
MASTER_HOST='master_host_name',
MASTERR_USER='replication_user_name',
MASTER_PASSWORD='replication_passwrod',
MASTER_LOG_FILE='recorder_log_file_name',
MASTER_LOG_POS=recorded_log_position;
change master to
master_host='192.168.8.131',
master_user='replication',
master_password='da@123456',
master_log_file='mysql_log_bin.000001',
master_log_pos=1460;
start slave;
show slave status;