vividcortex

Tag: vividcortex

Setting Up Multi-Factor Authentication With the AWS CLI

As part of achieving SOC-2 certification, we had to implement stricter requirements around AWS authentication. Database Performance Monitor has had multi-factor authentication (MFA) for access to the AWS web-app console…

Monitoring and Observability With USE and RED

Modern systems can emit thousands or millions of metrics, and modern monitoring tools can collect them all. Faced with such an abundance of data, it can be difficult to know…

The Basics of Sharding in MongoDB

Sharding is a mechanism widely used in today’s most popular database systems, an effective way to divide, categorize, and organize data into manageable chunks. In some database types, such as…

An Introduction to MongoDB Replication and Replica Sets

Replication is a process common to virtually all modern-day database systems. As you very likely know, it can be a complex subject, especially when dealing with nuances that vary from…

How We Encrypt Data in MySQL With Go

A SaaS product needs to use security measures you might not ordinarily use in an on-premises solution. In particular, it’s important for all sensitive data to be secured. Encryption plays…

Why WiredTiger Is the Default MongoDB Storage Engine

When we published our blog post about working-sets in MongoDB, one of our colleagues told us he’d been aware that MMAPv1 had previously been MongoDB’s default storage engine, but he…

Understanding Whether Your MongoDB Indexes Are Effective

One of the variables that can have a major impact on your MongoDB performance is the way you implement indexes. While it’s a good idea to use indexes in some…

JSON Support in PostgreSQL, MySQL, MongoDB, and SQL Server

If you’ve been watching the evolution of database technologies over the past few years, you’ve seen how quickly JSON has quickly cemented its position in major database servers. Due to its use…

Three Things That Differentiate Amazon Aurora From MySQL

It’s not always obvious what makes one database type distinct from another. What are the most significant ways Amazon Aurora is different from MySQL? Clear separators aren’t always featured or…

Solving MySQL Replication Lag With LOGICAL_CLOCK and Calibrated Delay

Preetam Jinka published a post on his personal blog examining how his engineering team had overcome a problem with MySQL replication by using a new parallelization policy introduced in MySQL…