博客

MySQL 在线增加从库

  • Post author:
  • Post category:IT
  • Post comments:0评论

Master

创建用户:

GRANT REPLICATION SLAVE ON *.* TO 'userx'@'server_b' IDENTIFIED BY 'xxxxx';

导出数据:

mysqldump --all-databases --master-data > dbdump.sql

导致的 dbdump.sql 里会包含 binlog 的位置.

Slave

CHANGE MASTER TO MASTER_HOST='server_a';
CHANGE MASTER TO MASTER_USER='userx';
CHANGE MASTER TO MASTER_PASSWORD='xxxxx';
CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=106;
start slave;
show slave status\G

Related posts:

  1. MySQL 数据库双主配置
  2. SSDB源码分析 – 主从和多主同步原理解析
  3. Linux下编译安装Apache/Nginx/Lighttpd+PHP+MySQL
  4. MySQL 基本配置
  5. MySQL 建立外键约束

发表回复