Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

As far as I understand, Galera does not support table locking, but what information can be retrieved about the last query?

LOCK/UNLOCK TABLES cannot be supported in master-master replication. Lock functions (GET_LOCK(), RELEASE_LOCK(),…) are not supported.

What about LAST_INSERT_ID()? At some point I read, that the nodes use different auto increment values, but it said nothing whether the last insert id will be returned.

And a related question: In PHP I use the mysql_info function to retrieve the "rows matched" on UPDATE. Is this information expected to be availible in a Galera cluster?

share|improve this question
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.