CentOS release 6.8 (Final)
Server version: 5.5.56
binlog_format : STATEMENT
tx_isolation  : REPEATABLE-READ
主1 server_id : 32
主2 server_id : 33

*************************** 1. row ***************************
       Table: mobile_ad_50
Create Table: CREATE TABLE `mobile_ad_50` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `dtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '时间段 年月日时',
  `union_id` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '媒体ID',
  `ad_id` varchar(100) DEFAULT NULL COMMENT '广告位ID',
  `ifa` varchar(50) NOT NULL COMMENT 'ifa',
  `mac` varchar(50) NOT NULL COMMENT 'mac',
  `cb_url` varchar(1000) NOT NULL COMMENT '回调地址',
  `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否激活',
  `domain` varchar(30) NOT NULL COMMENT '游戏域名',
  `game_code` varchar(50) NOT NULL DEFAULT '' COMMENT '游戏编码',
  `union_app_id` char(50) NOT NULL DEFAULT '' COMMENT '渠道商的appid',
  `openudid` char(50) NOT NULL DEFAULT '' COMMENT '开源广告标示符',
  `is_send` tinyint(1) NOT NULL DEFAULT '0' COMMENT '同步次数a',
  `ip` bigint(20) NOT NULL DEFAULT '0' COMMENT '点击ip',
  `actip` bigint(20) NOT NULL DEFAULT '0' COMMENT '激活ip',
  `opentime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '打开时间',
  `acttime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '激活时间',
  `is_open` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否打开',
  PRIMARY KEY (`id`),
  KEY `ifa` (`ifa`),
  KEY `d_u_s` (`domain`,`union_id`,`state`),
  KEY `union_id` (`union_id`),
  KEY `mac` (`mac`),
  KEY `dtime` (`dtime`),
  KEY `ip` (`ip`),
  KEY `actip` (`actip`),
  KEY `union_app_id` (`union_app_id`),
  KEY `openudid` (`openudid`),
  KEY `state` (`state`),
  KEY `acttime` (`acttime`)
) ENGINE=InnoDB AUTO_INCREMENT=6154739813 DEFAULT CHARSET=utf8 COMMENT='手机广告'
1 row in set (0.00 sec)

"""
Usage:
        binlog_server.py --user=<username> --password=<password> --host=<remote_host> --port=<remote_port> --backup-dir=<backup_dir> --log=<log> [--last-file=<last-file>]
        binlog_server.py -h | --help
        binlog_server.py --version
        binlog_server.py --config=<config_file> --dbname=<database_name> [--last-file=<last-file>]

Options:
        -h --help                      Show help information.
        --version                      Show version.
        --user=<username>              The user name used to connect to the remote server.
        --password=<password>          The password used to connect to the remote server.
        --host=<remote_host>            The remote host IP address.
        --port=<remote_port>            The remote MySQL server port.
        --backup-dir=<backup_dir>      The dest to store binlog.
        --log=<log>                    The log.
        --last-file=<last-file>        Specify the starting binlog.
        --config=<config_file>          Config file.
        --dbname=<database_name>        Section name in config file.
"""
from docopt import docopt
import subprocess
import logging
import time
import ConfigParser
import os

arguments = docopt(__doc__, version='Binlog server 1.0')
if arguments['--config']:
    cf=ConfigParser.ConfigParser()
    cf.read(arguments['--config'])
    section_name = arguments['--dbname']
    db_host = cf.get(section_name, "db_host")
    db_port = cf.get(section_name, "db_port")
    db_user = cf.get(section_name, "db_user")
    db_passwd = cf.get(section_name, "db_passwd")
    backup_dir = cf.get(section_name, "backup_dir")
    log = cf.get(section_name, "log")
    logging.basicConfig(level=logging.DEBUG,
                format='%(asctime)s %(filename)s[line:%(lineno)d] %(levelname)s %(message)s',
                datefmt='%a, %d %b %Y %H:%M:%S',
                filename=log,
                filemode='a')

logging.basicConfig(level=logging.DEBUG,
                format='%(asctime)s %(filename)s[line:%(lineno)d] %(levelname)s %(message)s',
                datefmt='%a, %d %b %Y %H:%M:%S',
                filename=arguments['--log'],
                filemode='a')

