by Corrado Pandiani | Jul 17, 2019 | Insight for DBAs, MySQL
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?... by Corrado Pandiani | May 13, 2019 | MySQL, Open Source, Percona Software
“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... by Corrado Pandiani | Dec 19, 2018 | MongoDB, Open Source, Percona Software
by Corrado Pandiani | Dec 4, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Open Source
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... by Corrado Pandiani | Sep 6, 2018 | Insight for Developers, MongoDB, Open Source, Percona Software
by Corrado Pandiani | Sep 4, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Open Source, Percona Software
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... by Corrado Pandiani | Aug 16, 2018 | Insight for Developers, MongoDB, Open Source, Percona Software
by Corrado Pandiani | May 31, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Security
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... by Corrado Pandiani | May 23, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Security
by Corrado Pandiani | May 17, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Security
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... by Corrado Pandiani | Apr 2, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Security
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... by Corrado Pandiani | Mar 29, 2018 | MySQL, ProxySQL
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....