by Fernando Laudares Camargos | Jul 2, 2023 | Insight for DBAs, PostgreSQL
This blog was originally written in September 2018 and was updated in June 2023.In this post, we cover the methods used to achieve an enterprise-grade backup strategy for the PostgreSQL cluster. In setting up our demonstration system, we use pg_basebackup and... by Fernando Laudares Camargos | Apr 14, 2023 | Monitoring, MySQL, Percona Software
A shared characteristic in most (if not all) databases, be them traditional relational databases like Oracle, MySQL, and PostgreSQL or some kind of NoSQL-style database like MongoDB, is the use of a caching mechanism to keep (a copy of) part of the data in memory.The... by Fernando Laudares Camargos | Jan 24, 2023 | MongoDB, PostgreSQL
This post was originally published in 2019 and was updated in 2023.I presented at Percona University São Paulo about the new features in PostgreSQL that allow the deployment of simple shards. I’ve tried to summarize the main points in this post, as well... by Fernando Laudares Camargos | Jul 21, 2022 | Insight for DBAs, MySQL, Percona Software
When we run a SELECT in a replica server and it returns a different result to the one we would have obtained had we queried the source server instead, due to changes in the dataset that have not yet been replicated or synchronized to the replica, we get what is known... by Fernando Laudares Camargos | Jan 11, 2022 | Cloud, Percona Software, PostgreSQL
A customer recently asked if our Percona Operator for PostgreSQL supports the deployment of a standby cluster, which they need as part of their Disaster Recovery (DR) strategy. The answer is yes – as long as you are making use of an object storage system for... by Fernando Laudares Camargos | Dec 20, 2021 | Monitoring, Percona Software, PostgreSQL
The recent release of Percona Monitoring and Management 2.25.0 (PMM) includes a fix for bug PMM-6937: before that, PMM expected all monitoring connections to PostgreSQL servers to be made using the default postgres database. This worked well for most deployments,... by Fernando Laudares Camargos | Jul 7, 2021 | Monitoring, MySQL, Percona Software
In the previous posts of this series, I presented how the Percona Support team approaches the analysis and troubleshooting of a MySQL server using a tried-and-tested method supported by specific tools found in the Percona Toolkit:Inspecting MySQL Servers Part 1: The... by Fernando Laudares Camargos | Jun 11, 2021 | Insight for DBAs, Percona Live, Percona Software, PostgreSQL
A couple of weeks ago, Jobin and I did a short presentation during Percona Live Online bearing a similar title as the one for this post: “PostgreSQL HA With Patroni: Looking at Failure Scenarios and How the Cluster Recovers From Them”. We deployed a 3-node... by Fernando Laudares Camargos | Jun 4, 2021 | Insight for DBAs, MySQL
The combination of the information obtained from the “pt-summaries” discussed in the previous posts of this series (Part 1: The Percona Support Way, Part 2: Knowing the Server, Part 3: What MySQL?) helps us come up with the first impression of a MySQL... by Fernando Laudares Camargos | Jun 3, 2021 | Insight for DBAs, MySQL, Percona Software
In the previous post of this series, we looked at the hardware specifications and operating system settings of the host server through the lenses of a pt-summary report. Now that we know the foundation on which the database is running, we can turn our focus to MySQL... by Fernando Laudares Camargos | Jun 2, 2021 | Insight for DBAs, Insight for Developers, MySQL
In part 1 of this series, we introduced you to the approach used by the Percona Support team to inspect MySQL servers, which is based on a triad of tools from the Percona Toolkit used to gather diagnostic information. In this article, we will be focusing on the first... by Fernando Laudares Camargos | Jun 1, 2021 | Insight for DBAs, Insight for Developers, MySQL, Percona Services
When I joined the Percona Support team in early 2013, MySQL 5.6 was being launched. I remember all the buzz and euphoria surrounding its release: it was a big step from the 5.5 series, carrying important changes in the MySQL architecture and internals that brought... by Fernando Laudares Camargos | Apr 23, 2021 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Apologies for the silly title, but the issue is a real one, even though it is not a new thing. Schema upgrades are not an ordinary operation in Galera. For the subject at hand, the bottom line is: under the default Total Order Isolation (TOI) method, “the... by Fernando Laudares Camargos | Nov 17, 2020 | Cloud, MySQL, Open Source, Percona Software
Kubernetes has been a big trend for a while now, particularly well-suited for microservices. Running your main databases on Kubernetes is probably NOT what you are looking for. However, there’s a niche market for them. My colleague Stephen Thorn did a great job... by Fernando Laudares Camargos | Jun 23, 2020 | Monitoring, MySQL, Percona Software
by Fernando Laudares Camargos | Mar 25, 2020 | Insight for DBAs, Percona Software, PostgreSQL
We recently helped migrate a production PostgreSQL database running on a given DBaaS platform… to another DBaaS platform. When it comes to vendor “lock-in”, some providers are easier (and even friendlier) to deal with than others, but it is never a... by Fernando Laudares Camargos | Jul 18, 2019 | MongoDB
When a MongoDB server crashes you will usually find what is called a “stack trace” in its log file. But what is it and what purpose does it have? Let’s simulate a simple crash so we can dig into it. Crashing a test server In a test setup with a... by Fernando Laudares Camargos | Apr 26, 2019 | Insight for DBAs, PostgreSQL, Webinars
Please join Percona’s PostgreSQL Support Technical Lead, Avinash Vallarapu and Senior Support Engineers, Fernando Laudares, Jobin Augustine and Nickolay Ihalainen as they demonstrate the methods to upgrade a legacy version of PostgreSQL to a newer version using... by Fernando Laudares Camargos | Apr 12, 2019 | PostgreSQL
When you need to upgrade your PostgreSQL databases, there are a number of options available to you. In this post we’ll take a look at how you can upgrade PostgreSQL versions using pg_upgrade, a built-in tool that allows in-place upgrade of your software. Using... by Fernando Laudares Camargos | Apr 4, 2019 | PostgreSQL
When you need to upgrade PostgreSQL, there are a variety of approaches that you can use. To avoid application downtime, then not all of the options to upgrade postgres are suitable. When avoiding downtime is essential, then you might consider using replication as a...