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 Joe Brockmeier | Jun 2, 2023 | Database Trends, MySQL, Open Source
WordPress, the ubiquitous publishing platform that launched millions of blogs and websites, turned 20 on May 27th. While not the first open source content management system (CMS), WordPress caught on like nothing before and helped spread open source to millions. It...
by Peter Zaitsev | Jun 1, 2023 | Insight for Developers, MySQL
Updated June 1, 2023. Suboptimal MySQL ORDER BY implementation, especially together with MySQL LIMIT is often the cause of MySQL performance problems. Here is what you need to know about MySQL ORDER BY LIMIT optimization to avoid these problems. Try Now: Free your...
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 Ducos | May 16, 2023 | Insight for DBAs, MySQL
At the end of 2021, I pushed the first Docker image to hub.docker.com. This was the first official image and since then, we have been improving our testing and packaging procedures based on Docker, CircleCI, and GitHub Actions. However, when I’m coding, I’m not...
by Marco Tusa | May 15, 2023 | Cloud, Insight for DBAs, MySQL, Percona Software
Historically MySQL is great in horizontal READ scale. The scaling, in that case, is offered by the different number of Replica nodes, no matter if using standard asynchronous replication or synchronous replication. However, those solutions do not offer the same level...
by Anil Joshi | May 2, 2023 | Insight for DBAs, MySQL, Percona Software, Security
Sometimes crucial data sharing is avoided because of compliance rules, organizational policies, or numerous security concerns. The common use cases involve sharing pt-mysql-summary, pt-stalk, and other OS-related details to assist Support Engineers or any other...
by Vinicius Grippa | May 2, 2023 | Database Trends, Insight for DBAs, MySQL
Given the increasing popularity of ChatGPT in solving questions of humankind, I decided to take a better look at the current state of AI. At the same time that I see database engineers relying on the tool, sites such as StackOverflow are banning ChatGPT. As the...
by Francisco Bordenave | May 1, 2023 | Cloud, Insight for DBAs, MySQL
Default settings can help you get started quickly – but they can also cost you performance and a higher cloud bill at the end of the month. Want to save money on your AWS RDS bill? I’ll show you some MySQL settings to tune to get better performance, and cost...
by Abhinav Gupta | Apr 24, 2023 | MySQL, ProxySQL, Security
In this blog post, we will see how to persist the password inside the ProxySQL mysql_users table in hashed format only. Also, even if someone stored the password in cleartext, we see how to change those into the hashed format easily. Here we are just highlighting one...
by Mughees Ahmed | Apr 21, 2023 | Insight for DBAs, MySQL
In this article, we will discuss errant Transaction /GTID and how we can solve them with the Orchestrator tool. Orchestrator is a MySQL high availability and replication management tool that runs as a service and provides command line access, HTTP API, and Web...
by Brian Sumpter | Apr 20, 2023 | Insight for DBAs, MySQL, Percona Software
As we approach end of life for MySQL 5.7 later this year, many businesses are currently working towards upgrading to MySQL 8. Such major version upgrades are rarely simple, but thankfully there are tools that can help smooth the process and ensure a successful...
by David Stokes | Apr 19, 2023 | Insight for DBAs, MySQL
MySQL released version 8.0.33 on April 18th, featuring some attention-catching features. This blog post is a quick review of the release notes looking for the exciting items, and comments in italics are solely my own. User-defined collations are now deprecated and...
by Matthew Boehm | Apr 17, 2023 | Insight for DBAs, MySQL, Percona Services
If you have not been keeping up with MySQL news, MySQL 5.7 reaches end of life in October 2023. This means no more bug fixes or security updates for MySQL 5.7. Users will be effectively forced to upgrade to MySQL 8. Upgrading to MySQL 8 from 5.7 is nowhere near as...
by Fernando Laudares Camargos | Apr 14, 2023 | Monitoring, MySQL, Percona Software
A shared characteristic in most (if not all) databases, be them traditional relational databases like Oracle, MySQL, and PostgreSQL or some kind of NoSQL-style database like MongoDB, is the use of a caching mechanism to keep (a copy of) part of the data in memory. The...
by Kedar Vaijanapurkar | Apr 12, 2023 | Insight for DBAs, MySQL, Percona Software
During the early stages of my career, I was captivated by the theories and concepts surrounding foreign keys and how they empowered us to maintain data integrity. However, in practical application, I have found them to be quite challenging to manage. I am sure...
by Kedar Vaijanapurkar | Apr 11, 2023 | Insight for DBAs, MySQL, Percona Software
Indexes are crucial for optimizing query execution times in databases, but having an excessive number of indexes, or redundant ones, can negatively impact performance. While pt-duplicate-key-checker is the go-to tool for identifying duplicate or redundant indexes in...
by David Ducos | Apr 10, 2023 | Insight for DBAs, MySQL
For a long time, MyDumper has been the fastest tool to take Logical Backups. We have been adding several features to expand the use cases. Masquerade was one of these features, but it was only for integer and UUID values. In this blog post, I’m going to present...
by Agustín | Apr 6, 2023 | Insight for DBAs, Monitoring, MySQL, Percona Software, PostgreSQL
In this blog post, we’ll check how to integrate Percona Monitoring and Management (PMM) with Loki to be able to get not only metrics and queries from our database servers but also text-based information like logs. Loki is a log aggregation tool developed by...
by Mike Benshoof | Apr 4, 2023 | Insight for DBAs, MySQL, ProxySQL
When talking about the benefits and use cases of ProxySQL with clients, one feature I generally reference is the query rewrite engine. This is a great feature that is often used for sharding (I’ve written about this in the past at Horizontal Scaling in MySQL –...
