2018-05-14T04:37:05.239152Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-05-14T04:37:05.611652Z 0 [Warning] You need to use --log-bin to make --log-slave-updates work.
2018-05-14T04:37:05.611665Z 0 [Warning] You need to use --log-bin to make --binlog-format work.
 100
 100
2018-05-14T04:37:30.875408Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-05-14T04:37:32.454914Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-05-14T04:37:32.687685Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 84717b93-5730-11e8-a3ee-000d3a068fe4.
2018-05-14T04:37:32.702835Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-05-14T04:37:32.737386Z 1 [Note] A temporary password is generated for root@localhost: h+7%Gpm&)!td
2018-05-14T04:37:50.248776Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-05-14T04:37:50.250826Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-log) starting as process 11625 ...
2018-05-14T04:37:50.253922Z 0 [Warning] You need to use --log-bin to make --log-slave-updates work.
2018-05-14T04:37:50.253954Z 0 [Warning] You need to use --log-bin to make --binlog-format work.
2018-05-14T04:37:50.287717Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-05-14T04:37:50.287750Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-05-14T04:37:50.287759Z 0 [Note] InnoDB: Uses event mutexes
2018-05-14T04:37:50.287783Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2018-05-14T04:37:50.287790Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-05-14T04:37:50.287795Z 0 [Note] InnoDB: Using Linux native AIO
2018-05-14T04:37:50.288049Z 0 [Note] InnoDB: Number of pools: 1
2018-05-14T04:37:50.288172Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-05-14T04:37:50.313906Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-05-14T04:37:50.325723Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-05-14T04:37:50.328368Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-05-14T04:37:50.509649Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-05-14T04:37:51.340666Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-05-14T04:37:51.340824Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-05-14T04:37:52.390797Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-05-14T04:37:52.391977Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-05-14T04:37:52.391990Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-05-14T04:37:52.392411Z 0 [Note] InnoDB: Waiting for purge to start
2018-05-14T04:37:52.445489Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 2552298
2018-05-14T04:37:52.445755Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-05-14T04:37:52.452856Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql_data/mysql/ib_buffer_pool
2018-05-14T04:37:52.491426Z 0 [Note] Plugin 'validate_password' is disabled.
2018-05-14T04:37:52.565827Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2018-05-14T04:37:52.566090Z 0 [Warning] CA certificate ca.pem is self signed.
2018-05-14T04:37:52.568010Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2018-05-14T04:37:52.568047Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2018-05-14T04:37:52.568080Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2018-05-14T04:37:52.834351Z 0 [ERROR] /usr/sbin/mysqld: slave_preserve_commit_order is not supported unless both log_bin and log_slave_updates are enabled.
2018-05-14T04:37:52.834408Z 0 [Note] Some of the channels are not created/initialized properly. Check for additional messages above. You will not be able to start replication on those channels until the issue is resolved and the server restarted.
2018-05-14T04:37:52.841600Z 0 [Note] Event Scheduler: Loaded 0 events
2018-05-14T04:37:52.841825Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.21-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2018-05-14T04:37:52.929527Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180514  4:37:52
2018-05-14T04:37:53.490057Z 2 [Note] Access denied for user 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO)
2018-05-14T04:38:03.276988Z 3 [Note] Access denied for user 'root'@'localhost' (using password: YES)
2018-05-14T04:40:02.671428Z 5 [Note] Access denied for user 'root'@'localhost' (using password: YES)
2018-05-14T04:40:43.549436Z 0 [Note] Giving 0 client threads a chance to die gracefully
2018-05-14T04:40:43.549479Z 0 [Note] Shutting down slave threads
2018-05-14T04:40:43.549669Z 0 [Note] Forcefully disconnecting 0 remaining clients
2018-05-14T04:40:43.549685Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2018-05-14T04:40:43.592721Z 0 [Note] Binlog end
2018-05-14T04:40:43.593369Z 0 [Note] Shutting down plugin 'rpl_semi_sync_slave'
2018-05-14T04:40:43.593390Z 0 [Note] Shutting down plugin 'rpl_semi_sync_master'
2018-05-14T04:40:43.593401Z 0 [Note] unregister_replicator OK
2018-05-14T04:40:43.593406Z 0 [Note] Shutting down plugin 'ngram'
2018-05-14T04:40:43.593462Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2018-05-14T04:40:43.593469Z 0 [Note] Shutting down plugin 'ARCHIVE'
2018-05-14T04:40:43.593474Z 0 [Note] Shutting down plugin 'partition'
2018-05-14T04:40:43.593480Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2018-05-14T04:40:43.593485Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-05-14T04:40:43.593490Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-05-14T04:40:43.593495Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-05-14T04:40:43.593500Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-05-14T04:40:43.593506Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-05-14T04:40:43.593510Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-05-14T04:40:43.593515Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-05-14T04:40:43.593520Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-05-14T04:40:43.593525Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-05-14T04:40:43.593530Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-05-14T04:40:43.593535Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-05-14T04:40:43.593540Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-05-14T04:40:43.593545Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-05-14T04:40:43.593550Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-05-14T04:40:43.593555Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-05-14T04:40:43.593560Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-05-14T04:40:43.593565Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-05-14T04:40:43.593570Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-05-14T04:40:43.593575Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-05-14T04:40:43.593580Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-05-14T04:40:43.593585Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-05-14T04:40:43.593590Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-05-14T04:40:43.593594Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-05-14T04:40:43.593599Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-05-14T04:40:43.593604Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-05-14T04:40:43.593609Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-05-14T04:40:43.593614Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-05-14T04:40:43.593619Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-05-14T04:40:43.593633Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-05-14T04:40:43.593638Z 0 [Note] Shutting down plugin 'InnoDB'
2018-05-14T04:40:43.594382Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-05-14T04:40:43.594541Z 0 [Note] InnoDB: Starting shutdown...
2018-05-14T04:40:43.694899Z 0 [Note] InnoDB: Dumping buffer pool(s) to /mysql_data/mysql/ib_buffer_pool
2018-05-14T04:40:43.695069Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180514  4:40:43
2018-05-14T04:40:45.492232Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2560262
2018-05-14T04:40:45.492473Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-05-14T04:40:45.492485Z 0 [Note] Shutting down plugin 'MEMORY'
2018-05-14T04:40:45.492493Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-05-14T04:40:45.492522Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-05-14T04:40:45.492532Z 0 [Note] Shutting down plugin 'MyISAM'
2018-05-14T04:40:45.492543Z 0 [Note] Shutting down plugin 'CSV'
2018-05-14T04:40:45.492990Z 0 [Note] Shutting down plugin 'sha256_password'
2018-05-14T04:40:45.493002Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-05-14T04:40:45.493217Z 0 [Note] Shutting down plugin 'binlog'
2018-05-14T04:40:45.506918Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2018-05-14T04:43:55.695579Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-05-14T04:43:55.700728Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-log) starting as process 12386 ...
2018-05-14T04:43:55.724463Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-05-14T04:43:55.724487Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-05-14T04:43:55.724497Z 0 [Note] InnoDB: Uses event mutexes
2018-05-14T04:43:55.724507Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2018-05-14T04:43:55.724513Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-05-14T04:43:55.724520Z 0 [Note] InnoDB: Using Linux native AIO
2018-05-14T04:43:55.724843Z 0 [Note] InnoDB: Number of pools: 1
2018-05-14T04:43:55.724979Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-05-14T04:43:55.757691Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-05-14T04:43:55.769439Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-05-14T04:43:55.774170Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-05-14T04:43:56.051986Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-05-14T04:43:56.994926Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-05-14T04:43:56.995000Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-05-14T04:43:58.081205Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-05-14T04:43:58.082351Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-05-14T04:43:58.082365Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-05-14T04:43:58.082622Z 0 [Note] InnoDB: Waiting for purge to start
2018-05-14T04:43:58.136842Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 2560262
2018-05-14T04:43:58.137162Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-05-14T04:43:58.141861Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql_data/mysql/ib_buffer_pool
2018-05-14T04:43:58.444725Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2018-05-14T04:43:58.445354Z 0 [Warning] CA certificate ca.pem is self signed.
2018-05-14T04:43:58.446960Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2018-05-14T04:43:58.446997Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2018-05-14T04:43:58.447032Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2018-05-14T04:43:58.535754Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-05-14T04:43:58.535830Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-05-14T04:43:58.535868Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-05-14T04:43:58.535877Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-05-14T04:43:58.595582Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-05-14T04:43:58.595611Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-05-14T04:43:58.628704Z 0 [Note] Event Scheduler: Loaded 0 events
2018-05-14T04:43:58.629027Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.21-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2018-05-14T04:43:58.691889Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180514  4:43:58
2018-05-14T04:44:03.100533Z 15 [Note] 'CHANGE MASTER TO FOR CHANNEL '' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='172.19.0.12', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2018-05-14T04:44:06.237617Z 18 [Note] Slave I/O thread: Start semi-sync replication to master 'repl_user@172.19.0.12:3306' in log 'FIRST' at position 4
2018-05-14T04:44:06.237651Z 18 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2018-05-14T04:44:06.258694Z 18 [Note] Slave I/O thread for channel '': connected to master 'repl_user@172.19.0.12:3306',replication started in log 'FIRST' at position 4
2018-05-14T04:44:06.906388Z 19 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'FIRST' at position 0, relay log './relay-log-slave.000001' position: 4
2018-05-14T05:14:09.603223Z 18 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013)
2018-05-14T05:14:09.603261Z 18 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at position 491 for channel ''
2018-05-14T05:14:09.603273Z 18 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2018-05-14T05:41:07.149308Z 0 [Note] Giving 38 client threads a chance to die gracefully
2018-05-14T05:41:07.299858Z 0 [Note] Shutting down slave threads
2018-05-14T05:41:07.349632Z 19 [Note] Error reading relay log event for channel '': slave SQL thread was killed
2018-05-14T05:41:10.899411Z 18 [Note] Slave I/O thread killed while reading event for channel ''
2018-05-14T05:41:10.899446Z 18 [Note] Slave I/O thread exiting for channel '', read up to log 'mysql-bin.000001', position 491
2018-05-14T05:41:15.250023Z 0 [Note] Forcefully disconnecting 6 remaining clients
2018-05-14T05:41:18.955529Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 248  user: 'root'

