by Corrado Pandiani | Dec 22, 2023 | Insight for DBAs, Insight for Developers, MongoDB
by Corrado Pandiani | Aug 3, 2023 | Insight for Developers, MySQL, Open Source
In this article, I want to discuss a couple of pretty new features in MySQL 8.0 — and an older one. Maybe these are minor features you are not aware of, and maybe not so relevant, to be honest. But it is worth providing a quick overview, showing how they work,... by Corrado Pandiani | Jul 15, 2023 | Insight for DBAs, Insight for Developers, MongoDB
by Corrado Pandiani | Jul 15, 2023 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
This blog was originally published in January 2022 and was updated in July 2023.Working with hundreds of different customers, I often face similar problems around running queries. One very common problem when trying to optimize a database environment is index usage. A... by Corrado Pandiani | Nov 2, 2022 | Insight for Developers, MySQL
Are you familiar with the UNION statement for your SQL queries? Most likely, you are. It has been supported for a long time.In case you are not familiar with UNION, don’t worry, I’m going to show you how it works with simple examples.Considering “Set... by Corrado Pandiani | Aug 11, 2022 | Insight for Developers, MySQL, Open Source, Percona Software
I have recently written an article for this blog presenting Window Functions for MongoDB 5.0. I used some public Italian COVID-19 data for a few real examples. Please have a look at it if you like.Then I thought I should provide the same even for a relational database... by Corrado Pandiani | Jun 29, 2022 | Insight for Developers, MongoDB, Open Source, Percona Software
by Corrado Pandiani | Oct 20, 2021 | Insight for DBAs, Insight for Developers, MongoDB
by Corrado Pandiani | Aug 24, 2021 | Insight for DBAs, Insight for Developers, MongoDB
by Corrado Pandiani | May 24, 2021 | Hardware and Storage, Insight for DBAs, MongoDB
It’s your busiest day of the year and the website has crawled to a halt and finally crashed… and it was all because you did not understand how MongoDB uses memory and left your system open to cluster instability, poor performance, and unpredictable... by Corrado Pandiani | Jan 14, 2021 | Insight for DBAs, MongoDB, Open Source, Percona Software
Are you thinking about deploying MongoDB? Is it the right choice for you?Choosing a database is an important step when designing an application. A wrong choice can have a negative impact on your organization in terms of development and maintenance. Also, the wrong... by Corrado Pandiani | Dec 9, 2020 | Insight for DBAs, Monitoring, Percona Software, Security
Whichever way you installed Percona Monitoring and Management 2 (PMM2), using the docker image or an OVF image for your supported virtualized environment, PMM2 enables, by default, two ports for the web connections: 80 for HTTP and 443 for HTTPS. Using HTTPS... by Corrado Pandiani | Nov 5, 2020 | Insight for DBAs, Insight for Developers, MongoDB, Percona Software
by Corrado Pandiani | Jul 24, 2020 | Insight for DBAs, Insight for Developers, MongoDB
by Corrado Pandiani | May 20, 2020 | Cloud, Insight for DBAs, 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... by Corrado Pandiani | Feb 13, 2020 | Insight for DBAs, MySQL, Percona Software
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... by Corrado Pandiani | Feb 10, 2020 | Insight for DBAs, MySQL, Percona Software
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... by Corrado Pandiani | Dec 17, 2019 | Insight for DBAs, MongoDB, Open Source, Percona Software
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... by Corrado Pandiani | Oct 29, 2019 | Insight for Developers, MySQL, Open Source, Percona Software
by Corrado Pandiani | Aug 5, 2019 | Insight for DBAs, Insight for Developers, MongoDB
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...