问：把大象关进冰箱分几步？
答：打开冰箱，关进大象，关上冰箱
三步走战略、哈哈、安全的配置复制也是一样的走三步

㈠创建复制账号

主备：

gant replication slave,replication client on *.* to \'cdio\'@\'192.168.47.%\' identified by \'2010cdio\'

㈡配置主备

主库：

   log-bin=/home/mysql/mysql/binlog/mysql-bin
   server_id=10
   sync_binlog=1
   innodb_flush_logs_at_trx_commit=2
   innodb_support_xa=1

备库：

   log_bin=/home/mysql/mysql/binlog/mysql-bin
   server_id=2
   relay_log=/home/mysql/mysql/relaylog/mysql-relay-bin
   log_slave_updates=1
   read_only=1
   skip_slave_start
   sync_master_info=1
   sync_relay_log=1
   sync_relay_log_info=1

㈢启动复制

   备库：
   
   change master to master_host=\'node3.cdio.com\',
   master_user=\'cdio\',
   master_password=\'2010cdio\',
   master_log_file=\'mysql-bin.000001\',
   master_log_pos=0;
   
   
   start slave;
  
   
   show slave status\G;
   
   
   主备：
   
   show processlist\G;

ITPub博客

生产环境 MySQL Replication 的推荐配置

最新文章