MySQL 5.7, alongside other many improvements, brought bulk load for creating an index (WL#7277 to be specific), which made ADD INDEX operations much faster by disabling redo logging and making the changes directly to tablespace files. This change requires extra care for backup tools. To block DDL statements on an instance, Percona Server for MySQL [&]

https://www.percona.com/blog/2020/12/22/redesign-of-lock-ddl-per-table-in-percona-xtrabackup/

As mentioned in the AWS discussion forum back in October, Amazon has started the end of life (EOL) process for RDS MySQL version 5.5. What this means is: AWS will upgrade RDS instances to MySQL 5.7 starting February 9 2021 00:00 UTC during your next defined maintenance window, provided you have one. If you dont [&]

https://www.percona.com/blog/2020/12/21/amazon-rds-for-mysql-5-5-eol-date-is-approaching-act-now/

Its release roundup time here at Percona! Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download. Todays post [&]

https://www.percona.com/blog/2020/12/21/percona-distributions-for-mysql-and-postgresql-percona-xtrabackup-release-roundup-december-21-2020/

As strange as it sounds, there are types of software applications that are designed for users to NOT spend each minute of every day within the application (where the goal of so many software applications is to attract as many “eyeballs” for as long as possible to their applications). Environment monitoring software (i.e., network, database, [&]

https://www.percona.com/blog/2020/12/18/percona-monitoring-and-management-introduces-integrated-alerting-in-v2-13-via-a-technical-preview/

Hello everyone! I wanted to outline a new program we are trying out. We are calling it, Percona Open Source Expert Missions. So, you might be asking… What the heck is that?  An Expert Mission is a challenge or a contest of skill. Here at Percona, we are always looking for new ways to get [&]

https://www.percona.com/blog/2020/12/17/lets-try-something-new-percona-open-source-expert-missions/

Starting with Percona Monitoring and Management (PMM) 2.12, we use VictoriaMetrics instead of Prometheus as a metrics store.  This blog is written as an FAQ to explain our reasoning for this change as well as to provide answers to various questions on what it may mean for you. Why is Percona Monitoring and Management moving [&]

https://www.percona.com/blog/2020/12/16/percona-monitoring-and-management-migration-from-prometheus-to-victoriametrics-faq/

MySQL Shell is an advanced client tool that has many features and is easy to use. The recent MySQL release (MySQL 8.0.22) has the utility “exportTable()”, which supports exporting the data into a file from a table using MySQL shell. The exported data file can be imported using the utility “importTable()”, which was released in [&]

https://www.percona.com/blog/2020/12/16/mysql-shell-8-0-22-data-export-import-utilities-tested-with-mysql-8-5-7-5-6/

If you’re building custom dashboards for Percona Monitoring and Management (PMM), chances are you would like to use Prometheus recording rules for better performance. In the nutshell, recording rules act somewhat as materialized views in relational databases, pre-computing and storing results of complicated queries, to limit data crunching needed during dashboard load. As an example, [&]

https://www.percona.com/blog/2020/12/15/how-to-use-prometheus-recording-rules-with-percona-monitoring-and-management/

How do you install an application? Nowadays a lot of companies want to use the latest technology and more and more of them are moving infrastructure to clouds. And in order to simplify maintenance, they are using Kubernetes. But still, the vast majority use the bare metal infrastructure with Linux on board, and we will [&]

https://www.percona.com/blog/2020/12/15/the-hidden-magic-of-configuring-percona-repositories-with-a-percona-release-package/

Covid-19 has had a significant impact on most aspects of our lives in 2020. Although some companies saw unexpected growth due to offering in-demand tools or services, I think most of us will be happy to draw a line under 2020 and hope for a better 2021.  In the spirit of 2021 optimism, I have [&]

https://www.percona.com/blog/2020/12/15/matts-big-bold-open-source-predictions-for-2021/

Whichever way you installed Percona Monitoring and Management 2 (PMM2), using the docker image or an OVF image for your supported virtualized environment, PMM2 enables, by default, two ports for the web connections: 80 for HTTP and 443 for HTTPS. Using HTTPS certificates are requested for encrypting the connection for better security. All the installation [&]

https://www.percona.com/blog/2020/12/09/enabling-https-connections-to-percona-monitoring-and-management-using-custom-certificates/

Its release roundup time here at Percona! Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download. Todays post [&]

https://www.percona.com/blog/2020/12/08/victoriametrics-in-pmm-percona-server-for-mongodb-version-updates-release-roundup-december-8-2020/

As you may know, MySQL 5.6 will reach EOL (End of Life) in February 2021. This means in about two months, there will be no more updates, and more importantly, no more security fixes for discovered vulnerabilities.      You may be well ahead of the curve and have already updated to MySQL 5.7 or [&]

https://www.percona.com/blog/2020/12/07/not-ready-to-give-up-mysql-5-6-get-post-eol-support-from-percona/

Last year AWS was about to ban the “multi-cloud” term in co-branding guides for Partners, removed the ban after community and partners critique, and now embraces multi-cloud strategy. One of the products that AWS announced during its last re:Invent was Amazon EKS Distro — Kubernetes distribution based on and used by Amazon Elastic Kubernetes Service. [&]

https://www.percona.com/blog/2020/12/07/running-mongodb-on-amazon-eks-distro/

Getting MySQL working with self-signed SSL certificates is pretty simple. Having it working with a certificate signed by a trusted authority is also very simple, we just need to set the correct path and privileges to the file. The problem comes when we need to make MySQL validate the certificate signature against the authority public [&]

https://www.percona.com/blog/2020/12/04/how-to-configure-mysql-ssl-with-public-certificates/

We continue to give away exclusive Percona swag for your honest reviews about our products. Today we are glad to announce a special winter set that works for the reviews on specific products. Percona is developing three excellent products created for MongoDB database technology: Percona Server for MongoDB is a free, open-source drop-in replacement for [&]

https://www.percona.com/blog/2020/12/02/swag-for-review-special-winter-set-for-percona-mongodb-products/

The benefits of jemalloc versus glibc memory allocator for use with MySQL have been widely discussed. With jemalloc (along with Transparent Huge Pages disabled) there is less memory fragmentation, and thus more efficient resource management of the server memory. For MySQL 5.6, installing jemalloc is enough to enable it when starting the MySQL process. However, for [&]

https://www.percona.com/blog/2020/12/02/enabling-jemalloc-on-percona-server-for-mysql-5-7-and-8-0-series/

When I was in the interview process here at Percona, I was told I’d be leading the team that delivered Percona Monitoring and Management (PMM) and so naturally, I wanted to know just what that meant.  I started researching the product and I got even more excited about this opportunity because as I read, PMM [&]

https://www.percona.com/blog/2020/12/01/foiled-by-the-firewall-a-tale-of-transition-from-prometheus-to-victoriametrics/

In one of my previous blog posts, Why PostgreSQL WAL Archival is Slow, I tried to explain three of the major design limitations of PostgreSQLs WAL archiver which is not so great for a database with high WAL generation. In this post, I want to discuss how pgBackRest is addressing one of the problems (cause [&]

https://www.percona.com/blog/2020/12/01/how-pgbackrest-is-addressing-slow-postgresql-wal-archiving-using-asynchronous-feature/

How scheduler and script stand in supporting failover (Percona and Marco example)  In part one of this series,  I had illustrated how simple scenarios may fail or have problems when using Galera native support inside ProxySQL. In this post, I will repeat the same tests but using the scheduler option and the external script. The [&]

https://www.percona.com/blog/2020/11/30/support-for-percona-xtradb-cluster-in-proxysql-part-two/