Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
10.1.6-1
Description
Sadly, many production environments do have InnoDB tables without PRIMARY KEY. This happens for instance in Drupal deployments where either core or modules may not always have a PK defined in their structure.
This MySQL 5.6 optimisation would help MariaDB slaves execute certain queries faster.
Ref http://dev.mysql.com/doc/refman/5.6/en/replication-options-binary-log.html#sysvar_binlog_row_image heading "Optimized Row-Based Replication" quoted below
===
The final piece in improving replication performance is to introduce efficiencies to the binary log itself.
By only replicating those elements of the row image that have changed following INSERT, UPDATE and DELETE operations, replication throughput for both the master and slave(s) can be increased while binary log disk space, network resource and server memory footprint are all reduced.
This is especially useful when replicating across datacenters or cloud availability zones.
Another performance enhancements is the was Row-Based Replication events are handled on the slave against tables without Primary Keys. Updates would be made via multiple table scans. In MySQL 5.6, no matter size of the event, only one table scan is performed, significantly reducing the apply time.
You can learn more about Optimized Row Based Replication from the MySQL documentation (http://dev.mysql.com/doc/refman/5.6/en/replication-options-binary-log.html#sysvar_binlog_row_image)
===
Attachments
Issue Links
- duplicates
-
MDEV-7471 Enable binlog_row_image parameter in MariaDB
- Closed
- is duplicated by
-
MDEV-5765 Replication 5.6=>10.0 causes garbage data on slave if master has binlog_row_image=minimal
- Open
- relates to
-
MDEV-8398 Minimal/NOBLOB Binlog Row Image replication fails when tables from master have different PK in slave
- Open
-
MDEV-8408 Assertion `inited==INDEX' failed in int handler::ha_index_first(uchar*)
- Closed
-
MDEV-8426 mysqlbinlog: "Corrupted replication event was detected. Not printing the value" with binlog-row-image=minimal
- Closed
-
MDEV-5765 Replication 5.6=>10.0 causes garbage data on slave if master has binlog_row_image=minimal
- Open
- links to