MySQL Forums
Forum List  »  NDB clusters

Re: Privilege distribution
Posted by: Mikael Ronström
Date: July 19, 2017 05:29PM

Great that you got it working with Docker Swarm.

Not an expert in privilege distribution, but it certainly sounds to
me like it is a cache that needs to be flushed.

Here is a cut from the docs:

Once the conversion to distributed privileges has been made, any time a MySQL user account is created, dropped, or has its privileges updated on any SQL node, the changes take effect immediately on all other MySQL servers attached to the cluster. Once privileges are distributed, any new MySQL Servers that connect to the cluster automatically participate in the distribution.

For clients connected to SQL nodes at the time that mysql_cluster_move_privileges is executed, you may need to execute FLUSH PRIVILEGES on those SQL nodes, or to disconnect and then reconnect the clients, in order for those clients to be able to see the changes in privileges.

All MySQL user privileges are distributed across all connected MySQL Servers. This includes any privileges associated with views and stored routines, even though distribution of views and stored routines themselves is not currently supported.

So presumably running FLUSH PRIVILIGES in a MySQL Server
should suffice to get the password copied over to it.
The MySQL Server has some caching layers for the privileges.

Options: ReplyQuote

Written By
July 18, 2017 11:40AM
Re: Privilege distribution
July 19, 2017 05:29PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.