Skip to content

Replicating from Oracle 5.6

Jay Edgar edited this page Mar 17, 2017 · 1 revision

Facebook MySQL is compatible when replicating from Oracle MySQL 5.6 even with all the new features such a Global Transaction Identifiers (GTID). Replicating from Facebook MySQL to Oracle MySQL 5.6 is compatible with statement based replication (SBR), but this is not the case with row based replication (RBR) due to the following features in Facebook MySQL:

  • Table map log event's format is changed to include column names. This ensures RBR works with different schema on master and slave.
  • Primary key and sign information is included in table map log event.

Note that these compatibilities are only assumed. Facebook does not do any tests to validate that this will work.

Clone this wiki locally