After upgrading from 5.6 to 5.7. We found an issue in part of our replication tree that is using various replicate-do-* options. Slave replication had failed on these hosts citing issue with XA transactions for tables that were excluded by the replicate-do-* options:
Last_SQL_Errno: 1399 Last_SQL_Error: Error in Xid_log_event: Commit could not be completed, 'XAER_RMFAIL: The command cannot be executed when global transaction is in the NON-EXISTING state'
It was not possible to skip these errors using slave-skip-errors = 1399 or indeed ALL.
Given that its not possible to disable XA transactions since 5.7-7 what options are there for not replicating certain tables?