[Maria-developers] binlog_row_image
Hi, Is anyone familiar with binlog_row_image in MySQL 5.6, would it make sense to add it to MariaDB? I received a request for it where they have a wide table with high write activity and only a few fields are updated for each DML. Apparently binlog_row_image would be efficient in this case. There is also a JIRA issue about binlog_row_image from the MySQL compatibility point of view: https://mariadb.atlassian.net/browse/MDEV-7471 Rasmus -- Rasmus Johansson, VP Engineering MariaDB | t: +358 50 499 9589 | Skype: ratzpo
Rasmus Johansson <rasmus@mariadb.com> writes:
Is anyone familiar with binlog_row_image in MySQL 5.6, would it make sense to add it to MariaDB?
Sure it makes sense. Adding the slave side, where the slave is able to process the new smaller row images, is required to be able to replicate from a MySQL 5.6 master running with --binlog-row-image=minimal|noblob. Adding the master side (the --binlog-row-image option) would additionally allow a MariaDB->MariaDB replication to benefit from the possible efficiency gain of smaller row events (in row-based replication). However, with the way that merge procedures were changed at the MariaDB 10.0 release, non-InnoDB MySQL features or bugfixes are no longer added automatically to MariaDB. It requires someone to manually do it on a case-by-case basis. - Kristian.
participants (2)
-
Kristian Nielsen -
Rasmus Johansson