Stages Documentation

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
75:system_requirements_mysql [2020/06/23 08:25] – [Azure MySQL DB] etea75:system_requirements_mysql [2024/02/16 18:23] (current) – [Required MySQL permissions] emr
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_wait_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 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 19: Line 29:
 For installing Stages with the Azure MySQL DB, all of the above applies as well. 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]].+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''. 
 +===== 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 
 + 
 +  * ALTER, CREATE, DELETE, DROP, INDEX, INSERT, REFERENCES, SELECT, TRIGGER, UPDATE 
 + 
 +Additionally, one of the following is required: 
 + 
 +  * The SUPER privilege, globally: \\ ''GRANT SUPER ON *.* TO 'stages'@'localhost';'' 
 +  * If this is not desirable, binary logging has to be disabled. Add the following line to the MySQL configuration file: \\ ''disable_log_bin=1''