summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMarius Balteanu <marius.balteanu@zitec.com>2023-11-26 13:20:27 +0000
committerMarius Balteanu <marius.balteanu@zitec.com>2023-11-26 13:20:27 +0000
commit9441710faebb04a8aafa7cf764a096178e96b3c4 (patch)
tree2e2bf5e68b133ca4485fe7dd0725058c7054384e
parent68fa4562231130eae0f3ebd13fd1c3dbae240655 (diff)
downloadredmine-9441710faebb04a8aafa7cf764a096178e96b3c4.tar.gz
redmine-9441710faebb04a8aafa7cf764a096178e96b3c4.zip
Update database versions and MySQL related documentation to include the workaround for concurrency issues (#39737, #39592).
git-svn-id: https://svn.redmine.org/redmine/trunk@22476 e93f8b46-1217-0410-a6f0-8f06a7374b81
-rw-r--r--doc/INSTALL24
1 files changed, 22 insertions, 2 deletions
diff --git a/doc/INSTALL b/doc/INSTALL
index 1487b8317..e8bc11d33 100644
--- a/doc/INSTALL
+++ b/doc/INSTALL
@@ -10,8 +10,8 @@ http://www.redmine.org/
* Ruby 2.7, 3.0, 3.1, 3.2
* A database:
- * MySQL (tested with MySQL 5.7)
- * PostgreSQL (tested with PostgreSQL 9.5)
+ * MySQL (tested with MySQL 8)
+ * PostgreSQL (tested with PostgreSQL 14)
* SQLite3 (tested with SQLite 3.11)
* SQLServer (tested with SQLServer 2012)
@@ -86,6 +86,26 @@ The current version of Firefox, Safari, Chrome, Chromium and Microsoft Edge.
Go to "Administration" to load the default configuration data (roles,
trackers, statuses, workflow) and to adjust the application settings
+== Database server configuration
+
+When using MySQL with Redmine 5.1.1 or later, it is necessary to change
+the transaction isolation level from the default REPEATABLE READ to
+READ_COMMITTED. To modify this setting, either change the database
+configuration file or alter the settings on your MySQL server.
+
+To set the transaction isolation level in the database configuration file,
+add transaction_isolation variable as below:
+
+ production:
+ adapter: mysql2
+ database: redmine
+ host: localhost
+ [...]
+ variables:
+ transaction_isolation: "READ-COMMITTED"
+
+More details can be found in https://www.redmine.org/projects/redmine/wiki/MySQL_configuration.
+
== SMTP server Configuration
Copy config/configuration.yml.example to config/configuration.yml and