Planet MariaDB Server
A full-fledged development environment with Docker
Setting up a complete development environment using Docker compose.
The Importance of Anti-Affinity in Kubernetes
Last week, I embarked on the task of deploying our Percona Operator for MongoDB in Kubernetes. After completing the deployment process, I noticed that the status of the Custom Resource…
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…