# percona xtraDB cluster is not completely synchronous

**URL:** <https://forums.percona.com/t/percona-xtradb-cluster-is-not-completely-synchronous/4577>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [December 7, 2015, 11:23am UTC](https://forums.percona.com/t/percona-xtradb-cluster-is-not-completely-synchronous/4577 "2015-12-07T11:23:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![MichaelUK](https://avatars.discourse-cdn.com/v4/letter/m/f4b2a3/32.png) [@MichaelUK](https://forums.percona.com/u/MichaelUK)\
**Post date:** [December 7, 2015, 11:23am UTC](https://forums.percona.com/t/percona-xtradb-cluster-is-not-completely-synchronous/4577/1 "2015-12-07T11:23:22Z")

</div>

Hi there,

we runing a 3 node percona XtraDB cluster fully synchronous.

The Problem:  
I’ve changed a password in the mysql user table which isn’t replicated to the other nodes at all…but the nodes telling me that they are completely in sync.  
If I add a new mysql user it will be proper synced with all other nodes and everything is fine.

Is that by design or could it be a bug?

Versions:  
Galera 3.12 / percona-xtradb-cluster 5.6.25

(how I changed the password: use mysql; update user set password=PASSWORD(‘abc’) where User=‘abcde’; but it only works for 1 node)

Thanks for advice!

---

<div class="post-metadata">

**Author:** ![MichaelUK](https://avatars.discourse-cdn.com/v4/letter/m/f4b2a3/32.png) [@MichaelUK](https://forums.percona.com/u/MichaelUK)\
**Post date:** [December 7, 2015, 11:46am UTC](https://forums.percona.com/t/percona-xtradb-cluster-is-not-completely-synchronous/4577/2 "2015-12-07T11:46:52Z")

</div>

Alright - the solutions is using the “SET PASSWORD FOR ‘abc’@‘1.1.1.1’ = PASSWORD(‘abcde’);” instead of “update user set password=PASSWORD(‘abc’) where User=‘abcde’;”

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [December 16, 2015, 6:42pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-is-not-completely-synchronous/4577/3 "2015-12-16T18:42:20Z")

</div>

Exactly, direct updates to MyISAM tables are not replicated by design in Galera, but DCL commands are replicated just fine.