Mysql-GTID主从部署

>MySQL 5.6引入的GTID(Global Transaction ID)使得其复制功能的配置、监控及管理[docs](https://www.cnblogs.com/sky-cheng/p/10955054.html)

### 1. 基础包安装
```bash
yum install epel-release unzip gcc gcc-c++ -y && \
yum install python-pip python-devel mysql-devel

pip install psutil
pip install wget 
pip install netifaces
pip install plumbum -i https://pypi.douban.com/simple/ 
pip install MySQL-python 
pip install simplejson 


```

### 2. 部署MYSQL脚本
```bash
./mysql57_install_rhel7.py install --innodb_buffer_pool_size 2 -p 3006
  
# 登录MSYQL
mysql -u root -pwsiuZdB13EGrX8 -P 3006 -h 127.0.0.1 

```

### 3. 配置GTID主从同步
```bash

@主库添加复制专用账号(  主库演示）
grant replication slave on *.* to 'repl'@'%' identified by 'Xxoo5leaves';

mysql> show master status\G;
Executed_Gtid_Set: 79268674-de0e-11e9-821c-0017fa02ae07:1-7


@从库加入（从库演示）
python mysql57_install_rhel7.py start-slave --gtid_purged "79268674-de0e-11e9-821c-0017fa02ae07:1-7" --master_host "10.2.20.22" --master_port 3006 --master_user repl -p 3006 --reset-master  --reset-slave --stop-slave 


验证主从
@主库（演示）
mysql> show processlist;

+----+------+------------------+------+------------------+---------+---------------------------------------------------------------+------------------+
| Id | User | Host             | db   | Command          | Time    | State                                                         | Info             |
+----+------+------------------+------+------------------+---------+---------------------------