wsrep_replicate_myisam needs to be a session variable

[Raghavendra D Prabhu]

Currently it is a global variable, which can break things like
https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1280270

[Nilnandan Joshi (nilnandan-joshi)]

Confirmed with 5.5.37 and 5.6.19. Even as per doc, the scope is global.

http://www.percona.com/doc/percona-xtradb-cluster/5.6/wsrep-system-index.html#wsrep_replicate_myisam
http://www.percona.com/doc/percona-xtradb-cluster/5.5/wsrep-system-index.html#wsrep_replicate_myisam

On PXC 5.5.37,

[root@percona-pxc55-1 mysql]# mysql -uroot -p
Enter password:
Server version: 5.5.37-35.0-55-log Percona XtraDB Cluster (GPL), Release rel35.0, Revision 759, WSREP version 25.10, wsrep_25.10.r3985

mysql> show global variables like 'wsrep_replicate_myisam';
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| wsrep_replicate_myisam | OFF |
+------------------------+-------+
1 row in set (0.00 sec)

mysql> SET wsrep_replicate_myisam = ON;
ERROR 1229 (HY000): Variable 'wsrep_replicate_myisam' is a GLOBAL variable and should be set with SET GLOBAL
mysql>

On PXC 5.6.19,

root@deb-pxc56-1:~# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.6.19-67.0-56-log Percona XtraDB Cluster (GPL), Release 25.6, wsrep_25.6.r4111

mysql> show global variables like 'wsrep_replicate_myisam';
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| wsrep_replicate_myisam | OFF |
+------------------------+-------+
1 row in set (0.01 sec)

mysql> SET wsrep_replicate_myisam = ON;
ERROR 1229 (HY000): Variable 'wsrep_replicate_myisam' is a GLOBAL variable and should be set with SET GLOBAL
mysql>

[Alexey Kopytov (akopytov)]

Fixed in PXC 5.6 as https://github.com/percona/percona-xtradb-cluster/issues/2

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-1620