by Ivan Groenewold | 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... by Ivan Groenewold | Jan 9, 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... by Ivan Groenewold | Apr 3, 2023 | Insight for DBAs, MongoDB
by Ivan Groenewold | Aug 2, 2022 | Insight for DBAs, MongoDB
by Ivan Groenewold | Feb 16, 2022 | Insight for DBAs, MongoDB, Monitoring, Percona Software
by Ivan Groenewold | Feb 7, 2022 | Insight for DBAs, MongoDB
by Ivan Groenewold | 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... by Ivan Groenewold | Oct 7, 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... by Ivan Groenewold | 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... by Ivan Groenewold | Sep 10, 2021 | Insight for DBAs, MongoDB
by Ivan Groenewold | Jul 8, 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... by Ivan Groenewold | 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... by Ivan Groenewold | Jun 1, 2021 | Cloud, Insight for DBAs, MongoDB
by Ivan Groenewold | Jan 28, 2021 | Cloud, MySQL, ProxySQL
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... by Ivan Groenewold | Dec 21, 2020 | Cloud, Insight for DBAs, MySQL, Percona Services
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... by Ivan Groenewold | Nov 10, 2020 | Insight for DBAs, MongoDB, Percona Software
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... by Ivan Groenewold | Nov 5, 2020 | MongoDB, Monitoring, MySQL, Percona Software, PostgreSQL
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... by Ivan Groenewold | Aug 26, 2020 | Cloud, Insight for DBAs, MySQL
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 Ivan Groenewold | Aug 20, 2020 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
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... by Ivan Groenewold | May 27, 2020 | Cloud, Insight for DBAs, MongoDB
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...