问:把大象关进冰箱分几步?
答:打开冰箱,关进大象,关上冰箱
三步走战略、哈哈、安全的配置复制也是一样的走三步
㈠ 创建复制账号
答:打开冰箱,关进大象,关上冰箱
三步走战略、哈哈、安全的配置复制也是一样的走三步
㈠ 创建复制账号
主备:
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;