https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292022-04-11T12:15:05ZRedmineRedmine - Feature #35685: Support for MySQL > 5.7 or MariaDBhttps://www.redmine.org/issues/35685?journal_id=1063612022-04-11T12:15:05ZMartin Jungowski
<ul></ul><p>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?</p> Redmine - Feature #35685: Support for MySQL > 5.7 or MariaDBhttps://www.redmine.org/issues/35685?journal_id=1063682022-04-12T17:16:49ZThomas Löber
<ul></ul><p>We have been running Redmine on MySQL 8.0 for more than 1.5 years without any problems. The deadlock problem described in <a class="issue tracker-2 status-5 priority-4 priority-default closed" title="Feature: MySQL 5.7 support (Closed)" href="https://www.redmine.org/issues/17460">#17460</a> has never occurred.</p> Redmine - Feature #35685: Support for MySQL > 5.7 or MariaDBhttps://www.redmine.org/issues/35685?journal_id=1063712022-04-12T19:20:10ZMartin Jungowski
<ul></ul><p>Thank you, that is good news. How man active concurrent users do you have?</p> Redmine - Feature #35685: Support for MySQL > 5.7 or MariaDBhttps://www.redmine.org/issues/35685?journal_id=1063752022-04-13T07:09:42ZThomas Löber
<ul></ul><p>I'm not sure, but I know that at certain times of the day we have about 200 to 300 ticket edits per hour.</p> Redmine - Feature #35685: Support for MySQL > 5.7 or MariaDBhttps://www.redmine.org/issues/35685?journal_id=1069162022-06-10T10:46:38ZC S
<ul></ul><p>I wonder why no progress can be seen on this important point in particular - especially in connection with the fifth generation of Redmine.<br />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.<br />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 ;)<br />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.</p> Redmine - Feature #35685: Support for MySQL > 5.7 or MariaDBhttps://www.redmine.org/issues/35685?journal_id=1104212023-07-16T17:00:35ZMarkus Falb
<ul></ul><p>My investigations show</p>
<p>According to <a class="external" href="https://www.redmine.org/projects/redmine/wiki/Continuous_integration">https://www.redmine.org/projects/redmine/wiki/Continuous_integration</a><br />the tests are running on mysql 5.7</p>
<p>Here are the results of the testsuite<br /><a class="external" href="https://www.redmine.org/builds/">https://www.redmine.org/builds/</a></p>
<p>This is confusing. Are the tests successful or are the tests skipped? Is mysql 5.7 supported or not. I find it especially confusing that the test suite is run with 5.7.</p> Redmine - Feature #35685: Support for MySQL > 5.7 or MariaDBhttps://www.redmine.org/issues/35685?journal_id=1105562023-08-15T08:32:57ZGo MAEDA
<ul></ul><p>I also use MySQL 8.0 in my test environment for a long time.</p>
<p>I believe that MySQL 8.0 should be added to the supported databases, with the notice that the issue described in <a class="issue tracker-2 status-5 priority-4 priority-default closed" title="Feature: MySQL 5.7 support (Closed)" href="https://www.redmine.org/issues/17460">#17460</a> may occur.</p> Redmine - Feature #35685: Support for MySQL > 5.7 or MariaDBhttps://www.redmine.org/issues/35685?journal_id=1114312023-11-08T04:39:40ZMischa The Evil
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-5 priority-4 priority-default closed" href="/issues/39437">Defect #39437</a>: MySQL / MariaDB issue nested set deadlocks and consistency</i> added</li></ul> Redmine - Feature #35685: Support for MySQL > 5.7 or MariaDBhttps://www.redmine.org/issues/35685?journal_id=1115632023-11-20T22:55:30ZMarius BĂLTEANU
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Closed</i></li><li><strong>Assignee</strong> set to <i>Marius BĂLTEANU</i></li><li><strong>Resolution</strong> set to <i>Duplicate</i></li></ul><p>This concurrency issue is fixed in the upcoming Redmine <a class="version" href="https://www.redmine.org/versions/191">5.1.1</a> (it will be released soon) and <a class="version" href="https://www.redmine.org/versions/175">6.0.0</a>, but it may require some changes to the database settings, please see all the comments from <a class="issue tracker-1 status-5 priority-4 priority-default closed" title="Defect: MySQL / MariaDB issue nested set deadlocks and consistency (Closed)" href="https://www.redmine.org/issues/39437">#39437</a> and the <a class="wiki-page" href="https://www.redmine.org/projects/redmine/wiki/MySQL_configuration">MySQL_configuration</a> page.</p>
Multiple discussions regarding this topic are planed for the upcoming releases:
<ul>
<li><a class="issue tracker-2 status-5 priority-4 priority-default closed" title="Status: Closed" href="https://www.redmine.org/issues/35014">Feature #35014: Review and update supported database engines and versions </a></li>
<li><a class="issue tracker-2 status-5 priority-4 priority-default closed" title="Status: Closed" href="https://www.redmine.org/issues/39579">Feature #39579: Drop official support for MySQL 5.5, 5.6 and 5.7</a></li>
</ul>
<p>Also, starting from today, MySQL 8 is used in the <a href="https://www.redmine.org/projects/redmine/wiki/Continuous_integration/15" class="external">official CI</a>. Regarding MariaDB, it should work, but we don't have it in the official CI matrix (<a class="issue tracker-2 status-1 priority-5 priority-high2" title="Feature: Support MariaDB (New)" href="https://www.redmine.org/issues/19395">#19395</a>).</p>
<p>I'm closing this as duplicate.</p> Redmine - Feature #35685: Support for MySQL > 5.7 or MariaDBhttps://www.redmine.org/issues/35685?journal_id=1115662023-11-20T22:59:38ZMarius BĂLTEANU
<ul><li><strong>Related to</strong> <i><a class="issue tracker-2 status-1 priority-5 priority-high2" href="/issues/19395">Feature #19395</a>: Support MariaDB</i> added</li></ul>