mysql -server-5.6 install master and slave on ubuntu 14.04server

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:查看从库是否同步成功