Planet MariaDB Server

You filed a bug report at 11pm because you’d already done the work to isolate it. You answered a forum question that had been sitting unanswered for three days. You wrote a PR. You spent an hour on a call telling us what’s broken about a tool you use every day. None of that is small, and none of it should go unnoticed…. Read more

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

Recently, a client asked me if the “time-consuming” task of checking indexes could be left to an index optimizer. Of course it can… What exactly do we want to check? Tables without a Primary Key Duplicate indexes Partially redundant indexes Unused indexes MariaDB, MySQL, and Percona Server Tables without a Primary Key SQL > SELECT DISTINCT t.table_schema, t.table_name FROM information_schema.tables AS t LEFT JOIN information_schema.columns AS c ON t.table_schema = c.table_schema AND t.table_name = c.table_name AND c.column_key = "PRI" WHERE t.table_schema NOT IN ('information_schema', 'mysql', 'performance_schema') AND c.table_name IS NULL AND t.table_type NOT IN('VIEW', 'SEQUENCE') AND t.table_schema = 'testtest' ;… 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