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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

I know this is a really old question, but yet both are supported just as they are in standard mysql.

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.