users management, when connected to galera cluster

[expired user #7067]'s profile image [expired user #7067] posted 9 years ago in Feature discussion Permalink
tried updating and creating users when connected to a haprox lb in front of a galera cluster, and this left me in a inconsitent state. This because changes to myisam tables aren't replicated by default.

According to http://galeracluster.com/documentation-webpages/userchanges.html, if the statements where using "create user" and "grant" instead of insert, it would work; could the queries in heidisql be altered according to this? would this breake other functions on postgre or mssql?
ansgar's profile image ansgar posted 9 years ago Permalink
HeidiSQL already uses CREATE USER, GRANT and SHOW GRANTS syntax on MySQL. Where did you see an INSERT?
[expired user #7067]'s profile image [expired user #7067] posted 9 years ago Permalink
Ah ok: might be because I've used a outdated version. The issue prompting me to write the post was after changing a users host in v7 on the cluster, it only applied the change at the current node. retested now with a updated copy of heidisql, and all commands does indeed seem to be of ddl type.

thank you!

Please login to leave a reply, or register at first.