Rafael Galinari, Author at Percona Database Performance Blog Fri, 02 Feb 2024 23:41:04 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png Rafael Galinari, Author at Percona Database Performance Blog 32 32 76301791 How to Install and Run PostgreSQL Using Docker https://www.percona.com/blog/installing-postgresql-using-docker/ https://www.percona.com/blog/installing-postgresql-using-docker/#respond Thu, 02 Nov 2023 09:00:38 +0000 https://www.percona.com/blog/?p=67630 This blog was originally published in Sept 2021 and was updated in November 2023.Following the series of blogs started by Peter Zaitsev in Installing MySQL with Docker, on deploying Docker containers running open source databases, in this article, I’ll demonstrate how to install and run PostgreSQL using Docker.Before proceeding, it is important to remind you […]]]> https://www.percona.com/blog/installing-postgresql-using-docker/feed/ 0 67630 MongoDB Docker Installation: Everything You Need to Know https://www.percona.com/blog/installing-mongodb-with-docker/ https://www.percona.com/blog/installing-mongodb-with-docker/#respond Wed, 01 Nov 2023 07:00:55 +0000 https://www.percona.com/blog/?p=67094 https://www.percona.com/blog/installing-mongodb-with-docker/feed/ 0 67094 MongoDB: Modifying Documents Using Aggregation Pipelines and Update Expressions https://www.percona.com/blog/mongodb-modifying-documents-using-aggregation-pipelines-and-update-expressions/ https://www.percona.com/blog/mongodb-modifying-documents-using-aggregation-pipelines-and-update-expressions/#respond Wed, 28 Jul 2021 14:16:42 +0000 https://www.percona.com/blog/?p=77460 Updating documents on MongoDB prior to version 4.2 was quite limited. It was not possible to set values to a conditional expression, combine fields, or update a field based on the value of another field on the server-side. Tracing a parallel to the SQL update statements, for example, it wasn’t possible to do something like […]]]> https://www.percona.com/blog/mongodb-modifying-documents-using-aggregation-pipelines-and-update-expressions/feed/ 0 77460 Sharding With Zones Based on Compound Shard-Keys on MongoDB 4.4 https://www.percona.com/blog/sharding-with-zones-based-on-compound-shard-keys-on-mongodb-4-4/ https://www.percona.com/blog/sharding-with-zones-based-on-compound-shard-keys-on-mongodb-4-4/#respond Tue, 06 Jul 2021 15:06:38 +0000 https://www.percona.com/blog/?p=77143 This article was written with the main purpose of showing you how to determine zones on a shard when using compound shard keys.Defining Zones in Shards means pre-defining where certain chunks will be stored and amongst which set of particular shards they will be balanced according to the shard key definition. MongoDB 4.4 brings the […]]]> https://www.percona.com/blog/sharding-with-zones-based-on-compound-shard-keys-on-mongodb-4-4/feed/ 0 77143 Refreshing Test/Dev Environments With Prod Data Using Percona Backup for MongoDB https://www.percona.com/blog/refreshing-test-dev-environments-with-prod-data-using-percona-backup-for-mongodb/ https://www.percona.com/blog/refreshing-test-dev-environments-with-prod-data-using-percona-backup-for-mongodb/#comments Wed, 19 May 2021 14:26:32 +0000 https://www.percona.com/blog/?p=76034 This is a very straightforward article written with the intention to show you how easy it is to refresh your Test/Dev environments with PROD data, using Percona Backup for MongoDB (PBM). This article will cover all the steps from the PBM configuration until the restore, assuming that the PBM agents are all up and running […]]]> https://www.percona.com/blog/refreshing-test-dev-environments-with-prod-data-using-percona-backup-for-mongodb/feed/ 1 76034