How Intel helps MariaDB become even faster

There are many forums in the past couple of years where I have talked about how non-code contributions are just as important to MariaDB Server and us at the MariaDB Foundation as the code contributions I typically help with. I’ve also highlighted in the past how Intel have provided some fantastic non-code contributions. They assist us by detecting performance issues on their new and future platforms, as well guidance in finding the root cause of these issues.

The outcome: Over a million NOPM in HammerDB

Today I want to discuss some of the performance improvements that Intel has helped with, which have led to MariaDB Server achieving 1 million NOPM (new orders per minute) in the HammerDB TPROC-C test.

SkySQL is our new Silver sponsor!

We’re excited to announce that SkySQL has joined the MariaDB Foundation as a Silver sponsor.

SkySQL is the first and only database service designed, built and optimised specifically for MariaDB Server. Recently spun out of MariaDB plc as an independent company, SkySQL remains led by the core team which created it and continues to provide the community with unique and powerful capabilities for running production databases in the cloud. With features such as autonomous scaling, subsecond failover and multi-cloud deployment, SkySQL provides a world-class cloud experience for the MariaDB community — and supports our mission of making MariaDB Server the preferred database of choice for all organisations.

MariaDB Dump File Compatibility Change

Both MariaDB and MySQL have been around a long time now, and there is always a difficult balance between maintaining compatibility whilst also solving security issues that arise. With the latest bugfix releases of MariaDB, we had to break compatibility a little to improve security, but there are workarounds. We figured we should explain the reasons behind it and how to make things as painless as possible for you.

The Problem

The problem we were solving, and for various reasons we had to do it very quickly, is that it is possible to generate a malicious MariaDB dump file which could execute shell commands from the MariaDB client.

MariaDB Vector at Intel Vision – AI Everywhere

AI was everywhere at Intel Vision this week in London. Nearly every keynote and breakout presentation was centred around AI. I had the honour of being interviewed by Intel’s jovial Chief Commercial Officer Christoph Schell, who is just about as stereotypically German as his former neighbour from Stuttgart Jürgen Klopp (whom he referenced on-stage), namely: not at all.

Staying German but perhaps a tad less Klopp-like, Thomas Bach was one of many interviewed on-stage by Christoph. The president of the International Olympic Committee nevertheless impressed me by his quick-witted reply to Christoph’s question as to how AI would have made an impact if it had been in place during Thomas Bach’s fencing career.

MariaDB 11.2.4, 11.1.5, 11.0.6, 10.11.8, 10.6.18, 10.5.25, 10.4.34 now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.11.8, MariaDB 10.6.18, MariaDB 10.5.25 and MariaDB 10.4.34, the latest stable releases in their respective long-term series (maintained for five years from their first stable release dates), as well as MariaDB 11.2.4, MariaDB 11.1.5 and MariaDB 11.0.6, the latest stable releases in their respective short-term series (maintained for one year).

MariaDB 10.4.34 and MariaDB 11.0.6 are the final scheduled releases in their respective series.

See the release notes and changelogs for details. …

Towards a healthy ecosystem

A healthy ecosystem around MariaDB Server involves an active community. Lots of happy code contributors cause fast development of new functionality, as well as increased adoption by users. Users see the vibrancy of the contributor space as a sign of health, rightfully so. Hence, preventive health care “with daily exercise and good eating habits” is high on the agenda of MariaDB Foundation.

But in practice, improving MariaDB’s habits around code development is about as easy as improving individual life habits in general, particularly if you are under public scrutiny. Let me here share a few thoughts on our progress, and solicit some input.

MariaDB is soon a vector database, too

We say: Put your AI vectors into your RDBMS …

Relational databases are where AI data belongs. Users need their vectors along with the rest of their data, in a standard database which offers performance, scalability, and all the other traditional virtues, such as ACID compliance.

This is why we are developing MariaDB Vector. Expect to see a first preview release later this month.

… but don’t take our word for it – ask Amazon!

Now, we’re not alone in advocating the above logic. That’s probably because the logic makes sense. The best articulation of the logic of “you want your Gen AI integrated in your relational database” I’ve heard is by MariaDB Foundation Board Member Sirish Chandrasekharan, General Manager of Amazon Relational Database Services.

How MariaDB and MySQL performance changed over releases

Is performance important for you, along with the latest features and long-term support? Go with MariaDB 11.4. But don’t take our word for it. We asked well known benchmarking expert Mark Callaghan to check out a number of MariaDB and MySQL releases, hit them hard with a tool of his choice, and share his findings.

MariaDB’s performance is stable over the years

The outcome: On the low concurrency load (high concurrency results are being prepared), MariaDB maintained stable performance over the last 10 years and 14 releases, while MySQL performance dropped almost by a third.