Author - Jervin Real

ZFS For MongoDB Backups

mongodb backup using zfs

We have successfully used ZFS for MySQL® backups and MongoDB® is no different. Normally, backups will be taken from a hidden secondary, either with
mongodump , WT hot backup or filesystem snapshots. In the case of the latter, instead of LVM2, we will use ZFS and discuss potential other benefits.
Preparation for initial snapshot
Before taking a […]

Read more

Load Balanced ProxySQL in Google Cloud

GCP ProxySQL LB

There are three different ways ProxySQL can direct traffic between your application and the backend MySQL services.

Locally, on the MySQL servers.
Between the MySQL servers and the application.
Colocated on the application servers themselves.

Without going through too much detail – each has its own limitations. In the first form, the application needs to know about all […]

Read more

Simple STONITH with ProxySQL and Orchestrator

3 DC Orchestrator ProxySQL

Distributed systems are hard – I just want to echo that. In MySQL, we have quite a number of options to run highly available systems. However, real fault tolerant systems are difficult to achieve.
Take for example a common use case of multi-DC replication where Orchestrator is responsible for managing the topology, while ProxySQL takes […]

Read more

Setup Compatible OpenLDAP Server for MongoDB and MySQL

Set up LDAP authentication for MySQL and MongoDB

By the end of this article, you should be able to have a Percona Server for MongoDB and Percona Server for MySQL instance able to authenticate on an OpenLDAP backend. While this is mostly aimed at testing scenarios, it can be easily extended for production by following the OpenLDAP production best practices i.e. attending […]

Read more

Identifying Unused Indexes in MongoDB

mongodb index usage stats PMM visualization

Like MySQL, having too many indexes on a MongoDB collection not only affects overall write performance, but disk and memory resources as well. While MongoDB holds predictably well in scaling both reads and writes options, maintaining a heathly schema design should always remain a core character of a good application stack.
Aside from knowing when […]

Read more

Migrating to Amazon Aurora: Design for Flexibility

Migrating to Amazon Aurora

In this Checklist for Success series, we will discuss reducing unknowns when hosting in the cloud using and migrating to Amazon Aurora. These tips might also apply to other database as a service (DBaaS) offerings.
Previous blogs in the migrating to Amazon Aurora series:

Migrating to Amazon Aurora: Reduce the Unknowns
Migrating to Amazon Aurora: Optimize for […]

Read more

Migrating to Amazon Aurora: Optimize for Binary Log Replication

Migrating to Amazon Aurora 1

In this Checklist for Success series, we will discuss reducing unknowns when hosting in the cloud using and migrating to Amazon Aurora. These tips might also apply to other database as a service (DBaaS) offerings.
In our previous article, we discussed the importance of continuous query performance analysis, especially in Amazon Aurora where there is […]

Read more