Hello everybody
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),
Release rel37.0,
Revision 853,
WSREP version 25.11,
wsrep_25.11.r4027
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).
Below example:
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