Question

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

Answer 1

从服务器有操作
change master to master_host='10.99.0.10',master_user='slave',master_password='slave+11',master_log_file='mysql-bin.000001',master_log_pos=336;
flush privileges;

start slave;