Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.4.4
-
None
-
MXS-SPRINT-95
Description
I am using the Binlog Router to replicate InnoDB and ColumnStore data. Both work as expected unless the binlog filter is introduced into the configuration. At this point the ColumnStore replication stops committing to the target table. You'll notice that only when replicating to the ColumnStore table does the binglogfilter add a second line about COMMIT. This does not happen when the target is InnoDB table.
MaxScale logging shows the following:
When replicating to a ColumnsStore table:
2019-11-21 19:18:47 info : (8) [binlogfilter] [ ] (columnstore) INSERT INTO `columnstore`.`customers` SET `c` = 'Monty' |
2019-11-21 19:18:47 info : (8) [binlogfilter] [SKIP] (columnstore) COMMIT |
Result: No replication
When replicating to an InnoDB table:
2019-11-21 19:22:13 info : (11) [binlogfilter] [ ] (innodb) INSERT INTO `innodb`.`customers` SET `c` = 'Monty' |
Result: Successful replication