Feature #35685
closed
Support for MySQL > 5.7 or MariaDB
Added by Martin Jungowski about 3 years ago.
Updated 12 months ago.
Description
Given that I cannot see anything on the roadmap I'd like to ask what the state of MySQL support is. As stated on the Install page the latest officially supported release is MySQL 5.6, which has been EOL since February of 2021. MySQL 5.7 seems to work just fine but is not yet officially supported (it's on the roadmap for the next major release after 5.0!) and has an EOL date of October 2023 (aka slightly over 2 years from today). At the current speed of development I fear that MySQL will be EOL long before it is officially supported by Redmine. MariaDB is not supported at all.
Any insight?
Any news? This is getting more troublesome each day as we are now 18 months away from MySQL's 5.7 official EOL date, more than a year after MySQL 5.6 has been officially depreciated, and still there's nothing on the roadmap. Maybe it'd be better to officially depreciate MySQL support and provide a migration path to PostgreSQL?
We have been running Redmine on MySQL 8.0 for more than 1.5 years without any problems. The deadlock problem described in #17460 has never occurred.
Thank you, that is good news. How man active concurrent users do you have?
I'm not sure, but I know that at certain times of the day we have about 200 to 300 ticket edits per hour.
I wonder why no progress can be seen on this important point in particular - especially in connection with the fifth generation of Redmine.
MySQL 5.5 and 5.6 have been EOL for a long time, the end of 5.7 is in the near future (October 2023). Nevertheless, version 5.5 is presented as the best choice in the installation wiki - version 8.0 is not even mentioned.
Ok, MySQL is not what it used to be - so I can understand if there is no further development here - we also have an alternative ;)
However, the "official" support of MariaDB is missing - I only know from experience that I have never had any problems in connection with MariaDB 10.x.
I also use MySQL 8.0 in my test environment for a long time.
I believe that MySQL 8.0 should be added to the supported databases, with the notice that the issue described in #17460 may occur.
- Related to Defect #39437: MySQL / MariaDB issue nested set deadlocks and consistency added
- Status changed from New to Closed
- Assignee set to Marius BĂLTEANU
- Resolution set to Duplicate
This concurrency issue is fixed in the upcoming Redmine 5.1.1 (it will be released soon) and 6.0.0, but it may require some changes to the database settings, please see all the comments from #39437 and the MySQL_configuration page.
Multiple discussions regarding this topic are planed for the upcoming releases:
Also, starting from today, MySQL 8 is used in the official CI. Regarding MariaDB, it should work, but we don't have it in the official CI matrix (#19395).
I'm closing this as duplicate.
Also available in: Atom
PDF