With Intel QuickAssist Technology, you can see a 5x performance in your MariaBackup compression, and lower CPU usage as well. Today I’m going to show you how.
What is Intel QuickAssist?
Nearly a decade ago, Intel released a technology called QuickAssist, which started out as a PCI-e card and then became integrated in many Xeon processes starting with the Skylake generation. QuickAssist Technology (often called QAT) is a special unit that the CPU can offload compression and encryption tasks onto.
I was lucky enough to have early access to this technology back when it was new.
…
Continue reading “Accelerating MariaBackup with Intel QuickAssist”
The schedule is up! https://mariadb.org/fest2024-brussels/
We are lucky and happy to have a great line-up of presenters for the MariaDB Server Fest 2-3 Feb 2024, a FOSDEM Fringe event during the Friday and Saturday of the FOSDEM weekend in Brussels.
Please join us in person in Brussels!
The event is, quite like FOSDEM this year, a physical one. You are welcome to join it in person, for free – less than 2 km from the university where FOSDEM convenes.
Friday is Migration and Money …
We start on Friday before FOSDEM itself, with the “Migration and Money” day.
…
It is the start of a new year, and with that brings the start of a new quarter, which means it is time for a contribution statistics update from us. I have lots of interesting data to walk you through this time, so let’s get started.
Year On Year Comparison
A good place to start would be to compare the previous year gone by with last year to see how we did. This table shows the number of organisations, contributors and commits to MariaDB Server in the last few years. The “Non-MariaDB” lines are contributors and commits by people who are not employed by MariaDB Plc or MariaDB Foundation.
…
Continue reading “MariaDB Contribution Statistics, January 2024”
The MariaDB Foundation is pleased to announce the availability of MariaDB 11.4.0, a preview release in the MariaDB 11.4 series. MariaDB 11.4 is a short-term release and will be maintained for one year after its G.A (stable) release.
The release contains the following new features. Note that as a preview release, not all features are guaranteed to make it into the MariaDB 11.4 series.
Partitioning
- ALTER TABLE … EXCHANGE PARTITION and ALTER TABLE … CONVERT TABLE … TO now support the WITH VALIDATION and WITHOUT VALIDATION clauses. If neither is specified, the default behavior is WITH VALIDATION (MDEV-22164)
Sys Schema
- New view sys.privileges_by_table_by_level shows granted privileges broken down by table on which they allow access and level on which they were granted.
…
Continue reading “MariaDB 11.4.0 preview release now available”
Our Sea Lion celebrates the end of a successful year, with a touch of Christmas spirit. We asked our AI Santa to create artwork that “evokes a sense of gratitude, optimism, and the magic of the holidays beneath the waves” – let me accompany the outcome with some reflections on the successful ending of the year.
Homework: What makes you feel good?
The trigger for the reflections was the last team Zoom meeting of the year, on Tuesday. I had asked everyone to prepare by doing a personal recap of what has happened the last three months (basically since our Staff meeting, (Un)conference, and MariaDB Server Fest early October).
…
In the blog MariaDB replication using containers, we showed how to properly replicate data in MariaDB using Docker containers.
We used standard or asynchronous or lazy replication.
The problem with this type of replication is potential data loss if the primary goes down. Transactions that are committed on the primary are not being sent to replicas, and the replica doesn’t commit the changes. Failover from primary to replica in this case may lead to missing transactions relative to the primary.
To overcome these type of errors, there is semi-sync replication that is integrated into MariaDB since 10.4 and fully sync replication, which we plan to implement eventually as MDEV-19140.
…
Continue reading “MariaDB semi-sync replication using containers”
Good news! cPanel, one of the leading control panels in the hosting world has just announced that they are going to make MariaDB Server the default database when installing new cPanel instances. This change is slated to occur in version 122 of cPanel & WHM, coming in Q3 of 2024. We at MariaDB Foundation are very happy about this decision and are looking forward to continuous collaboration, to the benefit of our users and the MariaDB Server project.
We think that this is a great decision for cPanel users because we at MariaDB have stayed true to the original values of MySQL, including:
- Long term backwards compatibility
- Painless upgrades and ease of use
- Long term stable releases;
…
Continue reading “MariaDB Server will be the default database in cPanel”
Remember our open letter, Looking for MySQL 5.7 or 8.0 guinea pigs?
We caught a nice German guinea pig!
We caught a nice guinea pig, a German one, from Hannover. They are currently using MySQL 5.7 (as was our prime wish), and they will be doing a live migration to MariaDB 10.11. They have 1.000.000.000 queries a day, their database size is 412 GB, and our goal is to the migration of the production data in less than five minutes – during our MariaDB Migration Workshop at our pre-FOSDEM event on Friday 2 Feb 2024.
…