Project

General

Profile

Feature #27035

Drop support for MySQL for both development and production environments

Added by Lukas Zapletal about 1 year ago. Updated 6 months ago.

Status:
Closed
Priority:
Normal
Category:
Database
Target version:
-
Difficulty:
medium
Triaged:
Yes
Bugzilla link:
Fixed in Releases:
Found in Releases:

Description

Owner: lzap

The plan:

  • announce on our blog that 1.25/2.0 will be the last release supporting MySQL
  • implement a warning UI bar that MySQL is ending soon
  • release 1.23 and 1.24 with tested documentation on how to migrate to MySQL
  • remove MySQL from the installer
  • remove MySQL packages
  • drop MySQL from CI
  • drop MySQL from docker image
  • remove MySQL bundler group

Subtasks

Feature #28257: Remove MySQL gem from coreClosedTomer Brisker
Refactor #28338: remove mysql deprecation notificationClosed

Related issues

Related to Foreman - Feature #27442: Issue notification for MySQL users about dropping supportClosed
Related to Foreman - Bug #27589: Rake task to reset SQL sequencesClosed
Related to Foreman - Refactor #27806: change docker-compose setup to use pg by defaultClosed
Related to Foreman - Refactor #28363: get rid of title_and_lookup_key_length validation in NestedAncestryCommonClosed
Related to Installer - Refactor #28558: Remove mysql Puppet module from installerClosed

Associated revisions

Revision 7b96a377 (diff)
Added by Tomer Brisker 8 months ago

Fixes #27035 - Remove MySQL support

As MySQL is no longer supported, this cleans up a lot of places that
were checking for it.

History

#1 Updated by Ohad Levy about 1 year ago

would it be possible to offer a container that helps migrating data? something simple as

docker run foreman_mysql_migrator SOURCE=mysql://user:pass@mysql/foreman DST=pg://user:pass/pg/foreman

#2 Updated by Lukas Zapletal about 1 year ago

Rails can do the migration, see the blogpost. Can you explain what is the benefit of container approach?

#3 Updated by Lukas Zapletal about 1 year ago

  • Related to Feature #27442: Issue notification for MySQL users about dropping support added

#4 Updated by Lukas Zapletal about 1 year ago

  • Description updated (diff)

#5 Updated by Lukas Zapletal 12 months ago

  • Related to Bug #27589: Rake task to reset SQL sequences added

#6 Updated by Ohad Levy 11 months ago

  • Related to Refactor #27806: change docker-compose setup to use pg by default added

#7 Updated by The Foreman Bot 8 months ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman/pull/7205 added

#8 Updated by Tomer Brisker 8 months ago

  • Related to Refactor #28363: get rid of title_and_lookup_key_length validation in NestedAncestryCommon added

#9 Updated by The Foreman Bot 8 months ago

  • Fixed in Releases 2.0.0 added

#10 Updated by Tomer Brisker 8 months ago

  • Status changed from Ready For Testing to Closed

#11 Updated by Anonymous 8 months ago

  • Related to Refactor #28558: Remove mysql Puppet module from installer added

Also available in: Atom PDF