search

lando / mariadb

The Official MariaDB Lando Plugin
https://docs.lando.dev/mariadb
GNU General Public License v3.0
0 stars 7 forks source link

Upgrade the default version of MariaDB to a maintained version #25

Open tormi opened 1 year ago

tormi commented 1 year ago

MariaDB v10.3 is currently the default version for Lando, but is no longer maintained according to https://mariadb.org/download/#release-schedule:

The current maintained versions are: 10.4, 10.5, 10.6, 10.11 (maintained for 5 years), 10.9, 10.10, 11.0, 11.1 (maintained for one year).

tormi commented 9 months ago

Also, sql_mode needs to be changed when switching from MariaDB 10.3 > 10.6. Otherwise it gives the following warning:

WARNING: Forcing protocol to TCP due to option specification. Please explicitly state intended protocol.

tormi commented 7 months ago

This is the current MariaDB EOL owerview:

Screenshot 2024-02-26 at 16 43 18
onacymiketta commented 5 months ago

Also, sql_mode needs to be changed when switching from MariaDB 10.3 > 10.6. Otherwise it gives the following warning:

WARNING: Forcing protocol to TCP due to option specification. Please explicitly state intended protocol.

Which sql_mode did you have to switch to?

reynoldsalec commented 3 months ago

Ok, I've confirmed that the upgrade pathway from 10.3 -> 10.6 has an issue introduce in 10.5 around log entries: https://bbs.archlinux.org/viewtopic.php?id=259364. That error has come up several times in Lando issues, so I know it's legit. People have gotten around it by destroying their DBs, but it would be nice to figure out a way to more smoothly handle this.

reynoldsalec commented 3 months ago

@pirog is suggesting that, due to the upgrade issues, probably our best solution for right now is to remove 10.3 from the legacy versions list so people don't get a warning, and keep the default until we have the Lando v4 API version.