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?
users management, when connected to galera cluster
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!
thank you!
Please login to leave a reply, or register at first.