• Jan Lindström's avatar
    MDEV-18778: mysql_tzinfo_to_sql does not work correctly in MariaDB Galera · e6b505fd
    Jan Lindström authored
    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
    
    This is 10.4 version of commit fa740888
    e6b505fd
mysql_tzinfo_to_sql_symlink.result 6 KB