Planet MariaDB Server
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…
Faster MySQL Startup with Many Tables (1M+)
I have been scratching my head about MySQL startup for some time. There is much to say about this, and many other posts will probably follow. For now, it is…
Faster MySQL Startup with Many Tables (1M+)
I have been scratching my head about MySQL startup for some time. There is much to say about this, and many other posts will probably follow. For now, it is…