1:准备两台ubuntu14.04 server
主节点(master):192.168.1.2 从节点(slave):192.168.1.3
2:两台server同时执行sudo apt-get update
3:安装mysql-server-5.6
sudo apt-get install mysql-server-5.6 并且填写mysql root用户密码
4:配置主节点(master) 192.168.1.2的my.cnf文件
sudo cp /etc/mysql/my.cnf /etc/mysql/my.cnf.bak
sudo vim /etc/mysql/my.cnf
bind-address= 0.0.0.0
server-id = 1 (删除前面#,去掉注释)
log_bin = /var/log/mysql/mysql-bin.log
binlog_do_db = $databasename (需要同步的数据库名称,可以添加多条)
binlog_ignore_db = $databasename (需要忽略同步的数据库名称)
5: 主节点mysql重新启动
6:master节点:mysql -u root -p
grant all privileges on *.* to tongbu@"%" identified by "$PASSWD"; (创建数据库同步用户及密码)
show master status;
+------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000002 | 317 | love | mysql | |
+------------------+----------+--------------+------------------+-------------------+
记住file对应mysql-bin.000002 及Position对应 317 后续配置从库时会用到
7: sudo service mysql restart
8: 配置从节点(slave) 192.168.1.3的my.cnf配置文件
sudo cp /etc/mysql/my.cnf /etc/mysql/my.cnf.bak
sudo vim /etc/mysql/my.cnf
bind-address = 127.0.0.1
server-id = 2 (删除前面#,去掉注释)
log_bin = /var/log/mysql/mysql-bin.log
binlog_do_db = $databasename (需要同步的数据库名称,可以添加多条)
9:重启从节点Mysql
10:slave节点:mysql -u root -p
stop slave;
change master to master_host='192.168.1.2',master_user='tongbu',master_password='$PASSWD',master_log_file='mysql-bin.000002' ,master_log_pos=317;
start slave;
show slave status;
11:master节点mysql -u root -p
create database love;
use love;
CREATE TABLE test ( id int not null primary key,name char(20) );
12:查看从库是否同步成功
主节点(master):192.168.1.2 从节点(slave):192.168.1.3
2:两台server同时执行sudo apt-get update
3:安装mysql-server-5.6
sudo apt-get install mysql-server-5.6 并且填写mysql root用户密码
4:配置主节点(master) 192.168.1.2的my.cnf文件
sudo cp /etc/mysql/my.cnf /etc/mysql/my.cnf.bak
sudo vim /etc/mysql/my.cnf
bind-address= 0.0.0.0
server-id = 1 (删除前面#,去掉注释)
log_bin = /var/log/mysql/mysql-bin.log
binlog_do_db = $databasename (需要同步的数据库名称,可以添加多条)
binlog_ignore_db = $databasename (需要忽略同步的数据库名称)
5: 主节点mysql重新启动
6:master节点:mysql -u root -p
grant all privileges on *.* to tongbu@"%" identified by "$PASSWD"; (创建数据库同步用户及密码)
show master status;
+------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000002 | 317 | love | mysql | |
+------------------+----------+--------------+------------------+-------------------+
记住file对应mysql-bin.000002 及Position对应 317 后续配置从库时会用到
7: sudo service mysql restart
8: 配置从节点(slave) 192.168.1.3的my.cnf配置文件
sudo cp /etc/mysql/my.cnf /etc/mysql/my.cnf.bak
sudo vim /etc/mysql/my.cnf
bind-address = 127.0.0.1
server-id = 2 (删除前面#,去掉注释)
log_bin = /var/log/mysql/mysql-bin.log
binlog_do_db = $databasename (需要同步的数据库名称,可以添加多条)
9:重启从节点Mysql
10:slave节点:mysql -u root -p
stop slave;
change master to master_host='192.168.1.2',master_user='tongbu',master_password='$PASSWD',master_log_file='mysql-bin.000002' ,master_log_pos=317;
start slave;
show slave status;
11:master节点mysql -u root -p
create database love;
use love;
CREATE TABLE test ( id int not null primary key,name char(20) );
12:查看从库是否同步成功