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
Last revisionBoth sides next revision
75:system_requirements_mysql [2020/12/10 15:00] – emr75:system_requirements_mysql [2024/02/15 00:00] – external edit 127.0.0.1
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