by David Quilty | Apr 2, 2025 | Insight for DBAs, MariaDB, MySQL
This post was originally published in May 2024 and was updated in April 2025. MySQL and MariaDB are two major open source database management systems that share a common codebase and history. MariaDB started as a MySQL fork in 2009 to provide an alternate database...
by Przemysław Malkowski | Dec 18, 2024 | Insight for DBAs, Insight for Developers, MariaDB, MySQL
An application down due to not being able to write into a table anymore due to a maximum allowed auto-increment value may be one of the worst nightmares of a DBA. Typical errors related to this problem in MySQL will look like this: ERROR 1062 (23000): Duplicate entry...
by David Quilty | Apr 23, 2024 | Insight for DBAs, MariaDB, MySQL, Percona Software
Apples or oranges? Tea or coffee? Books or eBooks? Each of these comparisons has very similar features and serves many of the same purposes, but in the end, they are different choices people make. Do you know what else belongs on this list? MariaDB or MySQL? It’s time...
by Przemysław Malkowski | Apr 15, 2024 | Insight for DBAs, MariaDB, MySQL
If you have enough experience with MySQL, it is very possible that you stumbled upon an unusually slow SELECT COUNT(*) FROM TABLE; query execution, at least occasionally. Recently, I had a chance to investigate some of these cases closer, and it stunned me what huge...
by Brijesh Chauhan | Apr 11, 2024 | Insight for DBAs, MariaDB, MySQL
MySQL/MariaDB replication filter is an important feature when we need to replicate only certain databases or tables. Having this configuration option change dynamically is really convenient, but in this article, we’ll note that some replication filters are not...
by Przemysław Malkowski | Nov 1, 2023 | Insight for DBAs, MariaDB, MySQL, Percona Software
Sometimes, there is a need to update the table and index statistics manually using the ANALYZE TABLE command. Without going further into the reasons for such a need, I wanted to refresh this subject in terms of overhead related to running the command on production...
by Fernando Mattera | Oct 31, 2023 | Insight for DBAs, MySQL, Percona Services
Hello friends, In Managed Services, we have the opportunity to see different technologies and various topologies, which makes the work fascinating and challenging at the same time. This time, I’m going to tell you about a particular case: a client with a...
by Larry Xia | Sep 15, 2023 | Insight for DBAs, MariaDB, MySQL
At Percona Managed Services, we manage Percona Server for MySQL, Community MySQL, and MariaDB. There are slight differences when configuring and managing MariaDB GTID replication. In this blog, we’ll show you how to convert MariaDB binary log file and position-based...
by Rituja Borse | Aug 18, 2023 | Insight for DBAs, MariaDB, MySQL
Note that MariaDB 10.4 is not the latest version and has had new releases since 10.4. The client requirement was to move to MySQL 8.0 on the cloud for specific RDS features. Caution: It is important to verify that you are not using any specific MariaDB features...
by Peter Zaitsev | Aug 4, 2023 | Database Trends, MariaDB, MySQL, Percona Software
In this blog post, we will look at the lifecycle and release management for MySQL and MariaDB servers — where we are now and relevant historical background. It is worth noting both MySQL and MariaDB have Community and Enterprise versions. For MySQL, both releases...
by Colin Charles | Jun 4, 2023 | Insight for DBAs, MariaDB, MySQL
This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL). Introduction: MariaDB vs. MySQL The goal of this blog post is to...
by Fernando Mattera | Jun 1, 2023 | Insight for DBAs, MariaDB, MySQL, Percona Software
Hello friends, on certain occasions, some clients, for whatever reason, ask us to migrate a supposedly “equivalent” brand of an engine in terms of belonging to the MySQL family or ecosystem. In this case, we will be analyzing the migration of MariaDB to...
by David Stokes | Mar 28, 2022 | Insight for DBAs, MariaDB
MariaDB 10.9 is a preview release of the popular open source database server and is considered alpha level code (pronounced: Not for production). It offers a glimpse of the evolution of the product and introduces some new features, at least for MariaDB. Since I took...
by Nickolay Ihalainen | Jan 27, 2021 | Benchmarks, MariaDB, MongoDB, MySQL, PostgreSQL
I want to present a tool for running a specific version of open source databases in a single instance, replication setups, and Kubernetes. AnyDbVer deploys MySQL/MariaDB/MongoDB/PostgreSQL for testing and experiments. It Could Be Started By… Docker (or Podman)...
by David Quilty | Jan 6, 2021 | Insight for DBAs, MariaDB, Percona Software, Webinars
Don’t miss out! Join Peter Zaitsev, Percona CEO, as he discusses MariaDB observability! A broken MariaDB means a broken application, so maintaining insights in MariaDB operational performance is critical. Thankfully MariaDB offers a lot in terms of observability...
by Sri Sakthivel | Oct 2, 2020 | Insight for DBAs, MariaDB, MySQL
MariaDB 10.5 was released in June 2020 and it will be supported until June 2025. This is the current stable version and comes with more exciting new features. In this blog, I am going to explain the new and exciting features involved in MariaDB 10.5. Amazon S3 engine...
by Vadim Tkachenko | Aug 14, 2020 | Benchmarks, MariaDB, MySQL
MariaDB no longer meeting your needs? Migrate to Percona software for MySQL – an open source,production-ready, and enterprise-grade MySQL alternative. Learn More Recently, I published a series of posts on MySQL and MariaDB, where MariaDB 10.5.4 does not...
by Yves Trudeau | Aug 4, 2020 | MariaDB, MySQL, Storage Engine
This post has been written in collaboration with Nicolas Modalvsky of e-planning. Nicolas and I recently worked together on a tuning engagement involving MyRocks on MariaDB. While it is easy to find online articles and posts about InnoDB performance, finding...
by Vadim Tkachenko | Jul 30, 2020 | Benchmarks, MariaDB, MySQL
MariaDB no longer meeting your needs? Migrate to Percona software for MySQL – an open source,production-ready, and enterprise-grade MySQL alternative. Learn More MySQL and MariaDB on NVMe Storage – The Great Equalizer Continuing with the...
by Vadim Tkachenko | Jul 29, 2020 | Benchmarks, MariaDB, MySQL
Continuing with the checkpointing topic I restarted a month ago with MongoDB and followed with PostgreSQL, I wanted to check how MySQL and MariaDB perform. It was actually some time when I last looked into MySQL in this regard, so I am curious how new MySQL versions...
