Problem:
This returns null after cluster creation: SELECT CONVERT_TZ(NOW(), '+00:00', 'UTC');
So usually I would fix it by running this: mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql but there is no way to do this in the vitess operator. I think it would have to run after mysql_install_db and before init_db.sql
Goal:
I would like to be able to put default-time-zone='UTC' into my [mysqld] configOverrides, not just default_time_zone = '+00:00'
Problem:
This returns null after cluster creation:
SELECT CONVERT_TZ(NOW(), '+00:00', 'UTC');So usually I would fix it by running this:
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysqlbut there is no way to do this in the vitess operator. I think it would have to run after mysql_install_db and before init_db.sqlGoal:
I would like to be able to put
default-time-zone='UTC'into my [mysqld] configOverrides, not justdefault_time_zone = '+00:00'