GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Replicate User info and permission

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

  • Replicate User info and permission

    Hi,

    I just installed Percona XtraDB Cluster, databases are replicating fine but I don't see users and permission I create on one server is replicating to another one.

    Another thing I noticed MySQL.user table is using MYISAM engine. How can replicate user and permissions to other server in the cluster with or without MYISAM in percona cluster.

    Thanks

  • #2
    in my environment I set myisam replication to ON for this specific purpose. Read up http://www.percona.com/doc/percona-x...tem-index.html and make sure it works for you.

    /etc/my.cnf
    ..
    ..
    wsrep_replicate_myisam=ON
    ..
    ..

    Comment


    • #3
      I read somewhere that " wsrep_replicate_myisam=ON" is experimental and is not recommended to use in production.

      Comment


      • #4
        Syed, just don't edit the mysql.user table directly. For managing user rights you should use: GRANT, REVOKE, SET PASSWORD, etc. Such statements are replicated regardless of table engine used for user table.

        Comment


        • #5
          Thank You.

          Comment

          Working...
          X