User privileges replication

[Laurent MINOST]

Hi,

Is this normal that this query is not propagated/replicated over the whole cluster please : 

SET PASSWORD FOR 'root'@'localhost' = PASSWORD( '********' ) 

This change the local node password on which I'm currently connected but does not update the password on the others connected node ?

Thanks.
Regards,

Laurent

[seppo....@codership.com]

Hi Laurent,

SET PASSWORD is indeed not replicated. However, GRANT commands are
replicated and this is not consistent behavior, so we probably need to
implement SET PASSWORD replication. I will file a LP bug tracker for
this task.
This is a bit more complicated to deal with, as the SET command can
have several variables and we are supposed to replicate only PASSWORD
part of the command.

-seppo

[Laurent MINOST]

Hi Seppo,

Thanks for your answer.
Yes, I was thinking of such a problem since SET can be use in many different cases.

Could you please post the LP bug entry URL when you create it so we will be able to know when the problem will be fixed ?

Thks a lot !

Laurent

[seppo....@codership.com]

Laurent,

The bug tracker is this one:
https://bugs.launchpad.net/codership-mysql/+bug/1005919

I can fix this real quick to support use case where SET contains only
PASSWORD (and no other variables to change with same go).

[Laurent MINOST]

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....@codership.com]

SET PASSWORD replication has been pushed in development branch and
will be part of next regular release build, which now looks to happen
during next week.

[Laurent MINOST]

Hi Seppo,

Thanks a lot for the fast management for producing this fix !

Regards,

Laurent