GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Users Management and MySQL Workbench

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Users Management and MySQL Workbench

    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.

    Comment


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

      Thanks again.

      Comment

      Working...
      X