# percona xtraDB cluster is not completely synchronous

**URL:** <https://forums.percona.com/t/percona-xtradb-cluster-is-not-completely-synchronous/4576>\
**Category:** Other MySQL® Questions\
**Created:** [December 7, 2015, 11:05am UTC](https://forums.percona.com/t/percona-xtradb-cluster-is-not-completely-synchronous/4576 "2015-12-07T11:05:50Z")\
**Posts on this page:** 2\
**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:05am UTC](https://forums.percona.com/t/percona-xtradb-cluster-is-not-completely-synchronous/4576/1 "2015-12-07T11:05:50Z")

</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:47am UTC](https://forums.percona.com/t/percona-xtradb-cluster-is-not-completely-synchronous/4576/2 "2015-12-07T11:47:32Z")

</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’;”