Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
75:system_requirements_mysql [2020/06/26 15:50] Erich Meier |
75:system_requirements_mysql [2020/12/10 16:21] (current) Erich Meier |
||
---|---|---|---|
Line 5: | Line 5: | ||
Stages supports MySQL 5.7 and 8.0 Community Editions. | Stages supports MySQL 5.7 and 8.0 Community Editions. | ||
- | The transaction isolation must be set to "READ-COMMITTED" in my.cnf. | + | The following settings are highly recommended: |
- | Increase the "innodb_lock_wait_timeout" system variable to something larger than 50 seconds (which is the default value) when you encounter "Lock wait timeout exceeded" errors. | + | <code> |
+ | character-set-server=utf8 | ||
+ | max_allowed_packet=500M | ||
+ | innodb_lock_timeout=600 | ||
+ | transaction-isolation=READ-COMMITTED | ||
+ | lower_case_table_names=1 | ||
+ | sql-mode = "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION" | ||
+ | default-time-zone="+00:00" | ||
+ | |||
+ | </code> | ||
Stages uses the INNODB engine. This can have impact on the server backup strategy, because INNODB files tend to become very large. | Stages uses the INNODB engine. This can have impact on the server backup strategy, because INNODB files tend to become very large. | ||
Line 28: | Line 37: | ||
in ''database.properties''. | in ''database.properties''. | ||
+ | ===== AWS RDS for MySQL ===== | ||
+ | |||
+ | All of the native MySQL and Azure MySQL DB requirements from above also apply to AWS RDS. | ||
+ | |||
+ | ===== Required MySQL permissions ===== | ||
+ | |||
+ | The Stages user needs the following permissions for the database that is configured in database.properties | ||
+ | |||
+ | * <font inherit/Courier New,Courier,monospace;;inherit;;inherit>ALTER, CREATE, DELETE, DROP, INDEX, INSERT, REFERENCES, SELECT, TRIGGER, UPDATE</font> | ||
+ | |||
+ | Additionally, one of the following is required: | ||
+ | |||
+ | * The SUPER privilege, globally: \\ <font inherit/Courier New,Courier,monospace;;inherit;;inherit>GRANT SUPER ON *.* TO 'stages'@'localhost';</font> | ||
+ | * <font inherit/Arial,Helvetica,sans-serif;;inherit;;inherit>If this is not desirable, binary logging has to be disabled. Add the following line to the MySQL configuration file:</font> \\ <font inherit/Courier New,Courier,monospace;;inherit;;inherit>disable_log_bin</font> | ||