Featured
Percona Products
Percona Services
Use Cases
Corrado PandianiFrom time to time you may have experienced that MySQL was not able to find the best execution plan for a query. You felt the query should have been faster. You felt that something didn’t work, but you didn’t realize exactly what. Maybe some of you did tests and discovered there was a better execution […]
Creating an index on a MongoDB collection is simple; just run the command CreateIndex and that’s all there is to it. There are several index types available, and in a previous post, you can find the more important index types: MongoDB index types and explain(). The command is quite simple, but for MongoDB, building an […]
I was recently faced with a real issue about completely exhausting the disk space on MySQL. This was a serious issue because of the continuous outages of the service, as the customer had to constantly restart the server and wait for the next outage. What was happening? In this article, I’m going to explain it […]
“Hey, what’s going on with my applications? I installed a newer version of MySQL. I have queries that perfectly run with the older version and now I have a lot of errors.” This is a question some customers have asked me after upgrading MySQL. In this article, we’ll see what one of the most frequent […]
In this article I’m going to talk about partial and sparse indexes in MongoDB® and Percona Server for MongoDB®. I’ll show you how to use them, and look at cases where they can be helpful. Prior to discussing these indexes in MongoDB in detail, though, let’s talk about an issue on a relational database like MySQL®. […]
MongoDB 4.0 is around, and there are a lot of new features and improvements. In this article we’re going to focus on the major feature which is, undoubtedly, the support for multi-document ACID transactions. This novelty for a NoSQL database could be seen as a way to get closer to the relational world. Well, it’s […]
This is the second part of a two parts series. In MongoDB: index usage and MongoDB explain() we introduced the main index types supported by MongoDB, and how to create and use them. In this second article, we are going to see some examples on how to use explain() method to investigate queries. Do you […]
In this two-part series, I’m going to explain explain. No, the repetition is not a pun or a typo. I’m talking about explain(), the most useful MongoDB feature to investigate a query. Here, I’ll introduce the index types available in MongoDB, their properties and how to create and use them. In the next article, we’ll […]
The flexibility of MongoDB as a schemaless database is one of its strengths. In early versions, it was left to application developers to ensure that any necessary MongoDB data validation is implemented. With the introduction of JSON Schema Validator there are new techniques to enforce data integrity for MongoDB. In this article, we use examples to show […]
In this third and final post of the series, we look at how to configure transport encryption on a deployed MongoDB replica set. Security vulnerabilities can arise when internal personnel have legitimate access to the private network, but should not have access to the data. Encrypting intra-node traffic ensures that no one can “sniff” sensitive data […]
In this article series, we will talk about the basic high availability architecture of a MongoDB: the MongoDB replica set. Part 1 : We introduced basic replica set concepts, how it works and what its main features Part 2 (this post): We’ll provide a step-by-step guide to configure a three-node replica set Part 3: We’ll […]
In this article series, we will talk about the basic high availability architecture of a MongoDB: the MongoDB replica set. We’ll cover it in three parts: Part 1 (this post): We’ll introduce basic replica set concepts, how it works and what its main features Part 2: We’ll provide a step-by-step guide to configure a three-node […]
In this post, we’ll look at MongoDB data at rest encryption using eCryptFS, and how to deploy a MongoDB server using encrypted data files. When dealing with data, a good security policy should enforce the use of “no trivial” passwords, the use of encrypted connections and hopefully encrypted files on the disks. Only the MongoDB […]
In this blog post, we’ll look at using ProxySQL and VIRTUAL columns to solve object-relational mapping (ORM) issues. There are a lot of web frameworks all around. Programmers and web designers are using them to develop and deploy any website and web application. Just to cite some of the most famous names: Drupal, Ruby on […]