Not the answer you need?
Register and ask your own question!

percona xtraDB cluster is not completely synchronous

MichaelUKMichaelUK EntrantInactive User Role Beginner
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!

Comments

  • MichaelUKMichaelUK Entrant Inactive User Role Beginner
    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';"
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.