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 –...
by Mani Paluru | Apr 4, 2023 | Insight for DBAs, MySQL
In this blog post, we’ll look at MySQL 8 user attributes and how we can use them. What is the user attribute? A user attribute is a JSON object made up of one or more key-value pairs, and it is set while creating the user with CREATE USER and by including ATTRIBUTE...
by David Stokes | Apr 4, 2023 | Insight for DBAs, Insight for Developers, MySQL
MySQL 5.7 reaches End of Life status this October. If you still need to start your migration, time is getting short. The first step for many is looking into the new reserved words in MySQL 8.0. As MySQL gets new functionality or the project matures, there are new...
by Pete Scott | Mar 30, 2023 | Insight for DBAs
The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. This comprehensive...
by Smit Arora | Mar 29, 2023 | Insight for DBAs, MySQL
A partitioned table in MySQL has its data separated into different tablespaces while still being viewed as a single table. Partitioning can be a useful approach in some cases when handling huge sets of data. Deleting huge data sets could be quickened up in a...
by Carlos Tutte | Mar 27, 2023 | Insight for DBAs, MySQL, Percona Software
On MySQL and Percona Server for MySQL, there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. A lot of useful information can be retrieved from this schema, for example, table metadata and foreign...
by Yura Sorokin | Mar 24, 2023 | Insight for DBAs, Insight for Developers, MySQL
In MySQL Server 8.0.32, Oracle fixed Bug #105761: “mysqldump make a non-consistent backup with ‐‐single-transaction option” (this commit) which caused a wave of complaints from users who could no longer do backups with the mysqldump utility because of the lack of the...
by Denis Subbota | Mar 24, 2023 | Insight for DBAs, Insight for Developers, MySQL
You might want to use binlog compression with MySQL/Percona Server for MySQL, but it can come with drawbacks. This article discusses the need for using binlog compression and the potential issues it may cause. Binlog compression is a technique used to reduce the size...
by Gaurav Pareek | Mar 21, 2023 | Insight for DBAs, MySQL, Security
In this blog, I’ll discuss the use case for replication. We want to improve our ability to replicate your data and limit replication to row-based events securely, wherein we do not have control over the source(s). The replica doesn’t have checking...
by Puneet Kala | Mar 17, 2023 | Insight for DBAs, Monitoring, MySQL, Percona Software
2022 was an exciting year for Percona Monitoring and Management (PMM). We’ve added and improved many features, including Alerting and Backup Management. These updates are designed to keep databases running at peak performance and simplify database operations. But as...
by Daniel Guzmán Burgos | Mar 16, 2023 | Cloud, Insight for DBAs, MySQL, Percona Software
Let’s look at how you can run Percona databases on Kubernetes, the easy way. Chances are that if you are using the latest Percona Monitoring and Management (PMM) version, you have seen the availability of the new Percona Database as a Service (DBaaS). If not, go and...
by Larry Xia | Mar 13, 2023 | Insight for DBAs, MySQL, Percona Software
When we need to upgrade from MySQL 5.7 to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 replica. This article will explain how to set up MySQL 8 as a replica from an existing MySQL 5.7 server...
by Michael Villegas | Mar 8, 2023 | Insight for DBAs, Insight for Developers, MySQL
Over the years of being a DBA, I had to deal with all kinds of problems in the database. One of the most common problems I faced is the one related to the well-known error “ERROR 1040 (08004): Too many connections”. A lot has been written about this error. Still, the...
