by Marco Tusa | Jun 13, 2024 | Benchmarks, Database Trends, MySQL
At Percona, we monitor our users’ needs and try to accommodate them. One aspect we monitor is the MySQL version distribution/utilization. Observing that, we identified a very interesting trend: the lack of migration from 5.7 to 8.x, or better yet, the need of...
by Sergey Pronin | Mar 7, 2024 | Cloud, Insight for DBAs
I really like AWS and the way they build their products, I really do. But for some reason, AWS Elastic Kubernetes Service (EKS) provides one of the worst user experiences. There are a couple of huge pain points that I want to cover in this quick blog post. Cluster...
by Nurlan Moldomurov | Feb 1, 2024 | Monitoring, Percona Software
The Percona Monitoring and Management (PMM) Amazon Machine Image (AMI) currently lacks native support for ENV variables. In this guide, we’ll walk through a straightforward workaround that simplifies the process of using ENV variables in PMM AMI and reapplying...
by Yunus Shaikh | Jan 5, 2024 | Cloud, MySQL, Security
The AWS KMS component is now available in Percona Server for MySQL starting from version 8.0.30. This addition enables data-at-rest encryption by utilizing the AWS KMS component, providing the functionality to create and manage cryptographic keys across AWS services....
by Ananias Tsalouchidis | Jul 1, 2023 | Cloud, Insight for DBAs, MySQL, ProxySQL
This post was originally published in July 2018 and was updated in July 2023. Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should...
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 Jan Wieremjewicz | Apr 28, 2023 | Cloud, MongoDB, Percona Software, Security
Did you notice that Percona Server for MongoDB 6.0.5-4 was released just a few days ago? This time around, it introduced improvements to the way we handle master key rotation for data at rest encryption as well as AWS IAM integration. One key to rule them all —...
by Mario García | Mar 22, 2023 | Cloud, Monitoring, Percona Software
One of the installation methods we support for our database software is through Helm. We have a collection of Helm charts, in this repository, for the following Percona software: Percona Operator for MySQL Percona XtraDB Cluster Percona Operator for MongoDB Percona...
by Peter Sylvester | Feb 13, 2023 | Cloud, Insight for DBAs, MySQL
Recently, I was working with my colleagues Edwin Wang and Taras Onishchuk and found an interesting edge case involving a situation where a replica running Percona Server for MySQL 5.7, external to AWS Aurora instance version 2.10.2 (5.7-compatible), broke. I recreated...
by Sergey Pronin | Feb 10, 2023 | Cloud, MongoDB, Percona Software
Previously, deploying and maintaining a database usually meant many burdensome chores and repetitive tasks to ensure proper functioning. In the cloud era, however, developers and operation engineers started fully embracing automation tools making their job...
by Marco Tusa | Apr 22, 2022 | Cloud, Insight for DBAs, MySQL, Percona Software
In the last quarter of 2021, AWS released Aurora version 3. This new version aligns Aurora with the latest MySQL 8 version, porting many of the advantages MySQL 8 has over previous versions. While this brings a lot of new interesting features for Aurora, what we are...
by Nik Krichko | Jan 17, 2022 | Benchmarks, Cloud, MySQL
Recently we published the first part (m5, m5a, m6g) and the second part (C5, C5a, C6g) of research regarding comparing Graviton ARM with AMD and Intel CPU on AWS. We selected general-purpose EC2 instances with the same configurations (amount of vCPU in the first...
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 Peter Boros | Aug 20, 2021 | Cloud, Hardware and Storage, Insight for DBAs
EBS storage type choices in AWS can be impacted by a lot of factors. As a consultant, I get a lot of questions about choosing the best storage type for a workload. Let me share a few examples. Is io2 better than gp2/3 if the configured iops are the same? What can I...
by David Gonzalez | Jul 26, 2021 | Cloud, Insight for DBAs, PostgreSQL
We have several PostgreSQL versions that support logical decoding to replicate data changes from a source database to a target database, which is a cool and very powerful tool that gives the option to replicate all the tables in a database, only one schema, a specific...
by Peter Boros | Jul 9, 2021 | Cloud, Insight for DBAs, MySQL
Problem Statement Having backups of binary logs is fairly normal these days. The more recent binary logs are copied offsite, the better RPO (Recovery Point Objective) can be achieved. I was asked multiple times recently if something could be done to “stream” the...
by Peter Zaitsev | May 3, 2021 | Cloud, Monitoring, Percona Software
Percona Monitoring and Management has been available for single-click deployment from AWS Marketplace for several years now, and we have hundreds of instances concurrently active and growing rapidly due to unparalleled ease of deployment. Today we’re announcing we are...
by Sergey Kuzmichev | Apr 29, 2021 | Cloud, Insight for DBAs, Monitoring, Percona Software
Nothing lasts forever, including hardware running your EC2 instances. You will usually receive an advance warning on hardware degradation and subsequent instance retirement, but sometimes hardware fails unexpectedly. Percona Monitoring and Management (PMM) currently...
by Ivan Groenewold | Jan 28, 2021 | Cloud, MySQL, ProxySQL
There are several ways to deploy ProxySQL between your applications and the database servers. A common approach is to have a floating virtual IP (VIP) managed by keepalived as the application endpoint. The proxies have to be strategically provisioned to improve the...