2018-05-14T05:41:18.955638Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 83  user: 'root'

2018-05-14T05:41:18.955667Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 519  user: 'root'

2018-05-14T05:41:19.000919Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 520  user: 'root'

2018-05-14T05:41:19.299454Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 84  user: 'root'

2018-05-14T05:41:19.300965Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 247  user: 'root'

2018-05-14T05:41:19.849430Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2018-05-14T05:41:27.949425Z 0 [Note] Binlog end
2018-05-14T05:41:39.899117Z 0 [Note] Shutting down plugin 'validate_password'
2018-05-14T05:41:40.049307Z 0 [Note] Shutting down plugin 'rpl_semi_sync_slave'
2018-05-14T05:41:40.149137Z 0 [Note] Shutting down plugin 'rpl_semi_sync_master'
2018-05-14T05:41:40.599088Z 0 [Note] unregister_replicator OK
2018-05-14T05:41:40.649082Z 0 [Note] Shutting down plugin 'ngram'
2018-05-14T05:41:40.699123Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2018-05-14T05:41:40.749253Z 0 [Note] Shutting down plugin 'ARCHIVE'
2018-05-14T05:41:40.749285Z 0 [Note] Shutting down plugin 'partition'
2018-05-14T05:41:40.849132Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2018-05-14T05:41:40.949266Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-05-14T05:41:40.949318Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-05-14T05:41:40.949324Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-05-14T05:41:40.949329Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-05-14T05:41:40.949333Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-05-14T05:41:40.949338Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-05-14T05:41:40.949343Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-05-14T05:41:40.949347Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-05-14T05:41:40.949352Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-05-14T05:41:40.949357Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-05-14T05:41:40.949362Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-05-14T05:41:40.949366Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-05-14T05:41:40.949371Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-05-14T05:41:40.949375Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-05-14T05:41:40.949383Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-05-14T05:41:40.949388Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-05-14T05:41:40.949392Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-05-14T05:41:40.949397Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-05-14T05:41:40.949401Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-05-14T05:41:40.949406Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-05-14T05:41:40.949410Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-05-14T05:41:40.949415Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-05-14T05:41:40.949419Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-05-14T05:41:40.949424Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-05-14T05:41:40.949428Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-05-14T05:41:40.949450Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-05-14T05:41:40.949454Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-05-14T05:41:40.949459Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-05-14T05:41:40.949464Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-05-14T05:41:40.949469Z 0 [Note] Shutting down plugin 'InnoDB'
2018-05-14T05:41:42.849724Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-05-14T05:41:45.499521Z 0 [Note] InnoDB: Starting shutdown...
2018-05-14T05:41:47.699340Z 0 [Note] InnoDB: Dumping buffer pool(s) to /mysql_data/mysql/ib_buffer_pool
2018-05-14T05:41:48.299123Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180514  5:41:48
2018-05-14T05:44:02.047621Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2598924
2018-05-14T05:44:02.647310Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-05-14T05:44:03.442776Z 0 [Note] Shutting down plugin 'MEMORY'
2018-05-14T05:44:03.447412Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-05-14T05:44:03.797250Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-05-14T05:44:03.848044Z 0 [Note] Shutting down plugin 'MyISAM'
2018-05-14T05:44:04.097478Z 0 [Note] Shutting down plugin 'CSV'
2018-05-14T05:44:04.097534Z 0 [Note] Shutting down plugin 'sha256_password'
2018-05-14T05:44:04.097540Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-05-14T05:44:05.547396Z 0 [Note] Shutting down plugin 'binlog'
2018-05-14T05:44:07.247755Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2018-05-14T06:16:39.405977Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-05-14T06:16:39.408500Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-log) starting as process 37609 ...
2018-05-14T06:16:39.856904Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-05-14T06:16:39.856928Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-05-14T06:16:39.856936Z 0 [Note] InnoDB: Uses event mutexes
2018-05-14T06:16:39.856957Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2018-05-14T06:16:39.856983Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-05-14T06:16:39.856989Z 0 [Note] InnoDB: Using Linux native AIO
2018-05-14T06:16:39.857264Z 0 [Note] InnoDB: Number of pools: 1
2018-05-14T06:16:39.857437Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-05-14T06:16:39.991685Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-05-14T06:16:40.003121Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-05-14T06:16:40.005913Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-05-14T06:16:40.263644Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-05-14T06:16:41.909182Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-05-14T06:16:41.909257Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-05-14T06:16:42.947601Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-05-14T06:16:42.948878Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-05-14T06:16:42.948900Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-05-14T06:16:42.949166Z 0 [Note] InnoDB: Waiting for purge to start
2018-05-14T06:16:43.019280Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 2598924
2018-05-14T06:16:43.019589Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-05-14T06:16:43.019843Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql_data/mysql/ib_buffer_pool
2018-05-14T06:16:43.816058Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180514  6:16:43
2018-05-14T06:16:44.096249Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2018-05-14T06:16:44.152121Z 0 [Warning] CA certificate ca.pem is self signed.
2018-05-14T06:16:44.153775Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2018-05-14T06:16:44.153805Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2018-05-14T06:16:44.153838Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2018-05-14T06:16:44.343384Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-05-14T06:16:44.343443Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-05-14T06:16:44.353087Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-05-14T06:16:44.353106Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-05-14T06:16:44.514612Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-05-14T06:16:44.514643Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-05-14T06:16:44.874191Z 0 [Warning] Recovery from master pos 491 and file mysql-bin.000001 for channel ''. Previous relay log pos and relay log file had been set to 704, ./relay-log-slave.000002 respectively.
2018-05-14T06:16:45.368150Z 0 [Note] Event Scheduler: Loaded 0 events
2018-05-14T06:16:45.368338Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.21-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2018-05-14T06:16:47.190054Z 5 [Note] 'CHANGE MASTER TO FOR CHANNEL '' executed'. Previous state master_host='172.19.0.12', master_port= 3306, master_log_file='mysql-bin.000001', master_log_pos= 491, master_bind=''. New state master_host='172.19.0.13', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2018-05-14T06:16:50.489275Z 8 [Note] Slave I/O thread: Start semi-sync replication to master 'repl_user@172.19.0.13:3306' in log 'FIRST' at position 4
2018-05-14T06:16:50.489302Z 8 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2018-05-14T06:16:50.508652Z 8 [Note] Slave I/O thread for channel '': connected to master 'repl_user@172.19.0.13:3306',replication started in log 'FIRST' at position 4
2018-05-14T06:16:51.365363Z 9 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'FIRST' at position 0, relay log './relay-log-slave.000001' position: 4
2018-05-14T06:16:54.514329Z 9 [Note] Error reading relay log event for channel '': slave SQL thread was killed
2018-05-14T06:16:54.531495Z 8 [Note] Slave I/O thread killed while reading event for channel ''
2018-05-14T06:16:54.531509Z 8 [Note] Slave I/O thread exiting for channel '', read up to log 'mysql-bin.000002', position 194
2018-05-14T06:16:54.559243Z 43 [Note] 'CHANGE MASTER TO FOR CHANNEL '' executed'. Previous state master_host='172.19.0.13', master_port= 3306, master_log_file='mysql-bin.000002', master_log_pos= 194, master_bind=''. New state master_host='172.19.0.13', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2018-05-14T06:16:57.790978Z 46 [Note] Slave I/O thread: Start semi-sync replication to master 'repl_user@172.19.0.13:3306' in log 'FIRST' at position 4
2018-05-14T06:16:57.790999Z 46 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2018-05-14T06:16:57.811946Z 46 [Note] Slave I/O thread for channel '': connected to master 'repl_user@172.19.0.13:3306',replication started in log 'FIRST' at position 4
2018-05-14T06:16:58.853078Z 47 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'FIRST' at position 0, relay log './relay-log-slave.000001' position: 4
2018-05-14T06:31:10.809264Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4706ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.)