Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
75:system_requirements_mysql [2020/06/26 15:50]
Erich Meier
75:system_requirements_mysql [2020/12/10 16:21] (current)
Erich Meier
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_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 28: Line 37:
  
 in ''​database.properties''​. 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
 +
 +  * <font inherit/​Courier New,​Courier,​monospace;;​inherit;;​inherit>​ALTER,​ CREATE, DELETE, DROP, INDEX, INSERT, REFERENCES, SELECT, TRIGGER, UPDATE</​font>​
 +
 +Additionally,​ one of the following is required:
 +
 +  * The SUPER privilege, globally: \\ <font inherit/​Courier New,​Courier,​monospace;;​inherit;;​inherit>​GRANT SUPER ON *.* TO '​stages'​@'​localhost';</​font>​
 +  * <font inherit/​Arial,​Helvetica,​sans-serif;;​inherit;;​inherit>​If this is not desirable, binary logging has to be disabled. Add the following line to the MySQL configuration file:</​font>​ \\ <font inherit/​Courier New,​Courier,​monospace;;​inherit;;​inherit>​disable_log_bin</​font>​