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/12/10 15:00] – emr75:system_requirements_mysql [2024/02/16 18:23] (current) – [Required MySQL permissions] emr
Line 7: Line 7:
 The following settings are highly recommended: The following settings are highly recommended:
  
-<code>character-set-server=utf8+<code> 
 +character-set-server=utf8
 max_allowed_packet=500M max_allowed_packet=500M
-innodb_lock_timeout=600+innodb_lock_wait_timeout=600
 transaction-isolation=READ-COMMITTED transaction-isolation=READ-COMMITTED
 lower_case_table_names=1 lower_case_table_names=1
Line 22: 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 38: Line 40:
 ===== AWS RDS for MySQL ===== ===== AWS RDS for MySQL =====
  
-All of the native MySQL requirements from above also apply.+All of the native MySQL and Azure MySQL DB requirements from above also apply to AWS RDS.
  
 ===== Required MySQL permissions ===== ===== Required MySQL permissions =====
Line 44: Line 46:
 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
  
-  * <font inherit/Courier New,Courier,monospace;;inherit;;inherit>ALTER, CREATE, DELETE, DROP, INDEX, INSERT, REFERENCES, SELECT, TRIGGER, UPDATE</font>+  * ALTER, CREATE, DELETE, DROP, INDEX, INSERT, REFERENCES, SELECT, TRIGGER, UPDATE
  
 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: \\ ''GRANT SUPER ON *.* TO 'stages'@'localhost';'' 
-  * <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>+  * If this is not desirable, binary logging has to be disabled. Add the following line to the MySQL configuration file: \\ ''disable_log_bin=1''