Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
75:system_requirements_mysql [2020/06/09 11:33] ndn75:system_requirements_mysql [2020/06/26 15:50] emr
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 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''og_bin_trust_function_creators'' parameter of Azure MySQL DB must be set to 1. See [[https://stackoverflow.com/questions/11601692/mysql-amazon-rds-error-you-do-not-have-super-privileges|here for more info]].
 +
 +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<code>
 +
 +torque.database.default.expiryTime=100000
 +
 +</code>
 +
 +in ''database.properties''.