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

Percona XtraDB Cluster 5.6 does not auto sync the mysql.proc

HelixHelix EntrantInactive User Role Beginner
There are 3 nodes in our Custer,I updated the field “definer” in mysql.proc table ,then I found that the values of others 2 nodes is the old one,PXC does not auto sync that kind of data?


is there any way to get the PXC auto sync the values in mysql.proc when update the “definer” ?

Comments

  • HelixHelix Entrant Inactive User Role Beginner
    But ,the mysql replication did , Node1 -> Slave ,
    node1> update mysql.proc set definer='[email protected]%' ;

    the values "'[email protected]%' will sync to slave ,but PXC node2 node3 do not。
  • George LorchGeorge Lorch Percona Percona Moderator Role Patron
    mysql.proc is a system table. System tables in 5.5 and 5.6 are MyISAM. Galera replication does not replicate MyISAM tables, only InnoDB/XtraDB. Therefore, no, PXC will not replicate changes made to mysql.* tables.

    --
    George O. Lorch III
    Software Engineer, Percona
  • HelixHelix Entrant Inactive User Role Beginner
    THX,
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.