Ports with a mysql5 variants and/or dependencies should switch to using mysql56 or possibly mariadb.

[pixilla (Bradley Giesbrecht)]

The following ports have variants and/or dependencies on mysql5:

==== Ports which require maintainer approval ====
 - apr-util (geeklair.net:dluke):
 - drupal5 (acm.org:c_dantonio):
 - drupal6 (acm.org:c_dantonio):
 - libdbi-drivers (umich.edu:mta):
 - libgda (landonf):
 - lighttpd (ryandesign):
 - lighttpd-devel (ryandesign):
 - mediatomb (gmail.com:yattenator):
 - mysql-connector-odbc (pixilla):
 - mysql5 (ryandesign,pixilla):
 - mysql55-lib_mysqludf_json (pixilla):
 - mysqlxx (genetikayos.com:kayos):
 - php (ryandesign):
 - php4 (ryandesign):
 - php52 (ryandesign):
 - proftpd (stariontech.com:jeff):
 - qore-mysql-module (davidnichols):
 - radlib (mbclark):
 - rb-mysql (freebsd.org:roberto):
 - restund (db.org:aeh):
 - vpopmail (yahoo.com:compconsultant):
 - wikkawiki (wikkawiki.org:brian):

==== Ports with openmaintainer ====
 - dovecot (jberry,openmaintainer):
 - dovecot2 (pixilla,openmaintainer):
 - dspam (pixilla,openmaintainer):
 - libgda4 (devans,openmaintainer):
 - libgda5 (jwa,devans,openmaintainer):
 - mnogosearch (gmail.com:dbraband,openmaintainer):
 - mysql55-connector-cpp (pixilla,openmaintainer):
 - neko (ryandesign,openmaintainer):
 - ocaml-mysql (mww,openmaintainer):
 - postfix (jmr,openmaintainer):
 - pure-ftpd (pixilla,openmaintainer):
 - qt3-mac (blair,openmaintainer):
 - qt4-mac-mysql55-plugin (michaelld,pixilla,openmaintainer):
 - redland (pixilla,openmaintainer):
 - soci (rmh.de:g.lorenz,openmaintainer):
 - zabbix2 (eborisch,openmaintainer):

==== Ports with nomaintainer ====
 - bugzilla (nomaintainer):
 - exim (nomaintainer):
 - flow-tools (nomaintainer):
 - freeradius (nomaintainer):
 - gdal (nomaintainer):
 - grass (nomaintainer):
 - hydra (nomaintainer):
 - nagios-plugins (nomaintainer):
 - p5-dbd-mysql (nomaintainer): See #44484. 
 - pennmush (nomaintainer):
 - php5-mysql (nomaintainer):
 - py-oursql (nomaintainer):
 - rb19-mysql (nomaintainer):
 - snort (nomaintainer):
 - sphinx (nomaintainer):
 - vtk-devel (nomaintainer):
 - zabbix (nomaintainer):

Ports where mysql5 has been removed:

databases/dbslayer
databases/libzdb-mysql55
devel/akonadi
kde/amarok-devel (port obsolete)
python/py-mysql

[danielluke (Daniel J. Luke)]

apr-util has other mysql variants - are we removing mysql5 variants now? Is there a standard way we're deprecating them?

[pixilla (Bradley Giesbrecht)]

Replying to dluke@…:

apr-util has other mysql variants - are we removing mysql5 variants now? Is there a standard way we're deprecating them?

One goal should be to have mysql5 replaced_by mysql51 so for ports that cannot use a more modern mysql they would have their dependencies changed from mysql5 to mysql51.

That said, mysql51 is the same version (5.1.72) as mysql5 and pretty ancient. I believe we should settle on a MacPorts "default" mysql port and encourage subports and/or variants when other mysql versions are desired. I appears to me that many distros are choosing mariadb as their default. If we choose mariadb as our default perhaps we should rename mariadb to mariadb55 before we modify all these mysql5 dependent ports. I would am fine with and might prefer mariadb (the founder of mysql is behind mariadb) as the "default" MacPorts mysql port.

A standard way for variants might be:

# Removing mysql5 variant
# variant mysql5 {}
variant mysql51 {...}
variant mysql55 {...}
variant mysql56 {...}
variant mariadb55 {...}
variant percona56 {...}
if {[variant_isset mysql5]} {

    default_variants.append    mariadb55
}

[ryandesign (Ryan Carsten Schmidt)]

Replying to dluke@…:

apr-util has other mysql variants - are we removing mysql5 variants now? Is there a standard way we're deprecating them?

• mysql56 variants should be added where missing.
• mariadb and percona ports and variants should be renamed to be versioned.
• mysql5 variants should be auto-upgraded to mysql51 variants ("variant mysql5 requires mysql51 description {Legacy compatibility variant} {}"), this way users using mysql5 databases only need to move their database to a different directory to be able to continue using mysql51 (or, if just checking if the variant is set, without defining the variant, correctly upgrades users in that manner, then that's fine)
• mysql56 (or mariadb (or mariadb55 if we rename it)) should be the default variant (which would apply for new installations, not upgrades)
  • Alternately we could auto-upgrade mysql5 to mysql56 or mariadb (or mariadb55 if we rename it), but then the user might have to do additional steps other than just moving the files (e.g. running upgrade scripts). The whole reason why we have versioned MySQL (and PostgreSQL and BerkeleyDB) ports is so that users can decide when to upgrade to newer versions that require such extra steps.

[ryandesign (Ryan Carsten Schmidt)]

Replying to pixilla@…:

I appears to me that many distros are choosing mariadb as their default.

MariaDB (whatever the variant for the latest version thereof is called) would be my first choice for default.

[dbraband@…]

Cc Me!

[dbraband@…]

Cc Me!

[dbraband@…]

Cc Me!

[NicosPavlov]

akonadi done in r119433.

[ctreleaven (Craig Treleaven)]

Cc Me!

[cooljeanius (Eric Gallager)]

Cc Me!

[mkae (Marko Käning)]

Cc Me!

[patrick.sizun@…]

Cc Me!

[petrrr]

Cc Me!

[mojca (Mojca Miklavec)]

Cc Me!

[petrrr]

Vincent, I add you here to CC as maintainer of gdal.

[NicosPavlov]

Moving amarok-devel which is obsolete (amarok has default variant on mariadb55).