def dumpBinlog(user,password,host,port,backup_dir,log,last_file=''):
        LOCAL_BACKUP_DIR=backup_dir
        if backup_dir[-1]!= '/':
            os.exit()
        #BACKUP_LOG='/data4/binlog_backup/120.27.136.247/BB.log'
        BACKUP_LOG=log[log.rfind('/')+1:]
        while True:
            if not last_file:
                    cmd="ls -A {LOCAL_BACKUP_DIR} | grep -v {BACKUP_LOG} | grep -v nohup.out |wc -l".format(LOCAL_BACKUP_DIR=LOCAL_BACKUP_DIR,BACKUP_LOG=BACKUP_LOG)
                    child=subprocess.Popen(cmd,shell=True,stdout=subprocess.PIPE)
                    child.wait()
                    wc_l=int(child.communicate()[0].strip())
                    if wc_l != 0:
                            cmd="ls -l %s | grep -v %s | grep -v nohup.out |tail -n 1 |awk '{print $9}'" % (LOCAL_BACKUP_DIR,BACKUP_LOG)
                            child=subprocess.Popen(cmd,shell=True,stdout=subprocess.PIPE)
                            child.wait()
                            LAST_FILE=child.communicate()[0].strip()
            else:
                    LAST_FILE=last_file
            logging.info('Last File is %s' % (LAST_FILE))


            mysqlbinlog='mysqlbinlog --raw --read-from-remote-server --stop-never --host={REMOTE_HOST} --port={REMOTE_PORT} --user={REMOTE_USER} --password={REMOTE_PASS} --result-file={RESULT_FILE} {LAST_FILE}'.format(REMOTE_HOST=host,REMOTE_PORT=port,REMOTE_USER=user,REMOTE_PASS=password,RESULT_FILE=LOCAL_BACKUP_DIR,LAST_FILE=LAST_FILE)


            subprocess.call(mysqlbinlog,shell=True)
            logging.info('Binlog server stop!!!,reconnect after 10 seconds')
            time.sleep(10)

if __name__ == '__main__':
    if arguments['--config']:
        lock_file=db_host+"_binlog_server.lock"
    else:
        lock_file=arguments['--host']+"_binlog_server.lock"

    child=subprocess.Popen('ls /tmp|grep %s' % (lock_file),shell=True,stdout=subprocess.PIPE)
    child.wait()
    lock=child.communicate()[0].strip()
    if not lock:
        subprocess.call('touch /tmp/%s' % (lock_file),shell=True)
        logging.info('Get lock,Binlog server start!!!')
        if not arguments['--config']:
          dumpBinlog(arguments['--user'],arguments['--password'],arguments['--host'],arguments['--port'],arguments['--backup-dir'],arguments['--log'],arguments['--last-file'])
        else:
          dumpBinlog(db_user,db_passwd,db_host,db_port,backup_dir,log,arguments['--last-file'])

    else:
        logging.info('Binlog server already running!!!')
        print('Binlog server already running!!!,please check or reomove the lock file')

python binlog_server.py --user=binlog_backup --password=xxxx --host=xxxx --port=3306 --backup-dir=/data4/binlog_backup/ --log=/data4/binlog_backup/BB.log

[root@node4 log]# docker ps -a
CONTAINER ID        IMAGE                      COMMAND                CREATED            STATUS              PORTS                        NAMES
e4916410b314        percona/pmm-server:latest  "/opt/entrypoint.sh"  2 hours ago        Up 31 minutes      0.0.0.0:80->80/tcp, 443/tcp  pmm-server
948a9aeb047e        percona/pmm-server:latest  "/bin/true"            2 hours ago        Created                                          pmm-data
[root@node4 log]# docker logs e4916410b314
2017-09-27 08:39:47,175 CRIT Supervisor running as root (no user in config file)
2017-09-27 08:39:47,175 WARN Included extra file "/etc/supervisord.d/pmm.ini" during parsing
Unlinking stale socket /var/run/supervisor/supervisor.sock
2017-09-27 08:39:47,527 INFO RPC interface 'supervisor' initialized
2017-09-27 08:39:47,528 INFO supervisord started with pid 1
2017-09-27 08:39:48,536 INFO spawned: 'mysql' with pid 15
2017-09-27 08:39:48,543 INFO spawned: 'consul' with pid 16
2017-09-27 08:39:48,552 INFO spawned: 'grafana' with pid 17
2017-09-27 08:39:48,563 INFO spawned: 'nginx' with pid 18
2017-09-27 08:39:48,610 INFO spawned: 'cron' with pid 19
2017-09-27 08:39:48,612 INFO spawned: 'qan-api' with pid 20

