During migration process of the projects from Debian 10 and Ubuntu 20.04 LTS, with the default database server MariaDB 10.3, to the latest Debian 12 and Ubuntu 22.04 LTS, with the default database servers MariaDB 10.11 and MariaDB 10.6 respectively, Olvy team has noticed a significant drop in performance of some specific database queries after migrating.
This is because of an improvement implemented since MariaDB 10.4.3 for Rowid Filtering Optimization, which may affect some queries that use subqueries or joins with non-unique indexes.
To solve this problem and taking into account that MariaDB doesn’t provide standard ways to install outdated MariaDB 10.3 version on Debian 11, Debian 12 and Ubuntu 22.04, Olvy has ported MariaDB 10.3.39 from Debian 10 “buster” to Debian 11 “bullseye”, Debian 12 “bookworm” and Ubuntu 22.04 “jammy” LTS. This way, you can install MariaDB 10.3 on your modern systems and enjoy the same performance as before.
However, please note that MariaDB 10.3 reached end of life in May 2023, and it’s no longer supported by software vendor. Therefore port of MariaDB 10.3 by Olvy for Debian 11, Debian 12 and Ubuntu 22.04 is a transitional option to allow developers to find a solution to optimize database queries to be compatible with the latest supported MariaDB versions. We recommend that you update your queries as soon as possible and switch to the latest MariaDB versions for better security and stability.
How to install MariaDB 10.3 on Debian 11, 12 and Ubuntu 22.04 LTS
In this article, we will show how in few steps to install MariaDB 10.3 on Debian 11, Debian 12 and Ubuntu 22.04 LTS from Olvy repository.
Step 1: Add Olvy repository to apt sources file
First, you need to add Olvy repository to your apt sources file. Depending on your system, you need to use one of the following lines.
Debian 11 “bullseye”
deb [trusted=yes] http://repo.olvycloud.com/mariadb/10.3/bullseye /
Debian 12 “bookworm”
deb [trusted=yes] http://repo.olvycloud.com/mariadb/10.3/bookworm /
Ubuntu 22.04 LTS “jammy jellyfish”
deb [trusted=yes] http://repo.olvycloud.com/mariadb/10.3/jammy /
Step 2: Update apt indexes
Next, you need to update your apt indexes by running the following command:
Step 3: Install MariaDB 10.3 server and client
Finally, you need to install MariaDB 10.3 server and client by running the following command:
apt install mariadb-server-10.3 mariadb-client-10.3
That’s it! You have successfully installed MariaDB 10.3 on your Debian 11, Debian 12 or Ubuntu 22.04 TLS system with Olvy.
We hope this article helps you solve your performance issues with your websites . If you have any questions or feedback, please feel free to contact us. We are always happy to hear from you.
Olvy is a private and independent Limited Liability Company based in Bratislava, Slovakia, in the heart of Europe. We combined our invaluable 20+ years experience to develop innovative and reliable, lightning-fast and affordable Managed Cloud Hosting services for Everyone. From a small blog to a growing Ecommerce – we provide the best.