服务器环境:
主机:10.0.0.1、mysql端口3306
从机:10.0.0.2、mysql端口3306
登录主机mysql,并授权主从同步用户repl,如果想配成双主,可以在从机上也授权一个repl用户。
授权命令:
mysql> grant replication slave on \*.* to 'repl'@'%' identified by 'repl';
Query OK, 0 rows affected (0.00 sec)
记录主机的master信息:
mysql> show master status;
+------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000006 | 120 | | mysql | |
+------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)
登录从机mysql,建立主从复制:
mysql> change master to master_host='10.0.0.1',master_user='repl',
master_password='repl',master_log_file='mysql-bin.000006',
master_log_pos=120,master_port=3306;
mysql> start slave;
这样主从就搭建好了,如果要搭建双主,登录10.0.0.2的mysql,记录master信息,再登录10.0.0.1的mysql上执行change master,启动,就OK了。
如果嫌变量多,记不住,可以执行下面命令输出帮助:
mysql> ? change master to