Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
75:system_requirements_mysql [2020/06/09 11:15] – ndn | 75:system_requirements_mysql [2020/09/02 07:01] – [Required MySQL Permissions] ndn | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== MySQL Requirements ====== | ====== MySQL Requirements ====== | ||
+ | |||
+ | ===== Native MySQL installation ===== | ||
Stages supports MySQL 5.7 and 8.0 Community Editions. | Stages supports MySQL 5.7 and 8.0 Community Editions. | ||
Line 5: | Line 7: | ||
The transaction isolation must be set to " | The transaction isolation must be set to " | ||
- | Increase the " | + | Increase the " |
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 12: | Line 14: | ||
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 ===== | ||
+ | |||
+ | For installing Stages with the Azure MySQL DB, all of the above applies as well. | ||
+ | |||
+ | In addition, the l'' | ||
+ | |||
+ | The connection timeout for Azure MySQL DB might be set very low. If you see connection errors after a while, you should set the connection timeout for Stages to 100 seconds via< | ||
+ | |||
+ | torque.database.default.expiryTime=100000 | ||
+ | |||
+ | </ | ||
+ | |||
+ | in '' | ||
+ | ===== Required MySQL permissions ===== | ||
+ | |||
+ | The Stages user needs the following permissions for the database that is configured in database.properties | ||
+ | |||
+ | * <font inherit/ | ||
+ | |||
+ | Additionally, | ||
+ | |||
+ | * The SUPER privilege, globally: \\ <font inherit/ | ||
+ | * <font inherit/ | ||