by Daniel Guzmán Burgos | Oct 7, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
Visibility is a blessing, and with databases, visibility is a must. That’s true not only for metrics but for the queries themselves. Having info on all the stats around query execution is priceless, and Percona Monitoring and Management (PMM) offers that in the form...
by Vasyl Yurkovych | Oct 7, 2020 | Insight for DBAs, Insight for Developers, Monitoring, Percona Software
Hey Community! This is my first blog post so let me introduce myself. My name is Vasyl Yurkovych. I am a QA Automation Engineer at Percona and I have solid experience in software testing. Software quality is one of the main focuses of Percona so we put a lot of...
by Sri Sakthivel | Oct 6, 2020 | MySQL, Open Source, Percona Software
Schema changes are the big challenges in Galera replication. So, it is recommended to understand the schema changes operation for everyone who uses the Percona XtraDB Cluster (PXB)/Galera clusters. In this blog, I am going to explain the operation and impact of the...
by Walter Garcia | Oct 2, 2020 | Insight for DBAs, Insight for Developers, MySQL
Hello everyone, in this little post we will review a new feature in MySQL 8. What is “CHECK Constraint”? This is a new feature to specify a condition to check the value before INSERT or UPDATE into a row. The constraint could return an error if the result...
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 Daniel Guzmán Burgos | Oct 2, 2020 | Insight for DBAs, Insight for Developers, MySQL, ProxySQL
Maybe one of the more “obscure” operations when dealing with replica lag, or, in general, when one needs to control writes to the database, is the Rate limit. It’s also lately one of the most popular conversations around the community. But what is it? In plain...
by Vadim Tkachenko | Oct 1, 2020 | Hardware and Storage, MongoDB, MySQL, Percona Software
Network volumes in Kubernetes provide great flexibility, but still, nothing beats local volumes from direct-attached storage in the sense of database performance. I want to explore ways to deploy both Percona Kubernetes Operators (Percona Kubernetes Operator for...
by Francisco Bordenave | Sep 30, 2020 | Insight for DBAs, MySQL, Storage Engine
In this post, we will discuss what to do when you add more memory to your instance. Adding memory to a server where MySQL is running is common practice when scaling resources. First, Some Context Scaling resources is just adding more resources to your environment, and...
by Nicola Lamacchia | Sep 29, 2020 | Insight for Developers, Monitoring, Percona Software, Security
With version 2.9.1 of Percona Monitoring and Management (PMM) we delivered some new improvements to its Security Threat Tool (STT). Aside from an updated user interface, you now have the ability to run STT checks manually at any time, instead of waiting for the normal...
by Peter Zaitsev | Sep 28, 2020 | Monitoring, Percona Software
Percona Monitoring and Management 2.10 shipped a few days ago and while it is a minor release, it introduces some features which I absolutely love. In this blog post, I will talk about those features – what they are and why they are worth loving. 🙂 1. Query...
by Brandon Fleisher | Sep 16, 2020 | Monitoring, Percona Services, Percona Software
Google, Microsoft, and Apple have it. So do open source organizations like MongoDB, Red Hat, and SUSE. What do all these companies provide? A customer portal that enables anyone to create an identity with the company. To date, Percona hasn’t had a customer portal with...
by Jake Davis | Sep 15, 2020 | Insight for DBAs, MySQL
If you are using XA transactions, then you’ve likely run into a few replication issues with the 2PCs (2 Phase Commits). Here is a common error we see in Percona’s Managed Services and a few ways to handle it, including injecting an empty XA transaction. Shell...
by Daniil Bazhenov | Sep 14, 2020 | MySQL, Percona Services, Percona Software
MySQL 8.0 General Availability release was launched in April 2018, and since then there have been ten versions of MySQL 8 and Percona Server for MySQL released. The MySQL Community expressed a high opinion of the MySQL 8.0 advantages, so a lot of databases have been...
by Daniel Guzmán Burgos | Sep 11, 2020 | Cloud, Insight for DBAs, MySQL
In a previous blog post on Data Consistency for RDS for MySQL, we presented a workaround to manage run pt-table-checksum on RDS instances. However, if your instance is running a MySQL 8.0.X version, there’s a simpler way to check data consistency. Starting with 8.0.1,...
by Peter Zaitsev | Sep 11, 2020 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
One of the questions you often will be faced with operating a Linux-based system is managing memory budget. If a program uses more memory than available you may get swapping to happen, oftentimes with a terrible performance impact, or have Out of Memory (OOM) Killer...
by Daniel Guzmán Burgos | Sep 8, 2020 | Cloud, Insight for DBAs, MySQL
MySQL for RDS and DBaaS, in general, are very controlled environments by the vendors, meaning that there are missing things like a SUPER grant for the root user (and any user in general). This has some implications on operations, one of them being the impossibility of...
by Lalit Choudhary | Aug 31, 2020 | Insight for DBAs, Insight for Developers, Percona Software
At Percona, we operate on the premise that full-transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source form,...
by David Ducos | Aug 28, 2020 | Insight for DBAs, MySQL, Open Source, ProxySQL
We sometimes receive challenging requests… this is a story about one of those times. The customer has implemented a sharding solution and would like us to review alternatives or improvements. We analyzed the possibility of using ProxySQL as it looked to be a...
by Peter Zaitsev | Aug 28, 2020 | Insight for DBAs, MySQL, ProxySQL
ProxySQL brings a lot of value to your MySQL infrastructures such as Caching or Connection Multiplexing but it does not come free — your database needs to go through additional processing traffic which adds some overhead. In this blog post, we’re going to discuss...
by Vadim Tkachenko | Aug 27, 2020 | Benchmarks, Insight for DBAs, MySQL
Recently I posted about checkpointing in MySQL, where MySQL showed interesting “wave” behavior. Soon after Dimitri posted a solution with how to fix “waves,” and I would like to dig a little more into proposed suggestions, as there are some materials to process. This...
