mysql binlog_checksum


[Q] how to disable binlog_checksum on mysql master server?

http://dev.mysql.com/doc/refman/5.6/en/replication-options-binary-log.html
*** binlog_checksum has been introduced since mysql 5.6.2 (not available on mysql 5.5)

mysql> show variables like '%checksum';
+---------------------------+-------+
| Variable_name | Value |
+---------------------------+-------+
| binlog_checksum | NONE |
| master_verify_checksum | OFF |
| slave_sql_verify_checksum | ON |
+---------------------------+-------+
3 rows in set (0.01 sec)



***
on ubuntu --> /etc/mysql/my.cnf
on RDS --> DB parameter group


//=== http://mysqlmusings.blogspot.com/2011/04/replication-event-checksum.html

//=== binlog_checksum
binlog_checksum == NONE or CRC32 (CRC-32 checksum === ISO-3309)


"""...
Setting binlog_checksum to NONE means that no checksum is generated,
while setting it to CRC32 means that an ISO-3309 CRC-32 checksum is added to each binary log event.
..."""




//=== master_verify_checksum
"""...
Setting this flag can be useful to verify that the event really written to the binary log is uncorrupted, but it is typically not needed in a replication setting since the slave should verify the event on reception.
..."""

master> SET GLOBAL MASTER_VERIFY_CHECKSUM=1;

//===
slave_sql_verify_checksum
"""...
indicates that the SQL thread should verify the checksum when reading it from the relay log on the slave. Note that this means that the I/O thread writes a checksum to the event written to the relay log, regardless of whether it received an event with a checksum or not.
..."""



//=== SHOW BINLOG EVENTS FROM pos;

"""...
master> SHOW BINLOG EVENTS FROM 261;
+-------------------+-----+------------+-----------+-------------+-----------------------------------------------------------+
| Log_name | Pos | Event_type | Server_id | End_log_pos | Info |
+-------------------+-----+------------+-----------+-------------+-----------------------------------------------------------+
| master-bin.000001 | 261 | Query | 1 | 333 | BEGIN |
| master-bin.000001 | 333 | Intvar | 1 | 365 | INSERT_ID=1 |
..."""


//=== mysqlbinlog --verify-binlog-checksum
$ mysqlbinlog --verify-binlog-checksum master-bin.000001