Planet MariaDB Server
Release and version management is hard
In this post I will talk about release management with MySQL as example. Release management has to do with what to put in a release, how often to do a…
Efficient MySQL Performance In 10 Sentences
Don’t have time to read Efficient MySQL Performance? Here’s the book (10 chapters) in one-liners. Performance is query response time. Proper left-most indexing is required for performance. The less data,…
Celebrating 15 years of MariaDB
It is 15 years since the first MariaDB server release of MariaDB 5.1.38 on 29’th of October 2009.MariaDB got its name from my youngest daughter Maria, following the tradition of…
Celebrating 15 years of MariaDB
It is 15 years since the first MariaDB server release of MariaDB 5.1.38 on 29’th of October 2009.MariaDB got its name from my youngest daughter Maria, following the tradition of…
Impressed by Disabling InnoDB Redo Logging for Creating Tables as Fast as Possible
In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables. I already wrote a post about my work (Faster MySQL Startup…
Impressed by Disabling InnoDB Redo Logging for Creating Tables as Fast as Possible
In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables. I already wrote a post about my work (Faster MySQL Startup…
Zero Downtime: Upgrading MySQL Server in a Tungsten Cluster
Tungsten Clustering allows for many types of maintenance to happen with no downtime at all. This blog post will explore how to upgrade the actual MySQL Server on all cluster…
Zero Downtime: Upgrading MySQL Server in a Tungsten Cluster
Tungsten Clustering allows for many types of maintenance to happen with no downtime at all. This blog post will explore how to upgrade the actual MySQL Server on all cluster…
Group Commit and Transaction Dependency Tracking
MySQL 8.0 and newer change and improve how we measure and monitor replication lag. Even though multi-threaded replication (MTR) has been on by default for the last three years (since…
Work around a MariaDB behaviour change
CREATE PROCEDURE p() BEGIN DECLARE v CHAR CHARACTER SET utf8 DEFAULT ”; SELECT * FROM information_schema.routines WHERE routine_name > v; END; CALL p(); Result: with current MariaDB 11.4 or MySQL…
MyDumper + ZFS – Merely Faster Than mysqldump is not Enough
Mydumper is a useful tool. Unlike mysqldump, it can take logical backups using many threads. Logical backups are frequently the only option for projects to migrate into the cloud, or…
Troubleshoot Amazon RDS for MySQL and Amazon RDS for MariaDB Errors
In this post, we discuss MySQL or MariaDB errors seen in error logs and application logs related to database, their possible root cause and how to effectively troubleshoot them on…
MariaDB Replication – slave_parallel_mode Difference
How much difference do different slave_parallel_mode settings make when we use parallel replication in MariaDB? In most cases, not much. The conservative setting has been the default for a long…
Learn how Presence migrated off a monolithic Amazon RDS for MySQL instance, with near-zero downtime, using replication filters
Presence is a leading provider of live therapy and evaluation services for PreK-12 schools throughout the United States. Founded in 2009, Presence has delivered over 6 million teletherapy sessions to…
Percona Monitoring and Management 2.43.0 Preview Release
Percona Monitoring and Management 2.43.0 Tech Preview Release Hello everyone! Percona Monitoring and Management (PMM) 2.43.0 is now available as a Tech Preview Release. We encourage you to try this…