Project

General

Profile

Actions

Feature #27035

closed

Drop support for MySQL for both development and production environments

Added by Lukas Zapletal over 5 years ago. Updated about 3 years ago.

Status:
Closed
Priority:
Normal
Category:
Database
Target version:
-
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 2 (0 open2 closed)

Feature #28257: Remove MySQL gem from coreClosedTomer BriskerActions
Refactor #28338: remove mysql deprecation notificationClosedActions

Related issues 5 (0 open5 closed)

Related to Foreman - Feature #27442: Issue notification for MySQL users about dropping supportClosedLukas ZapletalActions
Related to Foreman - Bug #27589: Rake task to reset SQL sequencesClosedLukas ZapletalActions
Related to Foreman - Refactor #27806: change docker-compose setup to use pg by defaultClosedOhad LevyActions
Related to Foreman - Refactor #28363: get rid of title_and_lookup_key_length validation in NestedAncestryCommonClosedShira MaximovActions
Related to Installer - Refactor #28558: Remove mysql Puppet module from installerClosedActions
Actions #1

Updated by Ohad Levy over 5 years 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
Actions #2

Updated by Lukas Zapletal over 5 years ago

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

Actions #3

Updated by Lukas Zapletal over 5 years ago

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

Updated by Lukas Zapletal over 5 years ago

  • Description updated (diff)
Actions #5

Updated by Lukas Zapletal about 5 years ago

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

Updated by Ohad Levy about 5 years ago

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

Updated by The Foreman Bot almost 5 years ago

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

Updated by Tomer Brisker almost 5 years ago

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

Updated by The Foreman Bot almost 5 years ago

  • Fixed in Releases 2.0.0 added
Actions #10

Updated by Tomer Brisker almost 5 years ago

  • Status changed from Ready For Testing to Closed
Actions #11

Updated by Anonymous almost 5 years ago

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

Updated by The Foreman Bot about 3 years ago

  • Pull request https://github.com/theforeman/foreman/pull/8888 added
Actions

Also available in: Atom PDF