Upgrade the default version of MariaDB to a maintained version

[tormi]

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]

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]

This is the current MariaDB EOL owerview:

[onacymiketta]

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]

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]

@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.