Pete Scott, Author at Percona Database Performance Blog Wed, 28 Feb 2024 15:21:24 +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 Pete Scott, Author at Percona Database Performance Blog 32 32 76301791 What is PostgreSQL? Everything You Need to Know https://www.percona.com/blog/what-is-postgresql-used-for/ https://www.percona.com/blog/what-is-postgresql-used-for/#respond Fri, 02 Feb 2024 09:00:36 +0000 https://www.percona.com/blog/?p=90297 This blog was originally published in August of 2023 and updated in February of 2024.To fully answer the question — and to make the information relevant and solution-focused for enterprise businesses and organizations — we’ll also ask and answer a couple more. In building-block order, here are all three questions, followed by short answers (but please […]]]> https://www.percona.com/blog/what-is-postgresql-used-for/feed/ 0 90297 Backup and Recovery for Databases: What You Should Know https://www.percona.com/blog/backup-and-recovery-for-databases-what-you-should-know/ https://www.percona.com/blog/backup-and-recovery-for-databases-what-you-should-know/#respond Wed, 30 Aug 2023 12:33:34 +0000 https://www.percona.com/blog/?p=90566 People used to say, “Coal is king,” and for decades, it was. Coal powered just about everything, but mismanagement and a lack of stewardship left some messes. These days, “Data is king,” and a lot more. Data powers everything, and unlike coal and coal combustion, data and databases aren’t going away. So staying with our analogy, […]]]> https://www.percona.com/blog/backup-and-recovery-for-databases-what-you-should-know/feed/ 0 90566 High Availability vs. Fault Tolerance: Is FT’s 00.001% Edge in Uptime Worth the Headache? https://www.percona.com/blog/high-availability-vs-fault-tolerance/ https://www.percona.com/blog/high-availability-vs-fault-tolerance/#comments Tue, 22 Aug 2023 12:31:44 +0000 https://www.percona.com/blog/?p=90415 Estimates vary, but most reports put the average cost of unplanned database downtime at approximately $300,000 to $500,000 per hour, or $5,000 to $8,000 per minute. With so much at stake, database high availability and fault tolerance have become must-have items, but many companies just aren’t certain which one they must have.This blog article will […]]]> https://www.percona.com/blog/high-availability-vs-fault-tolerance/feed/ 1 90415 An Enterprise-Grade MongoDB Alternative Without Licensing or Lock-in https://www.percona.com/blog/an-enterprise-grade-mongodb-alternative-without-licensing-or-lock-in/ https://www.percona.com/blog/an-enterprise-grade-mongodb-alternative-without-licensing-or-lock-in/#respond Mon, 17 Jul 2023 12:25:19 +0000 https://www.percona.com/blog/?p=89475 MongoDB Community Edition software might set the stage for achieving your high-volume database goals, but you quickly learn that its features fall short of your enterprise needs.So you look at MongoDB Enterprise software, but its costly and complex licensing structure does not meet your budget goals. You’re also not certain its features will always align […]]]> https://www.percona.com/blog/an-enterprise-grade-mongodb-alternative-without-licensing-or-lock-in/feed/ 0 89475 Setting Up and Deploying PostgreSQL for High Availability https://www.percona.com/blog/setting-up-and-deploying-postgresql-for-high-availability/ https://www.percona.com/blog/setting-up-and-deploying-postgresql-for-high-availability/#respond Fri, 07 Jul 2023 14:41:29 +0000 https://www.percona.com/blog/?p=89329 With the average cost of unplanned downtime running from $300,000 to $500,000 per hour, businesses are increasingly using high availability (HA) technologies to maximize application uptime. Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Despite all its upside, PostgreSQL software presents such challenges. PostgreSQL provides the foundation […]]]> https://www.percona.com/blog/setting-up-and-deploying-postgresql-for-high-availability/feed/ 0 89329 The Ultimate Guide to Database High Availability https://www.percona.com/blog/the-ultimate-guide-to-database-high-availability/ https://www.percona.com/blog/the-ultimate-guide-to-database-high-availability/#respond Thu, 22 Jun 2023 14:26:58 +0000 https://www.percona.com/blog/?p=88503 To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. That doesn’t mean downtime is nonexistent, but it must be limited so that significant/irreparable damage (as defined by the business or industry) does not occur.This guide provides an overview of what high availability means, the components […]]]> https://www.percona.com/blog/the-ultimate-guide-to-database-high-availability/feed/ 0 88503 Ready-to-Use High Availability Architectures for MySQL and PostgreSQL https://www.percona.com/blog/ready-to-use-high-availability-architectures-for-mysql-and-postgresql/ https://www.percona.com/blog/ready-to-use-high-availability-architectures-for-mysql-and-postgresql/#comments Mon, 12 Jun 2023 15:31:30 +0000 https://www.percona.com/blog/?p=88445 When it comes to access to their applications, users demand instant, reliable, and secure interactions — and that means databases must be highly available.With database high availability (HA), services are largely uninterrupted, and end users are largely satisfied. Without high availability, there’s more-than-negligible downtime, and end users can become non-users (as in, former customers). A […]]]> https://www.percona.com/blog/ready-to-use-high-availability-architectures-for-mysql-and-postgresql/feed/ 1 88445 Vendor Lock-in: What It Is and How To Avoid It https://www.percona.com/blog/vendor-lock-in-what-it-is-and-how-to-avoid-it/ https://www.percona.com/blog/vendor-lock-in-what-it-is-and-how-to-avoid-it/#respond Tue, 09 May 2023 12:29:07 +0000 https://www.percona.com/blog/?p=87597 Vendor lock-in. The term is inherently ominous, and a broad definition isn’t much cheerier. They both suggest limited or lost freedom. To determine whether that perception is warranted in the database software industry — and if so, how to avoid vendor lock-in pitfalls — let’s dig deeper.First, here’s a broad and common definition: Vendor lock-in […]]]> https://www.percona.com/blog/vendor-lock-in-what-it-is-and-how-to-avoid-it/feed/ 0 87597 Open Source vs. Proprietary Database Software: What To Choose? https://www.percona.com/blog/open-source-vs-proprietary-software https://www.percona.com/blog/open-source-vs-proprietary-software#respond Fri, 28 Apr 2023 13:00:24 +0000 https://www.percona.com/blog/?p=87406 For starters, yes, Percona has chosen sides. We are a company of open source proponents. We’re also dedicated and active participants in the global open source community. But the intent here is to be informative, not to declare a winner between the two. Both open source and proprietary options have advantages. At the same time, it’s […]]]> https://www.percona.com/blog/open-source-vs-proprietary-software/feed/ 0 87406 How To Reduce the Costs of Database Management in Financial Services https://www.percona.com/blog/how-to-reduce-the-costs-of-database-management-in-financial-services/ https://www.percona.com/blog/how-to-reduce-the-costs-of-database-management-in-financial-services/#respond Fri, 14 Apr 2023 12:54:10 +0000 https://www.percona.com/blog/?p=86402 Here we are, with an economic downturn looming globally and some countries facing a recession. For many execs and tech decision-makers in the financial services industry, it’s not the first go-round. During the recession of 2008, they experienced firsthand how fast money and assets can vanish.Fortunately, there now are trusted steps financial institutions can take […]]]> https://www.percona.com/blog/how-to-reduce-the-costs-of-database-management-in-financial-services/feed/ 0 86402 Is MongoDB Open Source? Is Planet Earth Flat? https://www.percona.com/blog/is-mongodb-open-source https://www.percona.com/blog/is-mongodb-open-source#respond Wed, 12 Apr 2023 12:00:59 +0000 https://www.percona.com/blog/?p=86945 Search for an answer, and you can find plenty of folks who say “yes” to both.At Percona, our answer is “no” to the MongoDB question — and “no” to the flat-Earth question. We’re equally convinced on both counts, but in this blog article, we’re focusing on why MongoDB is not open source. Let’s start with […]]]> https://www.percona.com/blog/is-mongodb-open-source/feed/ 0 86945 The Ultimate Guide to Open Source Databases https://www.percona.com/blog/ultimate-guide-open-source-databases https://www.percona.com/blog/ultimate-guide-open-source-databases#comments Thu, 30 Mar 2023 17:11:08 +0000 https://www.percona.com/blog/?p=86600 The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. This comprehensive overview examines open source database architecture, types, pros and cons, uses by industry, and […]]]> https://www.percona.com/blog/ultimate-guide-open-source-databases/feed/ 2 86600