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.