diff options
| author | Jan Lindström <jan.lindstrom@mariadb.com> | 2019-08-15 07:46:41 +0300 |
|---|---|---|
| committer | Jan Lindström <jan.lindstrom@mariadb.com> | 2019-08-16 07:01:30 +0300 |
| commit | fa74088838c12210d782aa6c69faa5acebc1d3bc (patch) | |
| tree | 3612cb9d241503fda6938a69aaea84d48db3da9f /mysql-test/r/selectivity_innodb.result | |
| parent | 1c75ad6eed744672fdce77b0752801b67edb69f8 (diff) | |
| download | mariadb-git-fa74088838c12210d782aa6c69faa5acebc1d3bc.tar.gz | |
MDEV-18778: mysql_tzinfo_to_sql does not work correctly in MariaDB Galera
There were two problems:
(1) If user wanted same time zone information on all nodes in the Galera
cluster all updates were not replicated as time zone information was
stored on MyISAM tables. This is fixed on Galera by altering time zone
tables to InnoDB while they are modified.
(2) If user wanted different time zone information to nodes in the Galera
cluster TRUNCATE TABLE for time zone tables was replicated by Galera
destroying time zone information from other nodes. This is fixed
on Galera by introducing new option for mysql_tzinfo_to_sql_symlink
tool --skip-write-binlog to disable Galera replication while
time zone tables are modified.
Changes to be committed:
modified: mysql-test/r/mysql_tzinfo_to_sql_symlink.result
modified: mysql-test/suite/wsrep/r/mysql_tzinfo_to_sql_symlink.result
new file: mysql-test/suite/wsrep/r/mysql_tzinfo_to_sql_symlink_skip.result
new file: mysql-test/suite/wsrep/t/mysql_tzinfo_to_sql_symlink_skip.test
modified: sql/tztime.cc
Diffstat (limited to 'mysql-test/r/selectivity_innodb.result')
0 files changed, 0 insertions, 0 deletions