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:
- MySQL 数据库双主配置
- SSDB源码分析 – 主从和多主同步原理解析
- Linux下编译安装Apache/Nginx/Lighttpd+PHP+MySQL
- MySQL 基本配置
- MySQL 建立外键约束
由 udpwork.com 聚合
|
评论: 0
|
要! 要! 即刻! Now!