[google-cloud-sql-discuss] Re: I can not update when I use replication?

Hello Jonathan, 

The official MySQL documentation, at "17.1.3.4 Restrictions on Replication with GTIDs", says: 

"Updates involving nontransactional storage engines.  When using GTIDs, updates to tables using nontransactional storage engines such as MyISAM cannot be made in the same statement or transaction as updates to tables using transactional storage engines such as InnoDB.

This restriction is due to the fact that updates to tables that use a nontransactional storage engine mixed with updates to tables that use a transactional storage engine within the same transaction can result in multiple GTIDs being assigned to the same transaction. "

It is the mixed transactional and non-transactional table updates that are not supported, exactly what is stated on the page you linked: "Transactions or statements that update transactional and non-transactional tables". 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/75a4c0f9-4134-4d8f-aae7-32e13791183b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.