mysqlbinlog查看pos点_如何寻主库binlog和pos点

mysqlbinlog查看pos点_如何寻主库binlog和pos点问题：MYSQL宕机，如何寻主库binlog和pos点

问题：主库宕机，从库如何同步主库的binlog

步骤⼀：到binlog⽇志，可以到/etc/myf中查看binlog⽇志。aaaaaaaaaaaaaaaaaa

步骤⼆：查看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 4

#160803 16:10:35 server id 1 end_log_pos 107 Start: binlog v 4, server v 5.5.32-log created 160803

16:10:35 at startup

# Warning: this binlog is either in use or was not closed properly.

ROLLBACK/*!*/;

BINLOG '

+6ahVw8BAAAAZwAAAGsAAAABAAQANS41LjMyLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

AAAAAAAAAAAAAAAAAAD7pqFXEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA==

'/*!*/;

# at 107

#160803 16:11:54 server id 1 end_log_pos 188Query thread_id=1 exec_time=0 error_code=0

SET TIMESTAMP=1470211914/*!*/;

SET @@session.pseudo_thread_id=1/*!*/;

SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1,

@@session.autocommit=1/*!*/;

SET @@session.sql_mode=0/*!*/;

SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;

/*!\C utf8 *//*!*/;

SET

@@session.character_set_client=33,@@llation_connection=33,@@llation_server=33/*!*/;

SET @@session.lc_time_names=0/*!*/;

SET @@llation_database=DEFAULT/*!*/;

drop database mama

/*!*/;

DELIMITER ;

# End of log file

总结：在从库中输⼊命令 CHANGE MASTER TO ⽤到该信息：mysql-bin.000003 ，POS点188

本文发布于:2024-09-23 09:20:17，感谢您对本站的认可！

标签：主库步骤查看寻找找到命令问题

留言与评论（共有 0 条评论）