Incremental backups of MySQL, specifically for the InnoDB engine, are taken by copying modified pages from the previous backup. The brute force method takes backups by scanning every page in tablespace file in the server data directory is an expensive operation. The time required for incremental backups increases as the data-dir size increases. To solve this [&]

https://www.percona.com/blog/incremental-backup-in-mysql-using-page-tracking/

It is essential to upgrade MySQL to the most recent version. Do you believe it’s tough to test and upgrade to a newer version? For a variety of reasons, including new features, performance advantages, bug corrections, and so on, databases with obsolete versions are vulnerable. Major version upgrades, on the other hand, can be problematic [&]

https://www.percona.com/blog/percona-utilities-that-make-major-mysql-version-upgrades-easier/

The PostgreSQL RDBMS has shown rapid growth in terms of adoption and usability for a wide range of industries and projects. The same is true as for the new methodologies for application development and deployment, which currently focuses on making it easier for developers to get the infrastructure and the DB model they need with [&]

https://www.percona.com/blog/postgresql-14-predefined-roles-making-access-control-easy/

Percona XtraBackup delivers the xbcloud binary – an auxiliary tool to allow users to upload backups to different cloud providers directly. Today we are glad to announce the support of the Azure Blob storage to xbcloud. This new feature will allow you to upload/download backups to Azure Blob storage. You would need an Azure storage [&]

https://www.percona.com/blog/introducing-xbcloud-azure-blob-storage-support-in-percona-xtrabackup/

I recently wrote about one of the problems we can encounter while working with sharded clusters, which is Finding Undetected Jumbo Chunks in MongoDB. Another issue that we might run into is dealing with empty chunk management. Chunk Maintenance As we know, there is also an autoSplitter process that partitions chunks when they become too [&]

https://www.percona.com/blog/merging-empty-chunks-in-mongodb/

Its time for the release roundup! Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers [&]

https://www.percona.com/blog/release-roundup-february-7-2022/

Percona XtraDB Cluster (PXC) offers a great deal of flexibility when it comes to the state transfer (SST) options (used when a new node is automatically provisioned with data). For many environments, on-the-fly compression capability gives great benefits of saving network bandwidth during the process of sending sometimes terabytes of data. The usual choice for [&]

https://www.percona.com/blog/optimize-sst-in-percona-xtradb-cluster-with-zstd-compression/

Id like to introduce to you a very cool feature introduced in PostgreSQL, the Pipeline Mode. So just what exactly is Pipeline Mode? Pipeline Mode allows applications to send a query without having to read the result of the previously sent query. In short, it provides a significant performance boost by allowing multiple queries and [&]

https://www.percona.com/blog/how-postgresql-pipeline-mode-works/

Operators are a software framework that extends Kubernetes API and enables application deployment and management through the control plane. For such complex technologies as databases, Operators play a crucial role by automating deployment and day-to-day operations. At Percona we have the following production-ready and enterprise-grade Kubernetes Operators for databases: Percona Distribution for MySQL Operator Leverage [&]

https://www.percona.com/blog/percona-distribution-for-mysql-operator-based-on-percona-server-for-mysql-alpha-release/

Managing database users and their passwords can be a hassle. Sometimes, they could even wait in various configuration files, hardcoded. Using certificates can help you avoid the toil of managing, rotating, and securing user passwords, so lets see how to have x509 certificate authentication with the Percona Server for MongoDB Operator and cert-manager. cert-manager is [&]

https://www.percona.com/blog/authenticating-your-clients-to-mongodb-on-kubernetes-using-x509-certificates/

Recently, a few PostgreSQL users reported that they got connection failures after switching to PostgreSQL 14. Why do I get the error FATAL:  password authentication failed for a user in the new server? has become one of the most intriguing questions. At least in one case, it was a bit of a surprise that the [&]

https://www.percona.com/blog/postgresql-14-and-recent-scram-authentication-changes-should-i-migrate-to-scram/

Automating the deployment and management of MongoDB on Kubernetes is an easy journey with Percona Operator. By default, MongoDB is deployed using persistent volume claims (PVC). In the cases where you seek exceptional performance or you don’t have any external block storage, it is also possible to use local storage. Usually, it makes sense to [&]

https://www.percona.com/blog/percona-distribution-for-mongodb-operator-with-local-storage-and-openebs/

Its time for the release roundup! Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers [&]

https://www.percona.com/blog/release-roundup-january-24-2022/

Backups are a key part of a disaster recovery strategy, making sure you can continue or restore your business in case of an unwanted event with your data. We always work on trying to improve Percona XtraBackup reliability, always favoring consistency, attempting to make unwanted outcomes be noticed as earlier as possible in the process. [&]

https://www.percona.com/blog/percona-xtrabackup-changing-to-strict-by-default/

The most common issue when using row-based replication (RBR) is replication lag due to the lack of Primary keys. The problem is that any replicated DML will do a full table scan for each modified row on the replica. This bug report explains it more in-depth: https://bugs.mysql.com/bug.php?id=53375 For example, if a delete is executed on [&]

https://www.percona.com/blog/attack-no-pk-replication-lag-with-mysql-percona-server-8-invisible-columns/

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 part). In the second part, we compared compute-optimized EC2 instances with [&]

https://www.percona.com/blog/comparing-graviton-arm-performance-to-intel-and-amd-for-mysql-part-3/

Install a database server. Give the application team an endpoint. Set up backups and monitor in perpetuity. This is a pattern I hear about regularly from DBAs with most of my enterprise clients. Rarely do they get to troubleshoot or work with application teams to tune queries or design schemas. This is what triggers the [&]

https://www.percona.com/blog/dbaas-and-the-enterprise/

Hello everyone!  The new year is upon us and we are looking at planning some awesome new features, enhancements, and ideas in 2022.  One of the things we could really use your help on, however, is providing us with feedback on how we are doing and what we can do to improve our database products.  [&]

https://www.percona.com/blog/help-percona-make-better-databases/

Failover of the logical replication slot has always been the pain point while using the logical replication in PostgreSQL. This lack of feature undermined the use of logical replication and acted as one of the biggest deterrents. The stake and impact were so high that many organizations had to discard their plans around logical replication, [&]

https://www.percona.com/blog/how-patroni-addresses-the-problem-of-the-logical-replication-slot-failover-in-a-postgresql-cluster/

A customer recently asked if our Percona Distribution for PostgreSQL Operator supports the deployment of a standby cluster, which they need as part of their Disaster Recovery (DR) strategy. The answer is yes  as long as you are making use of an object storage system for backups, such as AWS S3 or GCP Cloud [&]

https://www.percona.com/blog/creating-a-standby-cluster-with-the-percona-distribution-for-postgresql-operator/