With upstream also able to reproduce
Node 1 *****
mysql> select * from test.demo_test; +-----+--------------+------+------+------+ | c1 | c2 | c3 | c4 | c5 | +-----+--------------+------+------+------+ | a11 | 123456789 | 10 | 2 | 0 | | a12 | 123456789 | 10 | 1 | 0 | | AA | HELLO, HELLO | 8 | 0 | 0 | +-----+--------------+------+------+------+ 3 rows in set (0.00 sec)
mysql> select * from test.demo_test;select @@wsrep_node_name; +-----+--------------+------+------+------+ | c1 | c2 | c3 | c4 | c5 | +-----+--------------+------+------+------+ | a11 | 123456789 | 10 | 2 | 0 | | a12 | 123456789 | 10 | 1 | 0 | | AA | HELLO, HELLO | 8 | 0 | 0 | +-----+--------------+------+------+------+ 3 rows in set (0.00 sec)
+-------------------+ | @@wsrep_node_name | +-------------------+ | node1 | +-------------------+ 1 row in set (0.00 sec)
mysql> select @@version,@@version_comment; +------------+-------------------------------------------+ | @@version | @@version_comment | +------------+-------------------------------------------+ | 5.6.23-log | MySQL Community Server (GPL), wsrep_25.10 | +------------+-------------------------------------------+ 1 row in set (0.00 sec)
mysql>
Node 2 ******
mysql> select * from test.demo_test;select @@wsrep_node_name; +----+--------------+------+------+------+ | c1 | c2 | c3 | c4 | c5 | +----+--------------+------+------+------+ | AA | HELLO, HELLO | 8 | 0 | 0 | +----+--------------+------+------+------+ 1 row in set (0.00 sec)
+-------------------+ | @@wsrep_node_name | +-------------------+ | node2 | +-------------------+ 1 row in set (0.01 sec)
With upstream also able to reproduce
Node 1
*****
mysql> select * from test.demo_test; ------- ------- +------ +------ +------ + ------- ------- +------ +------ +------ + ------- ------- +------ +------ +------ +
+-----+
| c1 | c2 | c3 | c4 | c5 |
+-----+
| a11 | 123456789 | 10 | 2 | 0 |
| a12 | 123456789 | 10 | 1 | 0 |
| AA | HELLO, HELLO | 8 | 0 | 0 |
+-----+
3 rows in set (0.00 sec)
mysql> select * from test.demo_ test;select @@wsrep_node_name; ------- ------- +------ +------ +------ + ------- ------- +------ +------ +------ + ------- ------- +------ +------ +------ +
+-----+
| c1 | c2 | c3 | c4 | c5 |
+-----+
| a11 | 123456789 | 10 | 2 | 0 |
| a12 | 123456789 | 10 | 1 | 0 |
| AA | HELLO, HELLO | 8 | 0 | 0 |
+-----+
3 rows in set (0.00 sec)
+------ ------- ------+ ------- ------+ ------- ------+
| @@wsrep_node_name |
+------
| node1 |
+------
1 row in set (0.00 sec)
mysql> select @@version, @@version_ comment; ------+ ------- ------- ------- ------- ------- ------- -+ ------+ ------- ------- ------- ------- ------- ------- -+ ------+ ------- ------- ------- ------- ------- ------- -+
+------
| @@version | @@version_comment |
+------
| 5.6.23-log | MySQL Community Server (GPL), wsrep_25.10 |
+------
1 row in set (0.00 sec)
mysql>
Node 2
******
mysql> select * from test.demo_ test;select @@wsrep_node_name; ------- ------+ ------+ ------+ ------+ ------- ------+ ------+ ------+ ------+ ------- ------+ ------+ ------+ ------+
+----+-
| c1 | c2 | c3 | c4 | c5 |
+----+-
| AA | HELLO, HELLO | 8 | 0 | 0 |
+----+-
1 row in set (0.00 sec)
+------ ------- ------+ ------- ------+ ------- ------+
| @@wsrep_node_name |
+------
| node2 |
+------
1 row in set (0.01 sec)
mysql> select @@version, @@version_ comment; ------+ ------- ------- ------- ------- ------- ------- -+ ------+ ------- ------- ------- ------- ------- ------- -+ ------+ ------- ------- ------- ------- ------- ------- -+
+------
| @@version | @@version_comment |
+------
| 5.6.23-log | MySQL Community Server (GPL), wsrep_25.10 |
+------
1 row in set (0.00 sec)
mysql>