Fri, 16 Feb 2024 21:58:10 +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 32 32 76301791 https://www.percona.com/blog/postgresql-backup-strategy-enterprise-grade-environment/ https://www.percona.com/blog/postgresql-backup-strategy-enterprise-grade-environment/#comments Sun, 02 Jul 2023 17:13:16 +0000 https://www.percona.com/blog/?p=52811 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 continuous archiving. The size of the database and your database environment—if it is on […]]]> https://www.percona.com/blog/postgresql-backup-strategy-enterprise-grade-environment/feed/ 6 52811 https://www.percona.com/blog/mysql-data-caching-efficiency/ https://www.percona.com/blog/mysql-data-caching-efficiency/#respond Fri, 14 Apr 2023 12:00:47 +0000 https://www.percona.com/blog/?p=87090 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 reasoning behind it is very simple: accessing data from memory […]]]> https://www.percona.com/blog/mysql-data-caching-efficiency/feed/ 0 87090 https://www.percona.com/blog/an-overview-of-sharding-in-postgresql-and-how-it-relates-to-mongodbs/ https://www.percona.com/blog/an-overview-of-sharding-in-postgresql-and-how-it-relates-to-mongodbs/#comments Tue, 24 Jan 2023 09:44:38 +0000 https://www.percona.com/blog/?p=57306 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 as provide an introductory overview of sharding itself. Please note I haven’t […]]]> https://www.percona.com/blog/an-overview-of-sharding-in-postgresql-and-how-it-relates-to-mongodbs/feed/ 5 57306 https://www.percona.com/blog/preventing-stale-reads-on-percona-xtradb-cluster-by-enforcing-causality-checks-on-a-per-query-basis/ https://www.percona.com/blog/preventing-stale-reads-on-percona-xtradb-cluster-by-enforcing-causality-checks-on-a-per-query-basis/#respond Thu, 21 Jul 2022 13:23:42 +0000 https://www.percona.com/blog/?p=81878 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 as a stale read. […]]]> https://www.percona.com/blog/preventing-stale-reads-on-percona-xtradb-cluster-by-enforcing-causality-checks-on-a-per-query-basis/feed/ 0 81878 https://www.percona.com/blog/creating-a-standby-cluster-with-the-percona-distribution-for-postgresql-operator/ https://www.percona.com/blog/creating-a-standby-cluster-with-the-percona-distribution-for-postgresql-operator/#comments Tue, 11 Jan 2022 15:39:45 +0000 https://www.percona.com/blog/?p=79703 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 backups, such as AWS S3 or GCP Cloud Storage […]]]> https://www.percona.com/blog/creating-a-standby-cluster-with-the-percona-distribution-for-postgresql-operator/feed/ 2 79703 https://www.percona.com/blog/pmm-now-supports-monitoring-of-postgresql-instances-connecting-with-any-database-name/ https://www.percona.com/blog/pmm-now-supports-monitoring-of-postgresql-instances-connecting-with-any-database-name/#respond Mon, 20 Dec 2021 17:44:10 +0000 https://www.percona.com/blog/?p=79373 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, however, some DBaaS providers like Heroku and DigitalOcean do not provide direct access to the […]]]> https://www.percona.com/blog/pmm-now-supports-monitoring-of-postgresql-instances-connecting-with-any-database-name/feed/ 0 79373 https://www.percona.com/blog/inspecting-mysql-servers-part-5-percona-monitoring-and-management/ https://www.percona.com/blog/inspecting-mysql-servers-part-5-percona-monitoring-and-management/#respond Wed, 07 Jul 2021 12:00:34 +0000 https://www.percona.com/blog/?p=77196 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 Percona Support WayInspecting MySQL Servers Part 2: Knowing the ServerInspecting MySQL Servers Part 3: […]]]> https://www.percona.com/blog/inspecting-mysql-servers-part-5-percona-monitoring-and-management/feed/ 0 77196 https://www.percona.com/blog/postgresql-ha-with-patroni-your-turn-to-test-failure-scenarios/ https://www.percona.com/blog/postgresql-ha-with-patroni-your-turn-to-test-failure-scenarios/#comments Fri, 11 Jun 2021 12:02:25 +0000 https://www.percona.com/blog/?p=76405 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 PostgreSQL environment with some recycled hardware we had lying around […]]]> https://www.percona.com/blog/postgresql-ha-with-patroni-your-turn-to-test-failure-scenarios/feed/ 5 76405 https://www.percona.com/blog/inspecting-mysql-servers-part-4-an-engine-in-motion/ https://www.percona.com/blog/inspecting-mysql-servers-part-4-an-engine-in-motion/#comments Fri, 04 Jun 2021 12:27:58 +0000 https://www.percona.com/blog/?p=76402 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 server. However, apart from the quick glance we get at two samples […]]]> https://www.percona.com/blog/inspecting-mysql-servers-part-4-an-engine-in-motion/feed/ 1 76402 https://www.percona.com/blog/inspecting-mysql-servers-part-3-what-mysql/ https://www.percona.com/blog/inspecting-mysql-servers-part-3-what-mysql/#comments Thu, 03 Jun 2021 12:27:17 +0000 https://www.percona.com/blog/?p=76373 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 itself. The second of our triad of tools […]]]> https://www.percona.com/blog/inspecting-mysql-servers-part-3-what-mysql/feed/ 1 76373 https://www.percona.com/blog/inspecting-mysql-servers-part-2-knowing-the-server/ https://www.percona.com/blog/inspecting-mysql-servers-part-2-knowing-the-server/#respond Wed, 02 Jun 2021 14:41:48 +0000 https://www.percona.com/blog/?p=76362 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 of these tools, the pt-summary.pt-summary is, […]]]> https://www.percona.com/blog/inspecting-mysql-servers-part-2-knowing-the-server/feed/ 0 76362 https://www.percona.com/blog/inspecting-mysql-servers-part-1-the-percona-support-way/ https://www.percona.com/blog/inspecting-mysql-servers-part-1-the-percona-support-way/#respond Tue, 01 Jun 2021 13:34:38 +0000 https://www.percona.com/blog/?p=76359 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 highly anticipated features such as the (still incipient) multi-threaded replication […]]]> https://www.percona.com/blog/inspecting-mysql-servers-part-1-the-percona-support-way/feed/ 0 76359 https://www.percona.com/blog/yearly-reminder-ddls-that-fail-to-propagate-may-cause-percona-xtradb-cluster-inconsistencies/ Fri, 23 Apr 2021 16:55:30 +0000 https://www.percona.com/blog/?p=75338 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 cluster replicates the schema change query as a […]]]> 75338 https://www.percona.com/blog/wondering-how-to-run-percona-xtradb-cluster-on-kubernetes-try-our-operator/ Tue, 17 Nov 2020 20:26:08 +0000 https://www.percona.com/blog/?p=72701 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 explaining this in The Criticality of a Kubernetes Operator for Databases. If […]]]> 72701 https://www.percona.com/blog/extending-percona-monitoring-and-management-for-mysql-innodb-cluster-with-custom-queries/ Tue, 23 Jun 2020 17:37:52 +0000 https://www.percona.com/blog/?p=69273 A few days ago, a customer got in touch asking how they could use Percona Monitoring and Management (PMM) to monitor the roles played by each node in an InnoDB cluster. More specifically, they wanted to check when one of the nodes changed its role from Primary to Secondary, or vice-versa. PMM allows for a […]]]> 69273 https://www.percona.com/blog/migrating-a-postgresql-database-between-dbaas-providers/ https://www.percona.com/blog/migrating-a-postgresql-database-between-dbaas-providers/#comments Wed, 25 Mar 2020 15:18:20 +0000 https://www.percona.com/blog/?p=66036 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 straightforward process. While in a traditional environment we would usually approach this problem by […]]]> https://www.percona.com/blog/migrating-a-postgresql-database-between-dbaas-providers/feed/ 1 66036 https://www.percona.com/blog/resolving-mongodb-stack-trace/ https://www.percona.com/blog/resolving-mongodb-stack-trace/#comments Thu, 18 Jul 2019 14:29:42 +0000 https://www.percona.com/blog/?p=59110 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 serverIn a test setup with a freshly installed MongoDB server, we connect to […]]]> https://www.percona.com/blog/resolving-mongodb-stack-trace/feed/ 3 59110 https://www.percona.com/blog/upgrading-migrating-legacy-postgresql/ Fri, 26 Apr 2019 13:00:10 +0000 https://www.percona.com/blog/?p=56633 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 built-in as well as open source tools.Watch the Recorded WebinarTo start, this webinar opens with a list of […]]]> 56633 https://www.percona.com/blog/fast-upgrade-of-legacy-postgresql-with-minimum-downtime-using-pg_upgrade/ https://www.percona.com/blog/fast-upgrade-of-legacy-postgresql-with-minimum-downtime-using-pg_upgrade/#comments Fri, 12 Apr 2019 15:44:44 +0000 https://www.percona.com/blog/?p=56295 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 pg_upgrade allows you, potentially, to minimize your downtime, an essential consideration […]]]> https://www.percona.com/blog/fast-upgrade-of-legacy-postgresql-with-minimum-downtime-using-pg_upgrade/feed/ 7 56295 https://www.percona.com/blog/replication-between-postgresql-versions-using-logical-replication/ https://www.percona.com/blog/replication-between-postgresql-versions-using-logical-replication/#comments Thu, 04 Apr 2019 17:21:11 +0000 https://www.percona.com/blog/?p=56174 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 means of upgrade, and depending on your scenario, you can choose […]]]> https://www.percona.com/blog/replication-between-postgresql-versions-using-logical-replication/feed/ 4 56174