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

XtraDB 5.5: some mysql commands are replicated but other are limited to one node.

florent.integratorflorent.integrator EntrantInactive User Role Beginner
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.


1) Is it normal that some commands are replicated and other are limited to one node?

2) 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

Comments

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.