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