Users Management and MySQL Workbench

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hi all:

I have a cluster with 4 nodes running Ubuntu Server 12.04, Percona XtraDB Cluster 5.5 and Keepalived for load balancing and automatic failover.

I’m using MySQL Workbench to admin the cluster. The databases are getting replicated accross all the nodes but the users and schema privileges are not getting replicated.

I’ll tryed by using the floating IP and the IP of each node with the same problem.

What I must do to get the user data and permissions replicated automaticaly accross all the nodes?

Thanks in advance for your help.

2

Try setting

wsrep_replicate_myisam=1

in my.cnf and restart the nodes. This however has the consequence that changes to all MyISAM tables will be replicated, not only administrative ones.

3

Thanks ayurchen, that did the trick, that works like a charm.

Thanks again.