Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC

  1. Series 5.6
  2. Bug #1296792
  3. Comment #1

Comment 1 for bug 1296792

Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

Verified above the same thing with PXC 5.6

On Node1:

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.18 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.05 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>
mysql>
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>
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 | Executed_Gtid_Set |
 +------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000001 | 1800 | | | |
 +------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)

mysql> quit
Bye
root@debian:/var/log/mysql# ll
-bash: ll: command not found
root@debian:/var/log/mysql# ls -al
total 16
drwxr-s--- 2 mysql adm 4096 Aug 6 15:44 .
drwxr-xr-x 15 root root 4096 Jul 23 13:30 ..
-rw-rw---- 1 mysql adm 1800 Aug 6 15:47 mysql-bin.000001
-rw-rw---- 1 mysql adm 32 Aug 6 15:44 mysql-bin.index
root@debian:/var/log/mysql#
root@debian:/var/log/mysql#
root@debian:/var/log/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
#140806 15:44:48 server id 1 end_log_pos 120 CRC32 0x1206506c Start: binlog v 4, server v 5.6.19-67.0-56-log created 140806 15:44:48 at startup
# Warning: this binlog is either in use or was not closed properly.
ROLLBACK/*!*/;
# at 120
#140806 15:45:56 server id 1 end_log_pos 214 CRC32 0xd5f0c018 Query thread_id=4 exec_time=0 error_code=0
use `nil`/*!*/;
SET TIMESTAMP=1407320156/*!*/;
SET @@session.pseudo_thread_id=4/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=1073741824/*!*/;
SET @@session.auto_increment_increment=2, @@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/*!*/;
DELETE FROM `nil`.`mem`
/*!*/;
# at 214
#140806 15:46:02 server id 1 end_log_pos 330 CRC32 0x01e56fb5 Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1407320162/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
DROP TABLE `black` /* generated by server */
/*!*/;
# at 330
#140806 15:46:05 server id 1 end_log_pos 444 CRC32 0x0f7ba2e4 Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1407320165/*!*/;
DROP TABLE `mem` /* generated by server */
/*!*/;
# at 444
#140806 15:46:07 server id 1 end_log_pos 559 CRC32 0xef52b35a Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1407320167/*!*/;
DROP TABLE `inno` /* generated by server */
/*!*/;
# at 559
#140806 15:46:30 server id 1 end_log_pos 787 CRC32 0x4f634473 Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1407320190/*!*/;
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 787
#140806 15:46:36 server id 1 end_log_pos 1014 CRC32 0x0a47f20d Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1407320196/*!*/;
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 1014
#140806 15:46:46 server id 1 end_log_pos 1246 CRC32 0x3ffa78a6 Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1407320206/*!*/;
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 1246
#140806 15:47:17 server id 1 end_log_pos 1322 CRC32 0xcf7a07ee Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1407320237/*!*/;
SET @@session.auto_increment_increment=2, @@session.auto_increment_offset=1/*!*/;
BEGIN
/*!*/;
# at 1322
#140806 15:47:17 server id 1 end_log_pos 1370 CRC32 0x1ae166e3 Table_map: `nil`.`mem` mapped to number 74
# at 1370
#140806 15:47:17 server id 1 end_log_pos 1419 CRC32 0xd2c138b7 Write_rows: table id 74 flags: STMT_END_F
### INSERT INTO `nil`.`mem`
### SET
### @1=1
### @2='aaaaaaaa'
# at 1419
#140806 15:47:17 server id 1 end_log_pos 1496 CRC32 0x06765dd0 Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1407320237/*!*/;
COMMIT
/*!*/;
# at 1496
#140806 15:46:55 server id 1 end_log_pos 1572 CRC32 0x4c5e252b Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1407320215/*!*/;
BEGIN
/*!*/;
# at 1572
#140806 15:46:55 server id 1 end_log_pos 1621 CRC32 0x62b41f19 Table_map: `nil`.`inno` mapped to number 73
# at 1621
#140806 15:46:55 server id 1 end_log_pos 1670 CRC32 0x9a142544 Write_rows: table id 73 flags: STMT_END_F
### INSERT INTO `nil`.`inno`
### SET
### @1=1
### @2='aaaaaaaa'
# at 1670
#140806 15:47:41 server id 1 end_log_pos 1720 CRC32 0xaf3956c0 Table_map: `nil`.`black` mapped to number 75
# at 1720
#140806 15:47:41 server id 1 end_log_pos 1769 CRC32 0xd9ab5633 Write_rows: table id 75 flags: STMT_END_F
### INSERT INTO `nil`.`black`
### SET
### @1=1
### @2='aaaaaaaa'
# at 1769
#140806 15:47:45 server id 1 end_log_pos 1800 CRC32 0x02b2e32e Xid = 38
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@debian:/var/log/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)