We notice a strange behavior on « Percona XtraDB Cluster” with commands (DROP, INSERT, UPDATE, DELETE, CREATE etc)
Server version: 5.5.41-37.0-55 Percona XtraDB Cluster (GPL),
WSREP version 25.11,
Cluster size: 3 nodes
System: RHEL 6.6
Some mysql commands executed in one node are replicated but other commands executed in one node are limited only in the node without a replication.
When we check, the cluster is still synced in any case (command replicated or not).
Cluster of 3 node, table : user with a primary key
“CREATE USER” in one node is replicated in all other nodes.
“DELETE USER” in one node is limited on this node, there is no a replication in other nodes.
“DROP USER” in one node is replicated in all other nodes.
Is it normal that some commands are replicated and other are limited to one node?
Is it possible to have a list of mysql commands that are replicated in the cluster and commands that are limited in one node?
Could you please help use? Thanks in advance for your support