Upgrading MariaDB

Mike

Currently, if I create a MariaDB from the Opalstack console, it is version 10.3.31. Are there any plans to move to a newer version of MariaDB in the coming months? Or is upgrading something I can do from my side on a shared hosting server. I know that I could create my own MariaDB instance but I don't want to do that unless absolutely necessary.

Thanks,

Mike

sean

Mike we'll have newer MariaDB (and possibly MySQL) available when we start rolling out new servers with a newer operating system some time in 2023.

If you follow the private instance procedure here in the forum you'll be running the same version of MariaDB as the system version, as that procedure is not a completely separate installation but a separate instance of the existing software running with local config.

For now if you need a newer version you'll need to download a binary release or build it from source and then run that as a custom application.

leehinde

I'm working on updating my django app, which uses a private version of MariaDB. Version 4.2 of Django requires mariaDB 10.4 or higher. It feels like the minimal downtime way to do this is to create a new private instance with the version of mariaDB I need and migrate my data. Stop the old one (and update crontab) and start the new one. Does that make sense and/or is there an easier way?

nick

leehinde Yes, that's basically all you need to do, generally speaking. To minimize downtime, setup the new MariaDB instance first, do your export/import, then update Django to use the new DB. Then decommission the old DB instance if all goes well. Of course, always make backups.

leehinde

nick So many backups.

Is there somewhere that tells me which version of mariaDB ~~you'll~~ I'll be installing?

nick

leehinde You can check the existing version which should be suitable, from the command line:

$ mariadb --version
mariadb  Ver 15.1 Distrib 10.6.19-MariaDB, for Linux (x86_64) using readline 5.1

I'm not seeing any major updates pending at this time.