Feature #35685

Support for MySQL > 5.7 or MariaDB

Added by Martin Jungowski about 1 year ago. Updated 4 months ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Database
Target version:-
Resolution:

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?

History

#1 Updated by Martin Jungowski 6 months ago

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?

#2 Updated by Thomas Löber 6 months ago

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.

#3 Updated by Martin Jungowski 6 months ago

Thank you, that is good news. How man active concurrent users do you have?

#4 Updated by Thomas Löber 6 months ago

I'm not sure, but I know that at certain times of the day we have about 200 to 300 ticket edits per hour.

#5 Updated by C S 4 months ago

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.

Also available in: Atom PDF