Dec 17, 2024 | Insight for DBAs, MongoDB, Percona Announcements, Percona Software
MongoDB Community Edition 8.0 has been available since October. At Percona, we took the time to examine this release carefully, check performance, and guarantee it works perfectly, stand-alone, and with other tools like Percona Backup for MongoDB and Percona Monitoring and Management. Today, we are excited to announce the General Availability of Percona Server for […]
Oct 30, 2024 | Cloud, Insight for DBAs, MongoDB, Percona Software
Percona Backup for MongoDB (PBM) supports snapshot-based physical backups. This is made possible by the backup cursor functionality present in Percona Server for MongoDB. In a previous post, we discussed Percona Backup for MongoDB and Disk Snapshots in Amazon AWS and showed how to implement EBS snapshot-based backups. Now, let’s see how to restore a snapshot-based backup […]
Oct 21, 2024 | Cloud, Insight for DBAs, MongoDB
We recently covered the use case of Percona Backup for MongoDB and Disk Snapshots in Google Cloud Platform; now it’s time to do the same for Amazon AWS. For this demo, I have created a 2-shard MongoDB cluster (where each shard is a 3-node PSA Replica Set) deployed on EC2 instances. Each instance has an extra […]
Oct 15, 2024 | Cloud, Insight for DBAs, MongoDB
Percona Backup for MongoDB (PBM) supports snapshot-based physical backups. This is made possible by the backup cursor functionality present in Percona Server for MongoDB. In a previous post, we discussed Percona Backup for MongoDB and Disk Snapshots in Google Cloud Platform (part 1) and showed how to implement snapshot-based backups. Now, let’s see how to restore a […]
Oct 02, 2024 | Cloud, Insight for DBAs, MongoDB, Percona Software
Percona Backup for MongoDB (PBM) supports snapshot-based physical backups. This is made possible by the backup cursor functionality present in Percona Server for MongoDB. The flow of snapshot-based physical backup consists of these stages: Preparing the database – done by PBM Taking the snapshots – done by the user/client app Completing the backup – done […]
Sep 26, 2024 | Insight for DBAs, MongoDB
Recently, one of our customers reported a problem after upgrading a sharded cluster from MongoDB 5.0 to 6.0. The upgrade of data-bearing nodes was fine, but in the final part of the process, where mongos routers needed to be restarted, the new version did not go well. This caused problems for the applications, where suddenly […]
Jul 10, 2024 | Cloud, MongoDB, Percona Software
Percona Everest is the first open source platform designed for automated database provisioning and management. It supports multiple database technologies and can be hosted on any Kubernetes infrastructure, in the cloud or on-premises. It provides an easy-to-use web interface while leveraging the power of the Percona Operators behind the scenes to do all the heavy […]
Apr 26, 2024 | Cloud, Insight for DBAs, MongoDB, Percona Software
Cloud-native databases are becoming the norm, and containerized databases are a common trend (see the report from Dynatrace and Figure 1). Kubernetes—the de facto standard for platform engineers—and operators simplify database deployment and management. But what are the performance implications of running databases in Kubernetes? To answer this question, we compared the performance of Percona Server […]
Jan 09, 2024 | Insight for DBAs, MySQL, Open Source
When working with group replication, MySQL router would be the obvious choice for the connection layer. It is tightly coupled with the rest of the technologies since it is part of the InnoDB cluster stack. The problem is that except for simple workloads, MySQL router’s performance is still not on par with other proxies like […]
Apr 03, 2023 | Insight for DBAs, MongoDB
The life of a jumbo chunk MongoDB marks a chunk as “jumbo” when it grows past the configured maximum chunk size. This value defaults to 128 MB since MongoDB 6.0 (it used to be 64 MB before). The most common reason for jumbo chunks to appear is when the auto-splitter process cannot find a […]
Aug 02, 2022 | Insight for DBAs, MongoDB
We get to see and troubleshoot a lot of different problems at Percona. Here’s the latest one that got me scratching my head for a while recently. The scenario We have a sharded cluster environment running MongoDB 4.0 that needs to be upgraded to MongoDB 4.2. Easy right? The only thing particular about this environment […]
Feb 16, 2022 | Insight for DBAs, MongoDB, Monitoring, Percona Software
One approach to get to know a MongoDB system we are not familiar with is to start by checking the busiest collections. MongoDB provides the top administrative command for this purpose. From the mongo shell, we can run db.adminCommand(“top”) to get a snapshot of all the collections at a specific point in time:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 | ... "test.testcol" : { "total" : { "time" : 17432, "count" : 58 }, "readLock" : { "time" : 358, "count" : 57 }, "writeLock" : { "time" : 17074, "count" : 1 }, "queries" : { "time" : 100, "count" : 1 }, "getmore" : { "time" : 0, "count" : 0 }, "insert" : { "time" : 17074, "count" : 1 }, "update" : { "time" : 0, "count" : 0 }, "remove" : { "time" : 0, "count" : 0 }, "commands" : { "time" : 0, "count" : 0 } } ... |
In […]
Feb 07, 2022 | Insight for DBAs, MongoDB
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 […]
Nov 24, 2021 | Cloud, Insight for DBAs, MySQL
A recommendation we often give to our customers is along the lines of “archive old data” to reduce your database size. There is a tradeoff between keeping all our data online and archiving part of it to cold storage. There could also be legal requirements to keep certain data online, or you might want to […]
Oct 07, 2021 | Cloud, MySQL, Percona Software, ProxySQL
There are plenty of ways to run ProxySQL in Kubernetes (K8S). For example, we can deploy sidecar containers on the application pods, or run a dedicated ProxySQL service with its own pods. We are going to discuss the latter approach, which is more likely to be used when dealing with a large number of application […]
Sep 22, 2021 | Cloud, Database Trends, Insight for DBAs, Open Source
This article is meant to provide a high-level overview of how a web-based application is commonly structured nowadays. Keep in mind the topic presented is very simplified. It is meant as an introduction only and hopefully encourages the reader to investigate some of the concepts in more depth. Monolith vs Microservices With the rise of […]
Sep 10, 2021 | Insight for DBAs, MongoDB
I recently came across an interesting case of performance issues during balancing in a MongoDB cluster. Digging through the logs, it became clear the problem was related to chunk moves taking a long time. As we know, the default maximum chunk size is 64 MB. So these migrations are supposed to be very fast in […]
Jul 08, 2021 | Insight for DBAs, MongoDB, Percona Software, Security
Percona Server for MongoDB supports two different ways of authenticating against an LDAP service: operating system libraries (aka Native LDAP) saslauthd (aka LDAP proxy) We’ve talked about the LDAP proxy option many times already. In this post, I am going to discuss the Native LDAP approach. Note: for the purposes of the examples, I am […]
Jun 14, 2021 | MongoDB, Monitoring, Percona Software
Percona Monitoring and Management (PMM) recently introduced the Integrated Alerting feature as a technical preview. This was a very eagerly awaited feature, as PMM doesn’t need to integrate with an external alerting system anymore. Recently we blogged about the release of this feature. PMM includes some built-in templates, and in this post, I am going […]
Jun 01, 2021 | Cloud, Insight for DBAs, MongoDB
Creating and maintaining an inventory file is one of the common tasks we have to deal with when working with Ansible. When dealing with a large number of hosts, it can be complex to handle this task manually. There are some plugins available to automatically generate inventory files by interacting with most cloud providers’ APIs. […]