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

**URL:** <https://forums.percona.com/t/percona-xtradb-cluster-5-6-does-not-auto-sync-the-mysql-proc/4871>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [May 4, 2016, 8:07pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-6-does-not-auto-sync-the-mysql-proc/4871 "2016-05-04T20:07:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Helix](https://avatars.discourse-cdn.com/v4/letter/h/e19adc/32.png) [@Helix](https://forums.percona.com/u/Helix)\
**Post date:** [May 4, 2016, 8:07pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-6-does-not-auto-sync-the-mysql-proc/4871/1 "2016-05-04T20:07:21Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Helix](https://avatars.discourse-cdn.com/v4/letter/h/e19adc/32.png) [@Helix](https://forums.percona.com/u/Helix)\
**Post date:** [May 4, 2016, 9:41pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-6-does-not-auto-sync-the-mysql-proc/4871/2 "2016-05-04T21:41:19Z")

</div>

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。

---

<div class="post-metadata">

**Author:** ![George\_Lorch](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/george_lorch/32/1108_2.png) [@George\_Lorch](https://forums.percona.com/u/George_Lorch)\
**Post date:** [May 5, 2016, 8:29am UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-6-does-not-auto-sync-the-mysql-proc/4871/3 "2016-05-05T08:29:55Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Helix](https://avatars.discourse-cdn.com/v4/letter/h/e19adc/32.png) [@Helix](https://forums.percona.com/u/Helix)\
**Post date:** [May 5, 2016, 9:10pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-6-does-not-auto-sync-the-mysql-proc/4871/4 "2016-05-05T21:10:00Z")

</div>

THX，