Author - Corrado Pandiani

MongoDB: Utilization of an Index on Subdocuments

MongoDB Index on Subdocument

MongoDB has a lot of possibilities for creating indexes. We have seen in previous articles some of the available index types and discussed explain() usage:
Using Partial and Sparse Indexes in MongoDB
MongoDB Index Types and MongoDB explain() (part 1)
MongoDB: Investigate Queries with explain() and Index Usage (part 2)
You can have a look at those if […]

Read more

Real-Time Replication From DynamoDB to MongoDB

Replication From DynamoDB to MongoDB

Recently I’ve been faced with an interesting challenge. How can I replicate data, in real-time, from DynamoDB to MongoDB?
Why would I need real-time replication like that? For example:

Running on MongoDB different queries relying on different indexes
Having on MongoDB more fields or converted fields (you can do it during the replication) so you can use […]

Read more

Introduction to MySQL 8.0 Recursive Common Table Expression (Part 2)

MySQL 8.0 Recursive Common Table Expression

This is the second part of a two-articles series. In the first part, we introduced the Common Table Expression (CTE), a new feature available on MySQL 8.0 as well as Percona Server for MySQL 8.0. In this article, we’ll present the Recursive Common Table Expression. SQL is generally poor at recursive structures, but it […]

Read more

Introduction to MySQL 8.0 Common Table Expressions (Part 1)

MySQL Common Table Expressions

This blog is the first part of a two-articles series. In this article, I’m going to introduce the Common Table Expression (CTE), a new feature available on MySQL 8.0, as well as Percona Server for MySQL 8.
What is a Common Table Expression?
We can define a CTE as an alternative to a derived table. In […]

Read more

Percona Backup for MongoDB in Action

Percona Backup for MongoDB in Action

We recently released Percona Backup for MongoDB(PBM) as GA. It’s our open source tool for taking a consistent backup of a running standalone mongod instance, a Replica Set, or a Sharded Cluster as well. The following articles can give you an overview of the tool:

Avoid Vendor Lock-in with Percona Backup for MongoDB
Percona Backup for […]

Read more