[root@node4 ~]# pmm-admin check-network
PMM Network Status

Server Address | 172.16.83.103
Client Address | 172.16.83.103 

* System Time
NTP Server (0.pool.ntp.org)        | 2017-09-27 17:13:58 +0800 CST
PMM Server                          | 2017-09-27 09:13:58 +0000 GMT
PMM Client                          | 2017-09-27 17:13:58 +0800 CST
PMM Server Time Drift              | OK
PMM Client Time Drift              | OK
PMM Client to PMM Server Time Drift | OK

* Connection: Client --> Server
-------------------- -------      
SERVER SERVICE      STATUS      
-------------------- -------      
Consul API          OK
Prometheus API      OK
Query Analytics API  OK

Connection duration | 551.133µs
Request duration    | 2.467879ms
Full round trip    | 3.019012ms


* Connection: Client <-- Server
-------------- ------ -------------------- ------- ---------- ---------
SERVICE TYPE  NAME  REMOTE ENDPOINT      STATUS  HTTPS/TLS  PASSWORD 
-------------- ------ -------------------- ------- ---------- ---------
linux:metrics  node4  172.16.83.103:42000  OK      YES        -        
mysql:metrics  node4  172.16.83.103:42002  OK      YES        -        

登录数据库
sqlite3 /var/lib/grafana/grafana.db 
修改user表,把admin密码改成admin
update user set password = '59acf18b94d7eb0694c61e60ce44c110c7a683ac6a8f09580d626f90f4a242000746579358d77dd9e570e83fa24faa88a8a6', salt = 'F3FAxVm33R' where login = 'admin'
安全起见,也可以把admin密码改成TdPXP4sg
update user set password='11cf3a1ee21b046b939b5f0cdc9d92ab70ba66e4e53f301fb2456ee7b6a665d8abf0d5b387ae0ec53f5f5fc8e477bfbe073e',salt='AHxOW2Fn34',name='admin',is_admin=1 where login='admin';

创建monitor用户密码mj8toYLB
INSERT INTO "user" VALUES(3,0,'monitor','monitor@papapa.com','monitor','98c8e341360759e957ac43e2543fab4eef420a3521450d03ad79d5a1dd76dee233a9ec11870264c2e4dd7266d1a1f68681c2','erShkEJCWn','Y9TF6hFe
bE','',1,0,
0,'','2017-09-28 10:21:10','2017-09-28 10:21:10',0);

sysbench /usr/share/sysbench/oltp_read_write.lua  --mysql-user=root --mysql-password=mysql --mysql-port=3306 \
--mysql-socket=/data/mysqldata/3306/mysql.sock  --mysql-host=localhost \
--mysql-db=sysbenchtest  --tables=10 --table-size=5000000  --threads=30 \
--events=5000000 --report-interval=5  --db-driver=mysql prepare

sysbench \
/usr/share/sysbench/oltp_read_write.lua \
--mysql-user=root  --mysql-password=mysql --mysql-port=3306 \
--mysql-socket=/data/mysqldata/3306/mysql.sock  --mysql-host=localhost \
--mysql-db=sysbenchtest  --tables=10 --table-size=5000000 \
--threads=30 --report-interval=5 --time=7000 --db-driver=mysql run > binlog_off.txt

[root@test43100 ~]# mysqldump --user=root --password='mysql' fandb user --where="host='localhost' and user='root'" |grep INSERT
mysqldump: [Warning] Using a password on the command line interface can be insecure.
Warning: A partial dump from a server that has GTIDs will by default include the GTIDs of all transactions, even those that changed suppressed parts of the database. If you don't want to restore GTIDs, pass --set-gtid-purged=OFF. To make a complete dump, pass --all-databases --triggers --routines --events. 
INSERT INTO `user` VALUES ('localhost','root','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'mysql_native_password','*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B','N','2017-08-04 08:12:53',NULL,'N');

change master to
master_host='10.4.3.100',
master_user='repl',
master_password='repl',
master_port=3306,
master_auto_position=1;

重点
start slave sql_thread until SQL_BEFORE_GTIDS='5c351518-78ec-11e7-8e7a-005056a610c3:1315';
start slave io_thread;