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

 
discard

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

Browse other questions tagged or ask your own question.