Fri, 26 Apr 2024 15:53:49 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/performance-implications-of-running-databases-in-kubernetes/ https://www.percona.com/blog/performance-implications-of-running-databases-in-kubernetes/#respond Fri, 26 Apr 2024 12:46:44 +0000 https://www.percona.com/blog/?p=96016 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 for […]]]> https://www.percona.com/blog/performance-implications-of-running-databases-in-kubernetes/feed/ 0 96016 https://www.percona.com/blog/how-to-use-group-replication-with-haproxy/ https://www.percona.com/blog/how-to-use-group-replication-with-haproxy/#respond Tue, 09 Jan 2024 14:54:23 +0000 https://www.percona.com/blog/?p=93223 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 Haproxy […]]]> https://www.percona.com/blog/how-to-use-group-replication-with-haproxy/feed/ 0 93223 https://www.percona.com/blog/dealing-with-chunks-that-lost-weight-in-mongodb/ https://www.percona.com/blog/dealing-with-chunks-that-lost-weight-in-mongodb/#respond Mon, 03 Apr 2023 13:03:06 +0000 https://www.percona.com/blog/?p=86573  The life of a jumbo chunkMongoDB 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 way to split […]]]> https://www.percona.com/blog/dealing-with-chunks-that-lost-weight-in-mongodb/feed/ 0 86573 https://www.percona.com/blog/tales-from-the-mongodb-field-when-stepdown-goes-wrong/ https://www.percona.com/blog/tales-from-the-mongodb-field-when-stepdown-goes-wrong/#respond Tue, 02 Aug 2022 12:18:07 +0000 https://www.percona.com/blog/?p=81869 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 scenarioWe 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 is that […]]]> https://www.percona.com/blog/tales-from-the-mongodb-field-when-stepdown-goes-wrong/feed/ 0 81869 https://www.percona.com/blog/monitoring-mongodb-collection-stats-with-percona-monitoring-and-management/ https://www.percona.com/blog/monitoring-mongodb-collection-stats-with-percona-monitoring-and-management/#respond Wed, 16 Feb 2022 14:51:03 +0000 https://www.percona.com/blog/?p=80156 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: [crayon-664c7bf60933f784796863/] In the […]]]> https://www.percona.com/blog/monitoring-mongodb-collection-stats-with-percona-monitoring-and-management/feed/ 0 80156 https://www.percona.com/blog/merging-empty-chunks-in-mongodb/ https://www.percona.com/blog/merging-empty-chunks-in-mongodb/#respond Mon, 07 Feb 2022 15:52:40 +0000 https://www.percona.com/blog/?p=79868 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 MaintenanceAs we know, there is also an autoSplitter process that partitions chunks when they become too big. There […]]]> https://www.percona.com/blog/merging-empty-chunks-in-mongodb/feed/ 0 79868 https://www.percona.com/blog/querying-archived-rds-data-directly-from-an-s3-bucket/ https://www.percona.com/blog/querying-archived-rds-data-directly-from-an-s3-bucket/#respond Wed, 24 Nov 2021 13:45:53 +0000 https://www.percona.com/blog/?p=79038 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 query […]]]> https://www.percona.com/blog/querying-archived-rds-data-directly-from-an-s3-bucket/feed/ 0 79038 https://www.percona.com/blog/getting-started-with-proxysql-in-kubernetes/ https://www.percona.com/blog/getting-started-with-proxysql-in-kubernetes/#comments Thu, 07 Oct 2021 12:21:17 +0000 https://www.percona.com/blog/?p=78357 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 pods. […]]]> https://www.percona.com/blog/getting-started-with-proxysql-in-kubernetes/feed/ 2 78357 https://www.percona.com/blog/modern-web-based-application-architecture-101/ https://www.percona.com/blog/modern-web-based-application-architecture-101/#comments Wed, 22 Sep 2021 11:59:59 +0000 https://www.percona.com/blog/?p=78201 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 MicroservicesWith the rise of containerization and […]]]> https://www.percona.com/blog/modern-web-based-application-architecture-101/feed/ 2 78201 https://www.percona.com/blog/finding-undetected-jumbo-chunks-in-mongodb/ https://www.percona.com/blog/finding-undetected-jumbo-chunks-in-mongodb/#respond Fri, 10 Sep 2021 12:02:29 +0000 https://www.percona.com/blog/?p=78021 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 most […]]]> https://www.percona.com/blog/finding-undetected-jumbo-chunks-in-mongodb/feed/ 0 78021 https://www.percona.com/blog/authenticate-percona-server-for-mongodb-users-via-native-ldap/ https://www.percona.com/blog/authenticate-percona-server-for-mongodb-users-via-native-ldap/#respond Thu, 08 Jul 2021 13:35:08 +0000 https://www.percona.com/blog/?p=76902 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 considering […]]]> https://www.percona.com/blog/authenticate-percona-server-for-mongodb-users-via-native-ldap/feed/ 0 76902 https://www.percona.com/blog/mongodb-integrated-alerting-in-percona-monitoring-and-management/ https://www.percona.com/blog/mongodb-integrated-alerting-in-percona-monitoring-and-management/#comments Mon, 14 Jun 2021 15:42:49 +0000 https://www.percona.com/blog/?p=76563 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 to […]]]> https://www.percona.com/blog/mongodb-integrated-alerting-in-percona-monitoring-and-management/feed/ 1 76563 https://www.percona.com/blog/how-to-generate-an-ansible-inventory-with-terraform/ https://www.percona.com/blog/how-to-generate-an-ansible-inventory-with-terraform/#respond Tue, 01 Jun 2021 17:08:10 +0000 https://www.percona.com/blog/?p=76313 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. In […]]]> https://www.percona.com/blog/how-to-generate-an-ansible-inventory-with-terraform/feed/ 0 76313 https://www.percona.com/blog/load-balancing-proxysql-in-aws/ https://www.percona.com/blog/load-balancing-proxysql-in-aws/#comments Thu, 28 Jan 2021 15:32:16 +0000 https://www.percona.com/blog/?p=74004 There are several ways to deploy ProxySQL between your applications and the database servers. A common approach is to have a floating virtual IP (VIP) managed by keepalived as the application endpoint. The proxies have to be strategically provisioned to improve the resiliency of the solution (different hardware, network segments, etc,).When we consider cloud environments, […]]]> https://www.percona.com/blog/load-balancing-proxysql-in-aws/feed/ 4 74004 https://www.percona.com/blog/amazon-rds-for-mysql-5-5-eol-date-is-approaching-act-now/ Mon, 21 Dec 2020 16:35:23 +0000 https://www.percona.com/blog/?p=73056 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 don’t […]]]> 73056 https://www.percona.com/blog/restore-a-replica-set-to-a-new-environment-with-percona-backup-for-mongodb/ Tue, 10 Nov 2020 16:07:49 +0000 https://www.percona.com/blog/?p=72570 Percona Backup for MongoDB (PBM) is our open source tool for backing up MongoDB clusters. Initially, the tool was developed for restoring the backups in the same environment they are taken. In this post, I will show you how to restore a backup to a new environment instead.Let’s assume you followed the instructions to install […]]]> 72570 https://www.percona.com/blog/deploying-percona-monitoring-and-management-2-without-access-to-the-internet/ Thu, 05 Nov 2020 19:12:42 +0000 https://www.percona.com/blog/?p=72472 Normally it is quite easy to deploy Percona Monitoring and Management (PMM) Server as a Docker container as per the official documentation. However, when working in very restrictive environments, it is possible the server doesn’t have access to the public Internet, so pulling the image from the Docker hub is not possible. Fortunately, there are a […]]]> 72472 https://www.percona.com/blog/creating-an-external-replica-of-aws-aurora-mysql-with-mydumper/ https://www.percona.com/blog/creating-an-external-replica-of-aws-aurora-mysql-with-mydumper/#comments Wed, 26 Aug 2020 18:31:41 +0000 https://www.percona.com/blog/?p=70549 Oftentimes, we need to replicate between Amazon Aurora and an external MySQL server. The idea is to start by taking a point-in-time copy of the dataset. Next, we can configure MySQL replication to roll it forward and keep the data up-to-date.This process is documented by Amazon, however, it relies on the mysqldump method to create […]]]> https://www.percona.com/blog/creating-an-external-replica-of-aws-aurora-mysql-with-mydumper/feed/ 1 70549 https://www.percona.com/blog/streaming-percona-xtrabackup-for-mysql-to-multiple-destinations/ https://www.percona.com/blog/streaming-percona-xtrabackup-for-mysql-to-multiple-destinations/#comments Thu, 20 Aug 2020 14:01:18 +0000 https://www.percona.com/blog/?p=70713 Have you ever had to provision a large number of instances from a single backup? The most common use case is having to move to new hardware, but there are other scenarios as well. This kind of procedure can involve multiple backup/restore operations which can easily become a pain to administer. Let’s look at a […]]]> https://www.percona.com/blog/streaming-percona-xtrabackup-for-mysql-to-multiple-destinations/feed/ 1 70713 https://www.percona.com/blog/migrating-from-dynamodb-into-mongodb/ Wed, 27 May 2020 18:30:57 +0000 https://www.percona.com/blog/?p=67820 Say you need to move from DynamoDB to MongoDB; what options do you have? Unfortunately, at the time of this writing, there are no available tools to do this easily.In this post, we will explore the available options and discuss some of the potential issues and solutions.Deciding on the ApproachA tutorial on the AWS site […]]]> 67820