by Marco Tusa | Nov 9, 2021 | Insight for DBAs, Insight for Developers, MySQL
Well, let me say if that happens it’s because there is a logic mistake in your application. But you need to know and understand what happens in MySQL to be able to avoid the problem. In short, the WHY of this article is to inform you about possible pitfalls and...
by Nik Krichko | Oct 25, 2021 | Benchmarks, Insight for DBAs, MySQL
Recently we published the first part of research comparing Graviton (ARM) with AMD and Intel CPU on AWS. In the first part, we selected general-purpose EC2 instances with the same configurations (amount of vCPU). The main goal was to see the trend and make a general...
by Nik Krichko | Oct 15, 2021 | Benchmarks, Cloud, Insight for DBAs, MySQL
Recently, AWS presented its own CPU on ARM architecture for server solutions. It was Graviton. As a result, they update some lines of their EC2 instances with new postfix “g” (e.g. m6g.small, r5g.nano, etc.). In their review and presentation, AWS showed impressive...
by Matt Yonkovit | Oct 14, 2021 | Monitoring, MySQL, Percona Software, PostgreSQL
A few weeks ago we did a live stream talking about Percona Monitoring and Management (PMM) and showcased some of the fun things we were doing at the OSS Summit. During the live stream, we tried to enable some custom queries to track the number of comments being added...
by Sri Sakthivel | Oct 12, 2021 | MySQL, ProxySQL
ProxySQL 2.3.0 was recently released and when I was reading the release notes, I was really impressed with the Group Replication enhancements and features. I thought of experimenting with those things and was interested to write a blog about them. Here, I have focused...
by Brian Sumpter | Oct 8, 2021 | Insight for DBAs, Insight for Developers, MySQL, Security
As part of my ongoing focus on MySQL 8 user and password management, I’ve covered how using the new dual passwords feature can reduce the overall DBA workload and streamline the management process. I’ve also covered how the new password failure tracking features can...
by Ivan Groenewold | Oct 7, 2021 | Cloud, MySQL, Percona Software, ProxySQL
There are plenty of ways to run ProxySQL in Kubernetes (K8S). For example, we can deploy sidecar containers on the application pods, or run a dedicated ProxySQL service with its own pods. We are going to discuss the latter approach, which is more likely to be used...
by Agustín | Oct 6, 2021 | Monitoring, MySQL, Percona Software
In this short blog post, we are going to review how to avoid using credentials in the Percona Monitoring and Management (PMM) client command line when adding new exporters. We will use an example with the MySQL exporter, but it is extensible to others (PostgreSQL,...
by Lenz Grimmer | Oct 6, 2021 | MySQL, Percona Announcements, Percona Software, Storage Engine
As we’ve communicated in our blog post in May, the TokuDB Storage Engine has been marked as “deprecated” in Percona Server for MySQL 8.0. It will be removed in a future version (Percona Server for MySQL 8.0.28, expected to ship in Q1 2022). With the release of Percona...
by Brian Sumpter | Oct 5, 2021 | Insight for DBAs, MySQL, Security
As part of my ongoing focus on MySQL 8 user and password management, I’ve covered how the new dual passwords feature can reduce the overall DBA workload and streamline the management process (see MySQL 8: Dual Passwords). This wasn’t the only change to user/password...
by Sveta Smirnova | Oct 4, 2021 | Insight for DBAs, MySQL, Percona Software
It is a common use case to synchronize data in two tables inside MySQL servers. This blog post describes one specific case: how to synchronize data between two different tables on the same MySQL server. This could be useful, for example, if you test DML query...
by Daniil Bazhenov | Oct 1, 2021 | MongoDB, MySQL, Percona Events, PostgreSQL
Percona serves several communities including MySQL, PostgreSQL, and MongoDB. The Percona Community Team is committed to promoting content and technical advice on open source database technologies and needs. Hence, we organize monthly MeetUps as a series of regular...
by Mike Benshoof | Sep 28, 2021 | Insight for DBAs, Insight for Developers, MySQL
In a previous post, A Horizontal Scalability Mindset for MySQL, I discussed the concerns around growing individual MySQL instances too large and some basic strategies: Optimizing/minimizing size with proper data types Removing unused/duplicate indexes Keeping your...
by Aleksandra Abramova | Sep 28, 2021 | MongoDB, Monitoring, MySQL, Percona Software
It’s been a while since Percona started to develop its own software products, but collecting reviews is a new experience for us. We started this activity about a year ago, and the results we got are stunning. Your reviews said more about us than we ever could imagine....
by Mike Benshoof | Sep 27, 2021 | Insight for DBAs, MySQL, Percona Services, Percona Software
As a Technical Account Manager at Percona, I get to work with many of our largest clients. While the industry verticals vary, one main core challenge generally remains the same – what do I do with all this data? Dealing with massive data sets in MySQL isn’t a...
by Sri Sakthivel | Sep 22, 2021 | Insight for DBAs, MySQL
MySQL 8 comes with a lot of good features, and recently I explored its password management systems. I wanted to put together a series of blogs about it, and this is the first part. In this post, I am going to explain the following topics in detail. Password Reuse...
by Francisco Bordenave | Sep 21, 2021 | Benchmarks, Cloud, Insight for DBAs, MySQL
Primary Key design is an important thing for InnoDB performance, and choosing a poor PK definition will have an impact on performance and also write propagation in databases. When this comes to Aurora, this impact is even worse than you may notice. In short, we...
by David Ducos | Sep 21, 2021 | Insight for DBAs, MySQL
The new MyDumper 0.11.1 version, which includes many new features and bug fixes, is now available. You can download the code from here. For this release, there are three main changes: 1) we added config file functionality which allows users to set session-level...
by Slava Sarzhan | Sep 17, 2021 | Cloud, MySQL, Percona Software
Nowadays, more and more companies are thinking about the migration of their infrastructure to Kubernetes. Databases are no exception. There were a lot of k8s operators that were created to simplify the different types of deployments and also perform routine day-to-day...
by Carlos Tutte | Sep 16, 2021 | Insight for DBAs, MySQL, Percona Software
When doing migrations or failovers in MySQL, there is usually a need to do a topology change and repoint replica servers to obtain replication data from a different server. For example, given servers {A, B, and C} and the following topology: If you need to repoint C...
