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

[Helix]

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” ?

[Helix]

But ,the mysql replication did , Node1 -> Slave ,
node1> update mysql.proc set definer=‘aaa@%’ ;

the values "‘aaa@%’ will sync to slave ,but PXC node2 node3 do not。

[George_Lorch]

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

[Helix]

THX，