[Maria-developers] Structure of MariaDB 10.0 binary logs
![](https://secure.gravatar.com/avatar/12bad1697bb950d0fcb4b0da2d436470.jpg?s=120&d=mm&r=g)
Hi, Where can I find a detailed structure of the binary logs supported by MariaDB 10.0.x? Specifically, I would like to know * what are the differences between binary logs in MariaDB 5.5 and 10.0 * what are the differences between binary logs in MariaDB 10.0 and MySQL 5.6. The purpose of this request id to parse the binary logs for usage in external applications. Thanks Giuseppe
![](https://secure.gravatar.com/avatar/99fde0c1dfd216326aae0aff30d493f1.jpg?s=120&d=mm&r=g)
Giuseppe Maxia
Specifically, I would like to know * what are the differences between binary logs in MariaDB 5.5 and 10.0 * what are the differences between binary logs in MariaDB 10.0 and MySQL 5.6.
I think the difference is mainly the addition of new events. At least, I cannot think of any other major differences off the top of my head. Thus, you can check the enum Log_event_type in sql/log_event.h in the different versions against each other to see which events are added in which version and missing in the other versions. At least some of the added events have documentation of the format of the event data in the comments in sql/log_event.h at the corresponding class definition. Unfortunately I am not aware of any systematic documentation for reading binlog events or differences between versions. It would certainly be a useful addition. But you're most welcome to ask if you have any questions, of course. - Kristian.
![](https://secure.gravatar.com/avatar/12bad1697bb950d0fcb4b0da2d436470.jpg?s=120&d=mm&r=g)
Thanks, Kristian. This will get me started. Cheers Giuseppe On Saturday, July 20, 2013 at 10:33 , Kristian Nielsen wrote:
Giuseppe Maxia
writes: Specifically, I would like to know * what are the differences between binary logs in MariaDB 5.5 and 10.0 * what are the differences between binary logs in MariaDB 10.0 and MySQL 5.6.
I think the difference is mainly the addition of new events. At least, I cannot think of any other major differences off the top of my head.
Thus, you can check the enum Log_event_type in sql/log_event.h in the different versions against each other to see which events are added in which version and missing in the other versions.
At least some of the added events have documentation of the format of the event data in the comments in sql/log_event.h at the corresponding class definition.
Unfortunately I am not aware of any systematic documentation for reading binlog events or differences between versions. It would certainly be a useful addition.
But you're most welcome to ask if you have any questions, of course.
- Kristian.
participants (2)
-
Giuseppe Maxia
-
Kristian Nielsen