问题:MYSQL宕机,如何寻找主库binlog和pos点???
问题:主库宕机,从库如何同步主库的binlog???
步骤一:找到binlog日志,可以到/etc/my.cnf中查看binlog日志。
步骤二:查看mysql-bin.index文件,看看目前最新binlog日志是哪个。
[root@localhost data]# cat mysql-bin.index /application/mysql-5.5.32/data/mysql-bin.000001
/application/mysql-5.5.32/data/mysql-bin.000002
/application/mysql-5.5.32/data/mysql-bin.000003步骤三 :通过mysql-bin.index文件了解,当前最新binlog文件是mysql-bin.000003,
通过mysqlbinlog命令查看,mysql-bin.000003
[root@localhost data]# mysqlbinlog mysql-bin.000003/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at