10,608
社区成员
发帖
与我相关
我的任务
分享mysql主从同步，从库会隔几分钟或更长时间重启一次，直至停止
error-log如下
161212 15:50:04 mysqld_safe Number of processes running now: 0
161212 15:50:04 mysqld_safe mysqld restarted
161212 15:50:05 [Warning] 'for replication startup options' is deprecated and will be removed in a future release. Please use ''CHANGE MASTER'' instead.
161212 15:50:07 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000050' at position 32788587, relay log './mysql-relay-bin.000041' position: 3145994
161212 15:50:07 [Note] Slave I/O thread: connected to master 'zmtread@10.51.62.159:3306',replication started in log 'mysql-bin.000050' at position 33120121
161212 15:50:08 [Note] Event Scheduler: Loaded 0 events
161212 15:50:08 [Note] /www/wdlinux/mysql-5.1.69/libexec/mysqld: ready for connections.
Version: '5.1.69' socket: '/tmp/mysql.sock' port: 3306 Source distribution
161212 15:55:29 mysqld_safe Number of processes running now: 0
161212 15:55:29 mysqld_safe mysqld restarted
161212 15:55:30 [Warning] 'for replication startup options' is deprecated and will be removed in a future release. Please use ''CHANGE MASTER'' instead.
161212 15:55:30 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000050' at position 35336028, relay log './mysql-relay-bin.000043' position: 2216158
161212 15:55:30 [Note] Slave I/O thread: connected to master 'zmtread@10.51.62.159:3306',replication started in log 'mysql-bin.000050' at position 35529695
161212 15:55:30 [Note] Event Scheduler: Loaded 0 events
161212 15:55:30 [Note] /www/wdlinux/mysql-5.1.69/libexec/mysqld: ready for connections.
Version: '5.1.69' socket: '/tmp/mysql.sock' port: 3306 Source distribution
161212 16:02:20 mysqld_safe Number of processes running now: 0
161212 16:02:20 mysqld_safe mysqld restarted
161212 16:02:20 [Warning] 'for replication startup options' is deprecated and will be removed in a future release. Please use ''CHANGE MASTER'' instead.
161212 16:02:23 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.69/var/iZ254nqrxxhZ.pid ended
161212 15:50:04 mysqld_safe Number of processes running now: 0
161212 15:50:04 mysqld_safe mysqld restarted
161212 15:50:05 [Warning] 'for replication startup options' is deprecated and will be removed in a future release. Please use ''CHANGE MASTER'' instead.
161212 15:50:07 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000050' at position 32788587, relay log './mysql-relay-bin.000041' position: 3145994
161212 15:50:07 [Note] Slave I/O thread: connected to master 'zmtread@10.51.62.159:3306',replication started in log 'mysql-bin.000050' at position 33120121
161212 15:50:08 [Note] Event Scheduler: Loaded 0 events
161212 15:50:08 [Note] /www/wdlinux/mysql-5.1.69/libexec/mysqld: ready for connections.
Version: '5.1.69' socket: '/tmp/mysql.sock' port: 3306 Source distribution
161212 15:55:29 mysqld_safe Number of processes running now: 0
161212 15:55:29 mysqld_safe mysqld restarted
161212 15:55:30 [Warning] 'for replication startup options' is deprecated and will be removed in a future release. Please use ''CHANGE MASTER'' instead.
161212 15:55:30 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000050' at position 35336028, relay log './mysql-relay-bin.000043' position: 2216158
161212 15:55:30 [Note] Slave I/O thread: connected to master 'zmtread@10.51.62.159:3306',replication started in log 'mysql-bin.000050' at position 35529695
161212 15:55:30 [Note] Event Scheduler: Loaded 0 events
161212 15:55:30 [Note] /www/wdlinux/mysql-5.1.69/libexec/mysqld: ready for connections.
Version: '5.1.69' socket: '/tmp/mysql.sock' port: 3306 Source distribution
161212 16:02:20 mysqld_safe Number of processes running now: 0
161212 16:02:20 mysqld_safe mysqld restarted
161212 16:02:20 [Warning] 'for replication startup options' is deprecated and will be removed in a future release. Please use ''CHANGE MASTER'' instead.
161212 16:02:23 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.69/var/iZ254nqrxxhZ.pid ended
...全文
请发表友善的回复…
发表回复
