Skip to content

Changes

Page history
Convert to bulet-tree to table authored by totten's avatar totten
Hide whitespace changes
Inline Side-by-side
Event-Time-Zone-Implementation-Planning.md
View page @ 0377c0a1
......@@ -131,22 +131,28 @@ CiviCRM is an application/framework/platform that integrates with several other
## Appendix: MySQL survey
There is a substantive question about the quantity/quality of MySQL environments which do/can/cannot enable timezone support. Some references:
* __Environments which enable timezones by default__
* Digital Ocean (Managed MySQL) (`r-run`: yes)
* Docker (https://hub.docker.com/_/mysql) (`r-run`: yes)
* Google Cloud (Cloud SQL for MySQL) (`r-run`: yes; but ["not guaranteed to provide up-to-date time settings"](https://cloud.google.com/sql/docs/mysql/known-issues))
* (_Probably_) Amazon RDS-MySQL (There are old-google-cached forum posts which imply gradual evolution toward support. The current ["Local time zone" page](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_MySQL.html#MySQL.Concepts.LocalTimeZone) seems to affirm, but it doesn't specifically mention session-scoped timezones.)
* CiviHosting
* __Environments which have the ability to load timezones - but don't by default__
* Azure MySQL (https://docs.microsoft.com/en-us/azure/mysql/howto-server-parameters#working-with-the-time-zone-parameter)
* CentOS MySQL Packages (`mysql_tzinfo_to_sql`) (`r-run`: yes)
* cPanel hosts with root access
* Debian/Ubuntu MySQL Packages (`mysql_tzinfo_to_sql`) (`r-run`: yes)
* Nix MySQL Packages (`mysql_tzinfo_to_sql`) (`r-run`: yes)
* __Environments which cannot load timezones__
* (_Probably_) cPanel hosts without root access
There is a substantive question about the quantity/quality of MySQL environments which:
* Already support MySQL timezones (:white_check_mark:)
* Can support MySQL timezones, with extra setup (:tools:)
* Cannot support MySQL timezones (:octagonal_sign:)
* Status is not certain (:question:)
Sorted by `Status,Environment`:
| Status | Environment | Comment |
| -- | -- | -- |
| :white_check_mark: | CiviHosting | |
| :white_check_mark: | Digital Ocean | Specifically tested w/[managed MySQL 8.0](https://www.digitalocean.com/products/managed-databases-mysql) |
| :white_check_mark: | Docker `mysql` | Specifically tested w/[8.0, 8.0-oracle, and 5.7](https://hub.docker.com/_/mysql) |
| :white_check_mark: | Google Cloud SQL | Specifically tested w/5.6. Warning from docs: ["not guaranteed to provide up-to-date time settings"](https://cloud.google.com/sql/docs/mysql/known-issues) |
| :white_check_mark: :question: | Amazon RDS | Not tested. There are old-google-cached forum posts which imply gradual evolution toward support. The current ["Local time zone" page](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_MySQL.html#MySQL.Concepts.LocalTimeZone) seems to affirm, but it doesn't specifically mention session-scoped timezones. |
| :tools: | Azure Database | Use [`az_load_timezone()`](https://docs.microsoft.com/en-us/azure/mysql/howto-server-parameters#working-with-the-time-zone-parameter) |
| :tools: | CentOS MariaDB/MySQL | Use `mysql_tzinfo_to_sql` |
| :tools: | cPanel (with root access) | Use `mysql_tzinfo_to_sql` |
| :tools: | Debian/Ubuntu MariaDB/MySQL | Use `mysql_tzinfo_to_sql` |
| :tools: | Nix MariaDB/MySQL | Use `mysql_tzinfo_to_sql` |
| :octagonal_sign: :question: | cPanel (without root access) | Not tested. If you have MySQL admin rights, you might use `mysql_tzinfo_sql` locally and send to server. Still requires MySQL admin. |
## Related Tasks
......