Stages Documentation

Differences

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

Link to this comparison view

Next revision		Previous revision
Next revisionBoth sides next revision
75:system_requirements_mysql [2020/04/16 19:13] – created emr75:system_requirements_mysql [2020/06/23 08:25] – [Azure MySQL DB] etea
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.
  
 The transaction isolation must be set to "READ-COMMITTED" in my.cnf. The transaction isolation must be set to "READ-COMMITTED" in my.cnf.
 +
 +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.
  
 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 10: 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 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]].