/usr/sbin/mysqld, Version: 5.5.58-0ubuntu0.14.04.1-log ((Ubuntu)). started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument 180419 11:42:52 [Note] /usr/sbin/mysqld: Normal shutdown 180419 11:42:52 [Note] Event Scheduler: Purging the queue. 0 events 180419 11:42:52 [Note] Error reading relay log event: slave SQL thread was killed 180419 11:42:52 [Note] Slave I/O thread killed while connecting to master 180419 11:42:52 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000001', position 107 180419 11:42:52 InnoDB: Starting shutdown... 180419 11:42:53 InnoDB: Shutdown completed; log sequence number 64141772877 180419 11:42:53 [Note] /usr/sbin/mysqld: Shutdown complete 180419 11:44:12 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 180419 11:44:12 [Note] Plugin 'FEDERATED' is disabled. 180419 11:44:12 InnoDB: The InnoDB memory heap is disabled 180419 11:44:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins 180419 11:44:12 InnoDB: Compressed tables use zlib 1.2.8 180419 11:44:12 InnoDB: Using Linux native AIO 180419 11:44:12 InnoDB: Initializing buffer pool, size = 128.0M 180419 11:44:12 InnoDB: Completed initialization of buffer pool 180419 11:44:12 InnoDB: highest supported file format is Barracuda. 180419 11:44:14 InnoDB: Waiting for the background threads to start 180419 11:44:15 InnoDB: 5.5.58 started; log sequence number 64141772877 /usr/sbin/mysqld, Version: 5.5.58-0ubuntu0.14.04.1-log ((Ubuntu)). started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument 180419 11:44:15 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 180419 11:44:15 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 180419 11:44:15 [Note] Server socket created on IP: '0.0.0.0'. 180419 11:44:15 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=mysqld-relay-bin' to avoid this problem. 180419 11:44:15 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './mysqld-relay-bin.001136' position: 4 180419 11:44:15 [Note] Event Scheduler: Loaded 0 events 180419 11:44:15 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.58-0ubuntu0.14.04.1-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 180419 11:46:22 [ERROR] Slave I/O: error connecting to master 'replicator@202.134.31.171:3306' - retry-time: 60 retries: 86400, Error_code: 2003 180419 11:52:32 [Note] /usr/sbin/mysqld: Normal shutdown 180419 11:52:32 [Note] Event Scheduler: Purging the queue. 0 events 180419 11:52:32 [Note] Error reading relay log event: slave SQL thread was killed 180419 11:52:32 [Note] Slave I/O thread killed while connecting to master 180419 11:52:32 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000001', position 107 180419 11:52:32 InnoDB: Starting shutdown... 180419 11:52:33 InnoDB: Shutdown completed; log sequence number 64141772877 180419 11:52:33 [Note] /usr/sbin/mysqld: Shutdown complete 180419 11:53:52 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 180419 11:53:52 [Note] Plugin 'FEDERATED' is disabled. 180419 11:53:52 InnoDB: The InnoDB memory heap is disabled 180419 11:53:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins 180419 11:53:52 InnoDB: Compressed tables use zlib 1.2.8 180419 11:53:52 InnoDB: Using Linux native AIO 180419 11:53:52 InnoDB: Initializing buffer pool, size = 128.0M 180419 11:53:52 InnoDB: Completed initialization of buffer pool 180419 11:53:52 InnoDB: highest supported file format is Barracuda. 180419 11:53:54 InnoDB: Waiting for the background threads to start 180419 11:53:55 InnoDB: 5.5.58 started; log sequence number 64141772877 /usr/sbin/mysqld, Version: 5.5.58-0ubuntu0.14.04.1-log ((Ubuntu)). started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument 180419 11:53:55 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 180419 11:53:55 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 180419 11:53:55 [Note] Server socket created on IP: '0.0.0.0'. 180419 11:53:55 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=mysqld-relay-bin' to avoid this problem. 180419 11:53:55 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './mysqld-relay-bin.001139' position: 4 180419 11:53:55 [Note] Event Scheduler: Loaded 0 events 180419 11:53:55 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.58-0ubuntu0.14.04.1-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 180419 11:56:02 [ERROR] Slave I/O: error connecting to master 'replicator@202.134.31.171:3306' - retry-time: 60 retries: 86400, Error_code: 2003 180419 12:36:09 [Note] /usr/sbin/mysqld: Normal shutdown 180419 12:36:09 [Note] Event Scheduler: Purging the queue. 0 events 180419 12:36:09 [Note] Error reading relay log event: slave SQL thread was killed 180419 12:36:09 [Note] Slave I/O thread killed while connecting to master 180419 12:36:09 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000001', position 107 180419 12:36:09 InnoDB: Starting shutdown... 180419 12:36:11 InnoDB: Shutdown completed; log sequence number 64141818863 180419 12:36:11 [Note] /usr/sbin/mysqld: Shutdown complete 180419 12:37:31 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 180419 12:37:31 [Note] Plugin 'FEDERATED' is disabled. 180419 12:37:31 InnoDB: The InnoDB memory heap is disabled 180419 12:37:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins 180419 12:37:31 InnoDB: Compressed tables use zlib 1.2.8 180419 12:37:31 InnoDB: Using Linux native AIO 180419 12:37:31 InnoDB: Initializing buffer pool, size = 128.0M 180419 12:37:31 InnoDB: Completed initialization of buffer pool 180419 12:37:31 InnoDB: highest supported file format is Barracuda. 180419 12:37:33 InnoDB: Waiting for the background threads to start 180419 12:37:34 InnoDB: 5.5.58 started; log sequence number 64141818863 /usr/sbin/mysqld, Version: 5.5.58-0ubuntu0.14.04.1-log ((Ubuntu)). started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument 180419 12:37:34 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 180419 12:37:34 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 180419 12:37:34 [Note] Server socket created on IP: '0.0.0.0'. 180419 12:37:34 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=mysqld-relay-bin' to avoid this problem. 180419 12:37:34 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './mysqld-relay-bin.001140' position: 4 180419 12:37:34 [Note] Event Scheduler: Loaded 0 events 180419 12:37:34 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.58-0ubuntu0.14.04.1-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 180419 12:39:41 [ERROR] Slave I/O: error connecting to master 'replicator@202.134.31.171:3306' - retry-time: 60 retries: 86400, Error_code: 2003 180419 14:14:53 [Note] /usr/sbin/mysqld: Normal shutdown 180419 14:14:53 [Note] Event Scheduler: Purging the queue. 0 events 180419 14:14:53 [Note] Error reading relay log event: slave SQL thread was killed 180419 14:14:53 [Note] Slave I/O thread killed while connecting to master 180419 14:14:53 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000001', position 107 180419 14:14:53 InnoDB: Starting shutdown... 180419 14:14:54 InnoDB: Shutdown completed; log sequence number 64141818863 180419 14:14:54 [Note] /usr/sbin/mysqld: Shutdown complete