Not the answer you need?
Register and ask your own question!

Replicate User info and permission

syed.furqansyed.furqan EntrantCurrent User Role Beginner
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

Comments

  • shockwavecsshockwavecs Contributor Inactive User Role Beginner
    in my environment I set myisam replication to ON for this specific purpose. Read up http://www.percona.com/doc/percona-xtradb-cluster/5.5/wsrep-system-index.html and make sure it works for you.

    /etc/my.cnf
    ..
    ..
    wsrep_replicate_myisam=ON
    ..
    ..
  • syed.furqansyed.furqan Entrant Current User Role Beginner
    I read somewhere that " wsrep_replicate_myisam=ON" is experimental and is not recommended to use in production.
  • przemekprzemek Percona Support Engineer Percona Staff Role
    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.
  • syed.furqansyed.furqan Entrant Current User Role Beginner
    Thank You.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.