Planet MariaDB Server

I recently shared results for Postgres vs sysbench on a large server. The results were mostly boring (it is rare for me to spot regressions in Postgres) but there was one microbenchmark where there was a problem. The problem microbenchmark does a range scan with aggregation and the alleged regression arrived in Postgres 11. With advice from Postgres experts it looked like the problem was an intermittent change in the query plan.In this post I explain additional tests that I did and in this case the alleged regression was still there, but like many things in DBMS-land it depends, there… Read more

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/C++ 1.1.6 and 1.0.5 releases. Download Now Release Notes … Continued… Read more

For a very long time, the EXPLAIN command remained the same in the MariaDB and MySQL world. It was good enough in most cases, but the community welcomed the implementation of extensions and variants. However, MariaDB and MySQL improved it in different ways. So, if you’re familiar with one of these two databases, and you happen to use the other, you might not be aware of which options you have. And if you come from a totally different technology, you might not know anything about MariaDB and MySQL EXPLAIN. This article is a quick summary. Basic EXPLAIN The common implementation… Read more

Are you passionate about databases and want to stay on top of the latest advancements in MySQL and Percona Toolkit? You’re in luck! We are excited to invite you to our upcoming online stream, where we’ll delve into some exciting changes and updates. Date: March 27, 2025 Time: 13:30 GMT / 9:30 ET Streaming Live on: LinkedIn and YouTube About the Event Our featured speaker, Sveta Smirnova, Principal Support Engineering Coordinator at Percona, will share her insights on the recent updates in MySQL, focusing on the removal of offensive replication statements like START/STOP SLAVE…. Read more

Running MariaDB on AWS? You have a number of different ways to accomplish this from setting it up yourself to … Continued… Read more

Preventing data theft : Galera editionGalera Cluster is a synchronous multi-master replication solution for MySQL, MariaDB, and Percona XtraDB. It offers high availability and data consistency across multiple database nodes. While built into MariaDB server, it remains a separate third-party library for MySQL and Percona XtraDB.Many believe that securing data streams with TLS and encrypting data-at-rest (GCache encryption included in the Enterprise version) is sufficient for data security. However, a core feature can be exploited to steal data from an unsuspecting cluster.Snapshot State Transfert (SST) is a fundamental mechanism in Galera Cluster that enables full data synchronization between nodes. It’s triggered when a… Read more

“The act of measuring disturbs the system and changes its state.” is a quote attributed to Werner Heisenberg. While I am uncertain about whether Heisenberg ever uttered those exact words, I am certain that the quote “What doesn’t get measured, doesn’t get managed” … Continue reading "This month in MariaDB Foundation: Feb 2025" The post This month in MariaDB Foundation: Feb 2025 appeared first on MariaDB.org…. Read more

Percona is excited to announce the community release of our MySQL 5.7 End-of-Life (EOL) source code for both Percona Server for MySQL (PS) version 5.7.44-52 and Percona XtraDB Cluster (PXC) version 5.7.44-31.65.5. This release is an accumulation of several customer-only releases we’ve done as part of our post-EOL support for MySQL 5.7, and we’re happy […]… Read more

We are excited to announce a hackathon with MariaDB Vector and Python. Since we are reaching outside our bubble, let’s start from the beginning:  MariaDB, the open-source database powers the world’s most demanding applications, from Wikipedia to global financial institutions. … Continue reading "Join our AI Hackathon with MariaDB Vector" The post Join our AI Hackathon with MariaDB Vector appeared first on MariaDB.org…. Read more

In our MariaDB advanced training courses, which we hold approximately every two months, we use machines that are directly exposed to the Internet with a public IP address. Warning: You should NEVER expose a database directly to the Internet without protection! Typically, it takes less than 72 hours (3 days) before we are exposed to the first external access attempts. This looks something like this in the MariaDB error log: [Warning] Aborted connection 22939 to db: 'unconnected' user: 'unauthenticated' host: '118.193.58.125' (This connection closed normally without authentication) [Warning] Aborted connection 22940 to db: 'unconnected' user: 'unauthenticated' host: '118.193.58.125' (This connection… Read more

Have you ever needed to rewind time in your database to see data as it looked a year ago or … Continued… Read more

Our brand promise, “Database ops your way”, rests on three pillars: accessibility, portability and selection. That is why we’re thrilled to share that ClusterControl’s powerful automation platform for managing on-prem and hybrid deployments is now available as a pay-as-you-go, monthly subscription! Let’s dive into the details! ClusterControl adds Self-Service plan for greater optionality ClusterControl has […] The post ClusterControl brings flexible pay-as-you-go self-serve experience to on-prem workloads appeared first on Severalnines…. Read more

Openness, Adoption, Continuity: You’ve heard me repeating our mantra like a broken record. Today is the next episode – and the theme du jour is about our Board Meetings, which we have minuted publicly on https://mariadb.org/bodminutes/ since October 2020. … Continue reading "Report from the Board" The post Report from the Board appeared first on MariaDB.org…. Read more

The internet has changed to a place where most protocols like HTTP etc now use secure connections with TLS by default. While both HTTP and the MySQL Protocol use TLS for secure connections there are still many differences which make it difficult for MySQL to benefit from the same advancements as HTTP has seen in the last so many years. What is TLS? TLS stands for Transport Layer Security and is the successor of SSL (Socket Layer Security). SSL and TLS are often used interchangably, while this isn’t correct strictly speaking. What TLS provides is a standardized way to encrypt… Read more

Reduced operational downtime with new Online Schema Change We recently released MariaDB Enterprise Server 11.4 as part of the MariaDB … Continued… Read more