mysql 复制诊断-ag凯发k8国际

我们的备份服务器上运行了一个

mysql复制客户端.自上周停电以来,它已停止复制.在此之前,它连续几个月没有运行.

我已经尝试重新启动主设备和从设备,但这没有帮助.我可以从从服务器访问主服务器,因此网络不是问题.

还有什么我可以做的来尝试诊断问题是什么吗？

mysql> show slave status\g;

*************************** 1. row ***************************

slave_io_state:

master_host: master

master_user: username

master_port: 3306

connect_retry: 60

master_log_file: mysql-bin.000060

read_master_log_pos: 46277494

relay_log_file: mysqld-relay-bin.000348

relay_log_pos: 98

relay_master_log_file: mysql-bin.000060

slave_io_running: no

slave_sql_running: yes

replicate_do_db:

replicate_ignore_db:

replicate_do_table:

replicate_ignore_table:

replicate_wild_do_table:

replicate_wild_ignore_table:

last_errno: 0

last_error:

skip_counter: 0

exec_master_log_pos: 46277494

relay_log_space: 98

until_condition: none

until_log_file:

until_log_pos: 0

master_ssl_allowed: no

master_ssl_ca_file:

master_ssl_ca_path:

master_ssl_cert:

master_ssl_cipher:

master_ssl_key:

seconds_behind_master: null

1 row in set (0.00 sec)

error:

no query specified

mysql> show master status\g;

*************************** 1. row ***************************

file: mysql-bin.000069

position: 851796

binlog_do_db:

binlog_ignore_db:

1 row in set (0.00 sec)

error:

no query specified

更新：错误进入daemon.log,而不是mysql.err,这可以解释为什么我找不到它们.问题似乎是主人说日志不可用,这没有多大意义,因为主日志仍然可以使用该日志(和前一个日志).

090710 9:17:35 [note] slave sql thread initialized, starting replication in log 'mysql-bin.000060' at position 46277494, relay log './mysqld-relay-bin.000350' position: 98

090710 9:17:35 [note] slave i/o thread: connected to master 'username@master:3306', replication started in log 'mysql-bin.000060' at position 46277494

090710 9:17:35 [error] error reading packet from server: client requested master to start replication from impossible position ( server_errno=1236)

090710 9:17:35 [error] got fatal error 1236: 'client requested master to start replication from impossible position' from master when reading data from binary log

090710 9:17:35 [note] slave i/o thread exiting, read up to log 'mysql-bin.000060', position 46277494

总结

以上是ag凯发k8国际为你收集整理的mysql 复制诊断_诊断mysql复制问题的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得ag凯发k8国际网站内容还不错，欢迎将ag凯发k8国际推荐给好友。