federated table error when GTID is ON for Mysql replication

425 Views Asked by At

I have an issue on mysql replication.

I have master, slave and another independent db, and enforce_gtid_consistency = ON on master and slave.

my test case:

BEGIN;
USE demo;
INSERT INTO demo.log_master(msg)value('demo2');
CALL sp_log_independent('test14');
ROLLBACK;
//commit

When I try to insert federated table in a transaction, It gives error like below.

mysql> call sp_log_independent('test14');
ERROR 1785 (HY000): Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
mysql> 

I want to log all kind of things whether in a transaction or in a non-transaction. Can I exclude federated tables for replication ? or how to force it for replication ?

0

There are 0 best solutions below