Differences

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

--- 75:system_requirements_mysql [2020/06/26 15:50] – emr
+++ 75:system_requirements_mysql [2020/12/10 15:00] – emr
@@ Line 5: / Line 5: @@
 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.
@@ Line 28: / Line 36: @@
 in ''database.properties''.
+===== 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
+  * <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>