Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
75:system_requirements_mysql [2020/09/02 06:28] – [Required MySQL Permissions] ndn | 75:system_requirements_mysql [2024/02/15 00:00] – external edit 127.0.0.1 | ||
---|---|---|---|
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 " | + | The following settings are highly recommended: |
- | Increase the "innodb_lock_wait_timeout" | + | < |
+ | character-set-server=utf8 | ||
+ | max_allowed_packet=500M | ||
+ | innodb_lock_wait_timeout=600 | ||
+ | transaction-isolation=READ-COMMITTED | ||
+ | lower_case_table_names=1 | ||
+ | sql-mode = " | ||
+ | default-time-zone="+00:00" | ||
+ | |||
+ | </ | ||
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 14: | Line 23: | ||
The Windows 7 search feature causes the same kind of problems as a virus scanner. Please disable this feature on the Stages server. | The Windows 7 search feature causes the same kind of problems as a virus scanner. Please disable this feature on the Stages server. | ||
+ | |||
===== Azure MySQL DB ===== | ===== Azure MySQL DB ===== | ||
Line 28: | Line 38: | ||
in '' | in '' | ||
- | ===== Required MySQL Permissions | + | ===== 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 | The Stages user needs the following permissions for the database that is configured in database.properties | ||
- | * <font inherit/ | + | * ALTER, CREATE, DELETE, DROP, INDEX, INSERT, REFERENCES, SELECT, TRIGGER, UPDATE |
Additionally, | Additionally, | ||
- | * The SUPER privilege, globally: \\ <font inherit/ | + | * The SUPER privilege, globally: \\ GRANT SUPER ON *.* TO ' |
- | * <font inherit/ | + | * If this is not desirable, binary logging has to be disabled. Add the following line to the MySQL configuration file: \\ disable_log_bin |