wsrep_replicate_myisam needs to be a session variable
Bug #1280280 reported by
Raghavendra D Prabhu
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL patches by Codership |
New
|
Undecided
|
Unassigned | |||
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC | Status tracked in 5.6 | |||||
5.5 |
Won't Fix
|
Undecided
|
Unassigned | |||
5.6 |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
Currently it is a global variable, which can break things like
https:/
To post a comment you must log in.
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 www.percona. com/doc/ percona- xtradb- cluster/ 5.5/wsrep- system- index.html# wsrep_replicate _myisam
http://
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' ; ------- ------- ----+-- -----+ ------- ------- ----+-- -----+ _myisam | OFF | ------- ------- ----+-- -----+
+------
| Variable_name | Value |
+------
| wsrep_replicate
+------
1 row in set (0.00 sec)
mysql> SET wsrep_replicate _myisam = ON; replicate_ myisam' is a GLOBAL variable and should be set with SET GLOBAL
ERROR 1229 (HY000): Variable 'wsrep_
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' ; ------- ------- ----+-- -----+ ------- ------- ----+-- -----+ _myisam | OFF | ------- ------- ----+-- -----+
+------
| Variable_name | Value |
+------
| wsrep_replicate
+------
1 row in set (0.01 sec)
mysql> SET wsrep_replicate _myisam = ON; replicate_ myisam' is a GLOBAL variable and should be set with SET GLOBAL
ERROR 1229 (HY000): Variable 'wsrep_
mysql>