MySQL Forums
Forum List  »  Replication

Re: Master binary log rotation not proper after restarting mysql server?
Posted by: shahid hussain
Date: March 18, 2014 06:57AM

Or is there any way to avoid verifying binary log curruption?
i tried below steps but it dint work.
1. I disabled master_verify_checksum at master
2. manuallly modified one charector from binlog file
3. tried show binlog event query

mysql> show global variables like '%check%';
+---------------------------+-------+
| Variable_name | Value |
+---------------------------+-------+
| binlog_checksum | NONE |
| foreign_key_checks | ON |
| innodb_checksum_algorithm | none |
| innodb_checksums | OFF |
| innodb_file_format_check | ON |
| master_verify_checksum | OFF |
| slave_checkpoint_group | 512 |
| slave_checkpoint_period | 300 |
| slave_sql_verify_checksum | OFF |
| unique_checks | ON |
+---------------------------+-------+
10 rows in set (0.00 sec)

mysql> SHOW BINLOG EVENTS in 'mysql225-bin.000003';
ERROR 1220 (HY000): Error when executing command SHOW BINLOG EVENTS: Wrong offset or I/O error

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Master binary log rotation not proper after restarting mysql server?
1020
March 18, 2014 06:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.