[root@percona-pxc55-1 ~]# mysql -uroot -p -e "show variables like 'version%'"
Enter password:
+-------------------------+-----------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+-------------------------+-----------------------------------------------------------------------------------------------------+
| version | 5.5.37-35.0-55-log |
| version_comment | Percona XtraDB Cluster (GPL), Release rel35.0, Revision 756, WSREP version 25.10, wsrep_25.10.r3985 |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+-----------------------------------------------------------------------------------------------------+
[root@percona-pxc55-1 ~]# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -uroot -p mysql
Enter password:
ERROR 1229 (HY000) at line 1: Variable 'wsrep_replicate_myisam' is a GLOBAL variable and should be set with SET GLOBAL
[root@percona-pxc55-1 ~]#
But resolved in latest PXC 5.6.19
nilnandan@debian:~$ mysql -uroot -p -e "show variables like 'version%'"
Enter password:
+-------------------------+--------------------------------------------------------------+
| Variable_name | Value |
+-------------------------+--------------------------------------------------------------+
| version | 5.6.19-67.0-56-log |
| version_comment | Percona XtraDB Cluster (GPL), Release 25.6, wsrep_25.6.r4111 |
| version_compile_machine | x86_64 |
| version_compile_os | debian-linux-gnu |
+-------------------------+--------------------------------------------------------------+
nilnandan@debian:~$
nilnandan@debian:~$ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -uroot -p mysql
Enter password:
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
nilnandan@debian:~$
It's still there in PXC 5.5.37
[root@percona- pxc55-1 ~]# mysql -uroot -p -e "show variables like 'version%'" ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- --+ ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- --+ compile_ machine | x86_64 | ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- --+ pxc55-1 ~]# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -uroot -p mysql replicate_ myisam' is a GLOBAL variable and should be set with SET GLOBAL pxc55-1 ~]#
Enter password:
+------
| Variable_name | Value |
+------
| version | 5.5.37-35.0-55-log |
| version_comment | Percona XtraDB Cluster (GPL), Release rel35.0, Revision 756, WSREP version 25.10, wsrep_25.10.r3985 |
| version_
| version_compile_os | Linux |
+------
[root@percona-
Enter password:
ERROR 1229 (HY000) at line 1: Variable 'wsrep_
[root@percona-
But resolved in latest PXC 5.6.19
nilnandan@debian:~$ mysql -uroot -p -e "show variables like 'version%'" ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ------- -----+ ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ------- -----+ compile_ machine | x86_64 | ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ------- -----+ zoneinfo/ iso3166. tab' as time zone. Skipping it. zoneinfo/ zone.tab' as time zone. Skipping it.
Enter password:
+------
| Variable_name | Value |
+------
| version | 5.6.19-67.0-56-log |
| version_comment | Percona XtraDB Cluster (GPL), Release 25.6, wsrep_25.6.r4111 |
| version_
| version_compile_os | debian-linux-gnu |
+------
nilnandan@debian:~$
nilnandan@debian:~$ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -uroot -p mysql
Enter password:
Warning: Unable to load '/usr/share/
Warning: Unable to load '/usr/share/
nilnandan@debian:~$