Foreign Data Wrapper based on SQL-MED is one the coolest features of PostgreSQL. The feature set of foreign data wrapper is expanding since version 9.1. We know that the PostgreSQL 14 beta is out and GA will be available shortly, therefore it is helpful to study the upcoming features of PostgreSQL 14. There are a [&]

https://www.percona.com/blog/2021/05/27/new-features-in-postgresql-14-bulk-inserts-for-foreign-data-wrappers/

Recently we had a debate in the consulting team about how InnoDB handles TEXT/BLOB columns. More specifically, the argument was around the Barracuda file format with dynamic rows. In the InnoDB official documentation, you can find this extract: When a table is created with ROW_FORMAT=DYNAMIC, InnoDB can store long variable-length column values (for VARCHAR, VARBINARY, [&]

https://www.percona.com/blog/2021/05/27/how-innodb-handles-text-blob-columns/

Do You Know How to Choose the Right MongoDB Shard Key for Your Business? In our upcoming panel, Percona MongoDB experts Mike Grayson, Kimberly Wilkins, and Vinicius Grippa will discuss the complex issue of MongoDB shard key selection and offer advice on the measures to take if things go wrong. Selecting the right shard key [&]

https://www.percona.com/blog/2021/05/27/webinar-june-29-unlocking-the-mystery-of-mongodb-shard-key-selection/

In this follow-up blog to Compiling a Percona Monitoring and Management v2 Client in ARM Architecture, we will show what changes are needed to get the latest versions of PMM working on ARM architecture. In this case, we will do it using a Raspberry Pi 3, instead of the AWS EC2 ARM node. With these [&]

https://www.percona.com/blog/2021/05/26/compiling-a-percona-monitoring-and-management-v2-client-in-arm-raspberry-pi-3/

Percona is championing open source database software and we are committed to running our products on Kubernetes. We don’t only want to run the software, but make sure that the database is highly available, secure, and follows best practices. We also focus on day-2 operations such as scaling, backup and restore, disaster recovery, and customization. [&]

https://www.percona.com/blog/2021/05/26/percona-distribution-for-postgresql-operator-technical-preview-released/

Its your busiest day of the year and the website has crawled to a halt and finally crashed& and it was all because you did not understand how MongoDB uses memory and left your system open to cluster instability, poor performance, and unpredictable behavior. Understanding how MongoDB uses memory and planning for its use can [&]

https://www.percona.com/blog/2021/05/24/mongodb-tuning-anti-patterns-how-tuning-memory-can-make-things-much-worse/

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/05/24/new-percona-distribution-for-postgresql-versions-percona-server-for-mysql-8-0-23-14-release-roundup-may-24-2021/

Back in December 2018, when we announced the general availability of Percona Server for MySQL 8.0, we also announced that the TokuDB Storage Engine has been marked as “deprecated” in this release, recommending to use the MyRocks Storage Engine as an alternative. We believe that MyRocks provides similar benefits for the majority of workloads and [&]

https://www.percona.com/blog/2021/05/21/tokudb-support-changes-and-future-removal-from-percona-server-for-mysql-8-0/

Quite a common request that we receive from the community and customers is to provide a way to manage database users with Operators  both MongoDB and MySQL. Even though we see it as an interesting task, our Operators are mainly a tool to simplify the deployment and management of our software on Kubernetes. Our [&]

https://www.percona.com/blog/2021/05/20/manage-mysql-users-with-kubernetes/

Percona Server for MySQL 8.0.23-14 was released last week and I wanted to take a minute to call out some of the interesting new features that we have introduced in this release. These are included in addition to the features and improvements in MySQL 8.0.23 that were introduced by the Oracle MySQL team (and to [&]

https://www.percona.com/blog/2021/05/20/new-features-in-percona-server-for-mysql-8-0-23-14/

Database-as-a-Service (DBaaS) is a managed database that doesnt need to be installed and maintained but is instead provided as a service to the user. The Percona Monitoring and Management (PMM) DBaaS component allows users to CRUD (Create, Read, Update, Delete) Percona XtraDB Cluster (PXC) and Percona Server for MongoDB (PSMDB) managed databases in Kubernetes clusters. [&]

https://www.percona.com/blog/2021/05/19/percona-monitoring-and-management-dbaas-overview-and-technical-details/

This is a very straightforward article written with the intention to show you how easy it is to refresh your Test/Dev environments with PROD data, using Percona Backup for MongoDB (PBM). This article will cover all the steps from the PBM configuration until the restore, assuming that the PBM agents are all up and running [&]

https://www.percona.com/blog/2021/05/19/refreshing-test-dev-environments-with-prod-data-using-percona-backup-for-mongodb/

Our recent releases of Percona XtraDB Cluster Operator 1.8 and Percona Server for MongoDB Operator 1.7 come with a new interesting feature: Support of custom sidecars. What is special about this? There is often a need to customize the default installation, for example, one popular request is to support your favorite monitoring system, which is [&]

https://www.percona.com/blog/2021/05/19/using-sidecars-with-percona-kubernetes-operators/

This article contains one normal section  how to print information directly from the raw WiredTiger files using wt dump  followed by really important, otherwise undocumented information about how to get to the MongoDB binary data inside WT tables. See WiredTiger File Forensics (Part 1: Building wt) for: How to build the wt utility [&]

https://www.percona.com/blog/2021/05/18/wiredtiger-file-forensics-part-2-wt-dump/

Most of the files in a data directory of a MongoDB server are made by the WiredTiger storage engine. If you want to look at the content inside them you can use the tool wt from the WiredTiger library: https://github.com/wiredtiger/wiredtiger/ http://source.wiredtiger.com/10.0.0/command_line.html Inspection of the WiredTiger files is not an essential MongoDB DBA skill  its [&]

https://www.percona.com/blog/2021/05/18/wiredtiger-file-forensics-part-1-building-wt/

Percona Backup for MongoDB (PBM) has reached a new step with the release of version 1.5.0 today, May 13th, 2021. Azure Blob Storage Support Now you can use Azure Blob Storage as well as S3-compatible object stores. Configuration example: [crayon-60a0ec8bc13da545962337/] Preference Weight for Backup Source Nodes Until now PBM would use a secondary as a [&]

https://www.percona.com/blog/2021/05/13/percona-backup-for-mongodb-v1-5-released/

A survey of 200 IT decision-makers from medium to large enterprises was conducted in Q1 of 2021 by Vanson Bourne and sponsored by Percona in advance of Percona Live ONLINE 2021, which started today!  Percona Live Online represents dozens of projects, communities, and tech companies, and features more than 150 expert speakers across 200 sessions. [&]

https://www.percona.com/blog/2021/05/12/new-survey-shows-enterprises-increasing-their-reliance-on-open-source-software/

Percona Live ONLINE 2021 starts today!   Representing dozens of projects, communities, and tech companies, and featuring more than 150 expert speakers across 200 sessions, there’s still time to register and attend.  Register and Attend Percona latest product announcements focus on Percona’s open source DBaaS preview, and new Percona Kubernetes Operators features. During Percona Live ONLINE [&]

https://www.percona.com/blog/2021/05/12/percona-live-online-percona-previews-open-source-database-as-a-service/

Running MongoDB in Kubernetes with Percona Operator is not only simple but also by design provides a highly available MongoDB cluster suitable for mission-critical applications. In the latest 1.8.0 version, we add a feature that implements Point-in-time recovery (PITR). It allows users to store Oplog on an external S3 bucket and to perform recovery to [&]

https://www.percona.com/blog/2021/05/10/point-in-time-recovery-for-mongodb-on-kubernetes/

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. Todays [&]

https://www.percona.com/blog/2021/05/10/new-extensions-in-percona-distribution-for-postgresql-updated-percona-kubernetes-operators-release-roundup-may-10-2021/