Verified the same thing with PXC 5.5 On Node1: [root@percona-pxc55-1 mysql]# mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.5.37-35.0-55-log Percona XtraDB Cluster (GPL), Release rel35.0, Revision 756, WSREP version 25.10, wsrep_25.10.r3985 Copyright (c) 2009-2014 Percona LLC and/or its affiliates Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> mysql> mysql> use test Database changed mysql> mysql> CREATE TABLE `inno` ( -> `i` int(10) unsigned NOT NULL AUTO_INCREMENT, -> `j` varchar(32) NOT NULL, -> PRIMARY KEY (`i`) -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1; Query OK, 0 rows affected (0.09 sec) mysql> CREATE TABLE `mem` ( -> `i` int(10) unsigned NOT NULL AUTO_INCREMENT, -> `j` varchar(32) NOT NULL, -> PRIMARY KEY (`i`) -> ) ENGINE=MEMORY DEFAULT CHARSET=latin1; Query OK, 0 rows affected (0.03 sec) mysql> CREATE TABLE `black` ( -> `i` int(10) unsigned NOT NULL AUTO_INCREMENT, -> `j` varchar(32) NOT NULL, -> PRIMARY KEY (`i`) -> ) ENGINE=BLACKHOLE DEFAULT CHARSET=latin1; Query OK, 0 rows affected (0.03 sec) mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql> insert into inno (j) values ('aaaaaaaa' ); Query OK, 1 row affected (0.00 sec) mysql> insert into mem (j) values ('aaaaaaaa' ); Query OK, 1 row affected (0.00 sec) mysql> insert into black (j) values ('aaaaaaaa' ); Query OK, 1 row affected (0.00 sec) mysql> commit; Query OK, 0 rows affected (0.03 sec) mysql> select * from inno; +---+----------+ | i | j | +---+----------+ | 1 | aaaaaaaa | +---+----------+ 1 row in set (0.00 sec) mysql> select * from mem; +---+----------+ | i | j | +---+----------+ | 1 | aaaaaaaa | +---+----------+ 1 row in set (0.00 sec) mysql> show master status; +------------------+----------+--------------+------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +------------------+----------+--------------+------------------+ | mysql-bin.000001 | 1281 | | | +------------------+----------+--------------+------------------+ 1 row in set (0.00 sec) mysql> mysql> quit Bye [root@percona-pxc55-1 mysql]# ls -al total 280652 drwxr-xr-x. 5 mysql mysql 4096 Aug 11 13:13 . drwxr-xr-x. 17 root root 4096 Mar 3 16:18 .. -rw-rw---- 1 mysql mysql 27572 Aug 11 13:13 error.log -rw------- 1 mysql mysql 134219048 Aug 11 13:14 galera.cache -rw-rw---- 1 mysql mysql 104 Aug 11 13:14 grastate.dat -rw-rw---- 1 mysql mysql 18874368 Aug 11 13:14 ibdata1 -rw-rw---- 1 mysql mysql 67108864 Aug 11 13:14 ib_logfile0 -rw-rw---- 1 mysql mysql 67108864 Aug 11 12:35 ib_logfile1 drwx------ 2 mysql mysql 4096 Aug 11 12:33 mysql -rw-rw---- 1 mysql mysql 1281 Aug 11 13:14 mysql-bin.000001 -rw-rw---- 1 mysql mysql 19 Aug 11 13:13 mysql-bin.index srwxrwxrwx 1 mysql mysql 0 Aug 11 13:13 mysql.sock -rw-rw---- 1 mysql mysql 5 Aug 11 13:13 percona-pxc55-1.pid drwx------ 2 mysql mysql 4096 Aug 11 12:33 performance_schema -rw-r--r-- 1 root root 350 Aug 11 12:33 RPM_UPGRADE_HISTORY -rw-r--r-- 1 mysql mysql 350 Aug 11 12:33 RPM_UPGRADE_MARKER-LAST drwx------ 2 mysql mysql 4096 Aug 11 13:14 test [root@percona-pxc55-1 mysql]# mysqlbinlog --base64-output=DECODE-ROWS --verbose mysql-bin.000001 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 4 #140811 13:13:22 server id 3 end_log_pos 107 Start: binlog v 4, server v 5.5.37-35.0-55-log created 140811 13:13:22 at startup # Warning: this binlog is either in use or was not closed properly. ROLLBACK/*!*/; # at 107 #140811 13:14:01 server id 3 end_log_pos 326 Query thread_id=3 exec_time=0 error_code=0 use `test`/*!*/; SET TIMESTAMP=1407743041/*!*/; SET @@session.pseudo_thread_id=3/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1075838976/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C utf8 *//*!*/; SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; CREATE TABLE `inno` ( `i` int(10) unsigned NOT NULL AUTO_INCREMENT, `j` varchar(32) NOT NULL, PRIMARY KEY (`i`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!*/; # at 326 #140811 13:14:07 server id 3 end_log_pos 544 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1407743047/*!*/; CREATE TABLE `mem` ( `i` int(10) unsigned NOT NULL AUTO_INCREMENT, `j` varchar(32) NOT NULL, PRIMARY KEY (`i`) ) ENGINE=MEMORY DEFAULT CHARSET=latin1 /*!*/; # at 544 #140811 13:14:14 server id 3 end_log_pos 767 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1407743054/*!*/; CREATE TABLE `black` ( `i` int(10) unsigned NOT NULL AUTO_INCREMENT, `j` varchar(32) NOT NULL, PRIMARY KEY (`i`) ) ENGINE=BLACKHOLE DEFAULT CHARSET=latin1 /*!*/; # at 767 #140811 13:14:35 server id 3 end_log_pos 840 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1407743075/*!*/; SET @@session.auto_increment_increment=2, @@session.auto_increment_offset=1/*!*/; BEGIN /*!*/; # at 840 # at 885 #140811 13:14:35 server id 3 end_log_pos 885 Table_map: `test`.`mem` mapped to number 34 #140811 13:14:35 server id 3 end_log_pos 928 Write_rows: table id 34 flags: STMT_END_F ### INSERT INTO test.mem ### SET ### @1=1 ### @2='aaaaaaaa' # at 928 #140811 13:14:35 server id 3 end_log_pos 1002 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1407743075/*!*/; COMMIT /*!*/; # at 1002 #140811 13:14:45 server id 3 end_log_pos 1075 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1407743085/*!*/; BEGIN /*!*/; # at 1075 # at 1121 #140811 13:14:29 server id 3 end_log_pos 1121 Table_map: `test`.`inno` mapped to number 33 #140811 13:14:29 server id 3 end_log_pos 1164 Write_rows: table id 33 flags: STMT_END_F ### INSERT INTO test.inno ### SET ### @1=1 ### @2='aaaaaaaa' # at 1164 # at 1211 #140811 13:14:40 server id 3 end_log_pos 1211 Table_map: `test`.`black` mapped to number 35 #140811 13:14:40 server id 3 end_log_pos 1254 Write_rows: table id 35 flags: STMT_END_F ### INSERT INTO test.black ### SET ### @1=1 ### @2='aaaaaaaa' # at 1254 #140811 13:14:45 server id 3 end_log_pos 1281 Xid = 8 COMMIT/*!*/; DELIMITER ; # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; [root@percona-pxc55-1 mysql]# On Node2: mysql> select * from inno; +---+----------+ | i | j | +---+----------+ | 1 | aaaaaaaa | +---+----------+ 1 row in set (0.00 sec) mysql> select * from mem; Empty set (0.00 sec) mysql>