Its release roundup time again 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. This [&]

https://www.percona.com/blog/2021/07/05/percona-distribution-for-mongodb-operator-1-9-updated-percona-distribution-for-postgresql-release-roundup-july-5-2021/

MySQL 8 brought many highly anticipated features, with support for user roles, a new shell, a more robust data dictionary, and better SQL support, just to name a few. There are lesser-known new features, however, that aim to reduce overall DBA workload and streamline management processes – and one of these is support for dual [&]

https://www.percona.com/blog/using-mysql-8-dual-passwords/

With the CentOS project switching its focus to CentOS Stream, one of the alternatives that aim to function as a downstream build (building and releasing packages after theyre released by Red Hat) is Rocky Linux. This how-to shows how to install Percona Server for MySQL 8.0 on the Rocky Linux distribution. You can get the [&]

https://www.percona.com/blog/installing-percona-server-for-mysql-on-rocky-linux-8/

Some of you may use MySQLs asynchronous replication feature called Semisynchronous Replication (aka semi-sync), and now with the MySQL Semi-Sync Summary Dashboard + Percona Monitoring and Management (PMM), you can see the most important metrics! Refer to the Install & Usage steps for deployment details (note you need Replication Set defined!). What is Semisynchronous Replication [&]

https://www.percona.com/blog/percona-monitoring-and-management-mysql-semi-sync-summary-dashboard/

The Problem I recently worked on a customer engagement where the customer needed to archive a high amount of rows from different tables into another server (in this example for simplicity I am just archiving the results into a file).  As explained in this other blog post, Want to archive tables? Use Percona Toolkit’s pt-archiver, [&]

https://www.percona.com/blog/complex-archival-with-percona-toolkits-pt-archiver/

In every new version of MongoDB, there have been a lot of changes and newly introduced features. One such change is the introduction of setDefaultRWConcern command from MongoDB 4.4. This feature has caused multi-document transaction writes to fail for one of my customers. In this blog post, we will look into the problem and how [&]

https://www.percona.com/blog/2021/06/30/mongodb-multi-document-transaction-fails-when-getlasterrordefaults-is-changed/

Here 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, report back on any issues or bugs you [&]

https://www.percona.com/blog/2021/06/30/percona-monthly-bug-report-june-2021/

PgBouncer is a great piece of technology! Over the years Ive put it to good use in any number of situations requiring a particular type of control over application processes connecting to a postgres data cluster. However, sometimes its been a bit of a challenge when it comes to configuration. Today, I want to demonstrate [&]

https://www.percona.com/blog/2021/06/28/enabling-ssl-tls-sessions-in-pgbouncer/

Dont Try This at Home! Disclaimer: The procedure described in this blog post is not officially supported by Percona XtraBackup. Use it under your responsibility. I tested and used it successfully, but your mileage may vary. Note from the author: Wikipedia defines clickbait as text (or a link) that is designed to attract attention and [&]

https://www.percona.com/blog/2021/06/25/percona-xtrabackup-for-windows/

This article continues on from Part 1: Building wt and  Part 2: wt dump to show how to extract any of your MongoDB documents directly from WiredTigers raw data files. Itll also show how to take a peek into the index files. Lastly, itll show how to also look in the WT transaction log to [&]

https://www.percona.com/blog/2021/06/22/wiredtiger-file-forensics-part-3-viewing-all-the-mongodb-data/

In just under a month, MongoDB will host its annual event, MongoDB.live. And just over a month ago, Percona held its annual event Percona Live.  Despite the naming convention similarity, these events couldn’t be more different! Percona Live was an open source database software community event with 196 speakers and over 200 presentations. We platformed [&]

https://www.percona.com/blog/2021/06/21/discover-why-mongodb-runs-better-with-percona/

Its release roundup time again 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. This [&]

https://www.percona.com/blog/2021/06/21/updated-percona-distribution-for-postgresql-versions-percona-distribution-for-mysql-8-0-23-release-roundup-june-21-2021/

Starting with the release of proxysql-admin 2.0.15,  the proxysql-admin 2.x series can now encrypt the credentials needed to access proxysql and cluster nodes. This only applies to the proxysql-admin configuration, this does not change the ProxySQL config, so those credentials are still unencrypted. The credentials file is the unencrypted file containing the usernames, passwords, hostnames, [&]

https://www.percona.com/blog/2021/06/18/proxysql-admin-2-x-encryption-of-credential-information/

In my talk at Percona Live 2021, “Creating Chaos in Databases”, I discussed how creating a controlled interruption in available resources (I used primary pod and network interruptions) allows us to test the stability of a database, and in our case, Percona XtraDB Cluster. I also mentioned in the talk that my testing led to diagnosing [&]

https://www.percona.com/blog/2021/06/17/chaos-testing-leads-to-more-stable-percona-xtradb-cluster/

Join Percona experts Michal Nosek and Dimitri Vanoverbeke as they walk through the task of migrating a MongoDB database to Percona Server for MongoDB (PSMDB). BY THE END OF THIS HANDS-ON WORKSHOP YOU WILL BE ABLE TO:  Uninstall MongoDB and install Percona Server for MongoDB  Convert a stand-alone MongoDB server to Percona Server [&]

https://www.percona.com/blog/2021/06/15/webinar-july-6-converting-mongodb-to-percona-server-for-mongodb/