replicate SET PASSWORD

[Seppo Jaakola]

SET PASSWORD command is currently not replicated. As the GRANT command is already replicated, we should also implement replication for SET PASSWORD as well.

Note that SET can have several variables to be changed, only PASSWORD part should be replicated.

[Laurent Minost (lolomin)]

Hi Seppo,

Do you know when this bug will be fixed please or at least do you know of a workaround to avoid it please ?
In a future production environment and to do a presentation of the product with such case in the test list, this is a little bit problematic that such a "simple" feature is not yet supported/implemented ... :)
Do you think it could be integrated in the next release ?

Thanks !
Regards,

Laurent

[Seppo Jaakola (seppo-jaakola)]

Two fixes were pushed for this one, where the first was a "semi total order isolation", and latter one refactored the fix as full TOI in revision: http://bazaar.launchpad.net/~codership/codership-mysql/wsrep-5.5/revision/3808

The SET statement can contain other variables and several password changes, and each password change will be replicated separately as one TOI call.

Also, the user does not have to be explicitly defined, current user will be detected and correct SET PASSWORD statement will be generated for TOI replication in every use case.

[Seppo Jaakola (seppo-jaakola)]

This fix has been merged in wsrep-5.6 during the initial 5.6 merge, tracked in bug: lp:1013043