Planet MariaDB Server

What is the MariaDB Enterprise Kubernetes Operator? The MariaDB Enterprise Kubernetes Operator makes it easier to run and manage MariaDB […]… Read more

When most people start working with PostgreSQL, they quickly learn SQL: [crayon-6a57891fbdcdf304804307/] But very soon, another world opens up inside psql — a set of commands that don’t look like SQL, don’t end with semicolons. These are PostgreSQL Meta Commands, and they quietly power the daily workflow of almost every experienced DBA. Meta commands are … Continued The post PostgreSQL Meta Commands that save time every day appeared first on Percona…. Read more

MySQL 9.7, a Long-Term Support (LTS) release, incorporates a variety of potential features spanning across multiple technical domains. This article covers some of the primary features introduced and evaluates their practical utility within the MySQL database environment. Following the End-of-Life (EOL) status of MySQL 8.0, this subsequent LTS release is designed to provide enhanced stability … Continued The post Inside MySQL 9.7 LTS Features appeared first on Percona…. Read more

When people hear “online schema change” in the MySQL and MariaDB world, many immediately think about pt-online-schema-change. And for good reasons: for years, changing a large table in production was one of those tasks that could ruin your day. … Continue reading "MariaDB Hidden Gem: Online Schema Change without pt-osc" The post MariaDB Hidden Gem: Online Schema Change without pt-osc appeared first on MariaDB.org…. Read more

About a year ago, we discussed how MyDumper refactored its locking mechanisms to move away from old, rigid flags and transitioned towards more flexible, streamlined execution. Since then, the MyDumper community hasn’t stood still. In recent releases, the locking architecture was further standardized under a single overarching option: –sync-thread-lock-mode. Along with this modernization came a … Continued The post MyDumper Locking Mechanisms Revisited: Introducing SAFE_NO_LOCK appeared first on Percona…. Read more

ducksdb-mysql-engine is an experimental build of MySQL 9.7 where a table you mark ENGINE=DuckDB answers analytical queries from DuckDB instead of InnoDB. Same server, same connection, no second copy of the data. On TPC-H at scale factor 10, InnoDB times out on 6 of the 22 queries and burns 1317 seconds on the 16 it … Continued The post Running DuckDB as a MySQL 9.7 storage engine appeared first on Percona…. Read more

Some contributions improve MariaDB Server by adding new capabilities. Some go further: they start from a concrete production problem with an existing feature, not a bug, but a design limitation, solve it upstream, and leave the whole ecosystem better off. … Continue reading "MariaDB 13.1 Feature in Focus: BLOB, TEXT, JSON and GEOMETRY Support in the HEAP Engine" The post MariaDB 13.1 Feature in Focus: BLOB, TEXT, JSON and GEOMETRY Support in the HEAP Engine appeared first on MariaDB.org…. Read more

Migrating from MySQL to MariaDB is not considered to be an overly complex process.  After all, the two databases share […]… Read more

The promise of “serverless” is attractive to AI developers. Serverless is a cloud computing model that abstracts away infrastructure management, […]… Read more

Interview with Federico Razzoli, nominated in the Community Leadership category. The MariaDB Foundation Sea Lion Champions program celebrates the people and organizations who help make the MariaDB ecosystem stronger, more open, and more useful for everyone. … Continue reading "MariaDB Foundation Sea Lion Champions Nominees: Federico Razzoli" The post MariaDB Foundation Sea Lion Champions Nominees: Federico Razzoli appeared first on MariaDB.org…. Read more

Recently we noticed a LinkedIn post promoting open_pg_tde, a fork of our pg_tde, claiming to be more open. I looked at the repository, and have to disagree with their claim. In this blog post, I’ll explain why…. Read more

MariaDB is pleased to announce the immediate availability of MariaDB Connector/C++ 1.1.8 and 1.0.7 and MariaDB Connector/ODBC 3.2.9 and 3.1.23. […]… Read more

  Percona Operator for MySQL 1.2.0 is out, and it closes three gaps that platform teams hit once a MySQL deployment grows past a single cluster. Picture a fleet that has outgrown one region: you want a warm replica cluster in a second data center, backups in object storage that pass an auditor’s encryption check, … Continued The post Percona Operator for MySQL 1.2.0: Cross-Site Replication, Encrypted Backups, and Automatic Storage Scaling appeared first on Percona…. Read more

Migrating a production PostgreSQL database on Kubernetes is not only about moving data from one operator to another. It is also about choosing the right trade-off between downtime, operational complexity, rollback safety, cost, and business risk. Practical migration paths from the Crunchy Data PostgreSQL Operator to the Percona Operator for PostgreSQL are described here.  1. … Continued The post Comparing Migration Methods from the Crunchy Data PostgreSQL Operator to the Percona Operator for PostgreSQL appeared first on Percona…. Read more

TAF 3.0 introduces the new TAF Results Backend, a structured results database and parser pipeline that delivers fully automated performance change detection. … Continue reading "TAF 3.0 — Results Backend With Automated Performance Change Detection" The post TAF 3.0 — Results Backend With Automated Performance Change Detection appeared first on MariaDB.org…. Read more