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
Next revisionBoth sides next revision
75:system_requirements_mysql [2020/09/02 06:26] – ndn75:system_requirements_mysql [2020/12/10 15:00] – 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_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 36:
  
 in ''database.properties''. in ''database.properties''.
-===== Required MySQL Permissions =====+===== AWS RDS for MySQL ===== 
 + 
 +All of the native MySQL requirements from above also apply. 
 + 
 +===== Required MySQL permissions =====
  
 The Stages user needs the following permissions for the database that is configured in database.properties The Stages user needs the following permissions for the database that is configured in database.properties
Line 34: Line 46:
   * <font inherit/Courier New,Courier,monospace;;inherit;;inherit>ALTER, CREATE, DELETE, DROP, INDEX, INSERT, REFERENCES, SELECT, TRIGGER, UPDATE</font>   * <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+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>+  * 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>   * <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>