Planet MariaDB Server
The Infamous ORDER BY LIMIT Query Optimizer Bug
Which is faster: LIMIT 1 or LIMIT 20? Presumably, fetching less rows is faster than fetching more rows. But for 16 years (since 2007) the MySQL query optimizer has had…
InnoDB Deadlock on SELECT? Not possible! Or Is It?
Translated by deepl.com Introduction Two points in advance: A deadlock is a state in which two different transactions are no longer able to continue working because each transaction holds a…
InnoDB Deadlock on SELECT? Not possible! Or Is It?
Translated by deepl.com Introduction Two points in advance: A deadlock is a state in which two different transactions are no longer able to continue working because each transaction holds a…
Day 02: The Kubernetes Application Lifecycle
If you are in the world of application development, you know that every application has a lifecycle. An application lifecycle refers to the stages that our application goes through from…
Optimizer-related fixes in current batch of stable releases
(EDIT: added also MDEV-32203) MariaDB released has made a batch of releases in the stable series. I wanted to list notable query optimizer improvements there, together with some comments. MDEV-29693:…
Data On Kubernetes
If you’ve attended one of the Kubecon talks or related events, you’ve likely encountered the phrase Data on Kubernetes. To understand what this means, let’s explore some fundamental concepts related…
Notes on Compression in the MySQL Protocol
The MySQL Protocol is the network protocol that is used between a MySQL server and a client. This is called the “classic” protocol as there is now a newer protobuf…
Notes on Compression in the MySQL Protocol
The MySQL Protocol is the network protocol that is used between a MySQL server and a client. This is called the “classic” protocol as there is now a newer protobuf…
The Future of MySQL Schema Change: Spirit
Using pt-online-schema or gh-ost? Of course you are; everyone in the MySQL industry does. But now there’s a new online schema change tool that will obsolete these two: Spirit by…
Migrate from Oracle to Amazon RDS for MySQL, MariaDB or Amazon Aurora MySQL using Oracle GoldenGate
When thinking about modernizing an Oracle Database to an open-source database on AWS, options include Amazon Relational Database Service (Amazon RDS) for MySQL, Amazon RDS for MariaDB, Amazon RDS for…
Exploring Kubernetes Operators
The concept of Kubernetes Operators was introduced around 2016 by the CoreOS Linuxdevelopment team. They were in search of a solution to improve automated container management within Kubernetes, primarily with…
Powering Amazon RDS with AWS Graviton3: Benchmarks
In April 2023, AWS announced the ability to power Amazon Relational Database Service (Amazon RDS) instances with the AWS Graviton3 processor. AWS Graviton3 was announced in May 2022 and is…
Building and Running Percona Everest From Source Code
Digging deeper into the architecture of an open source product Recently, Percona team announced the public alpha version of a new open source product – Percona Everest. It allows you…
Refactor admin task scheduler job schedules from IBM Db2 LUW to Amazon RDS for MySQL, Amazon RDS for MariaDB, or Amazon Aurora MySQL
The administrative task scheduler (ATS) in Db2 LUW is a component that allows you to automate and schedule administrative tasks within the database. It provides a convenient way to schedule…
Kubernetes Community Days UK: Keynote Cilium and eBPF
This week, at Kubernetes Community Days UK in London. Liz Rice, Chief Open Source Officer at Isovalent, delivered a keynote on Cilium, eBPF, and the new feature of Cilium: Mutual…