Re: High Availability PostgresDB on K8s

[Sumit Sengupta]

This may help - https://phoenixnap.com/kb/postgresql-kubernetes


[https://phoenixnap.com/kb/wp-content/uploads/2021/08/how-to-deploy-postgresql-on-kubernetes.png]
How to Deploy PostgreSQL on Kubernetes {Helm Chart or Manual Config} - 
Knowledge Base by phoenixNAP
Introduction. PostgreSQL is a reliable and robust relational database system 
featuring ACID-compliant transactions.It is designed to handle workloads of all 
sizes, making it a good fit for personal use and large-scale deployments such 
as data warehouses, big data servers, or web services.. Deploying PostgreSQL on 
Kubernetes creates a scalable and portable PostgreSQL instance, leveraging the 
...
phoenixnap.com


From: Marco Schmucki 
Sent: Friday, August 19, 2022 11:09 AM
To: pgsql-general@lists.postgresql.org 
Subject: High Availability PostgresDB on K8s


Hi all



I want to run an HA-Postgres-DB on a Kubernetes cluster for testing purposes 
(Proof of Concept).



Do you have some links or documentation?



Many thanks for your feedback!



Best regards,

Marco

Re: PostgreSQL vs MariaDB

[Sumit Sengupta]

Here is an EDB presentation on this from 2019
https://www.enterprisedb.com/blog/postgresql-vs-mysql-360-degree-comparison-syntax-performance-scalability-and-features
PostgreSQL vs. MySQL: A 360-degree Comparison [Syntax, Performance, Scalability 
and 
Features]
In this blog, we will discuss the key differences in terms of performance, 
syntax, scalability, and features between PostgreSQL and Mysql. PostgreSQL and 
MySQL are both immensely popular open-source databases, and a variety of 
real-time applications today utilize both. MySQL is known to be the world’s 
most popular database, whereas PostgreSQL is known as the world’s most advanced 
RDBMS database.
www.enterprisedb.com


From: Jeffrey Walton 
Sent: Friday, March 24, 2023 10:49 AM
To: Inzamam Shafiq 
Cc: pgsql-general@lists.postgresql.org 
Subject: Re: PostgreSQL vs MariaDB

On Fri, Mar 24, 2023 at 7:07 AM Inzamam Shafiq
 wrote:
>
> Can someone please list pros and cons of MariaDB vs PostgreSQL that actually 
> needs serious consideration while choosing the right database for large OLTP 
> DBs (Terabytes)?
>

For me, security is important. I don't want to do a lot of late night
patching, and I don't want to cleanup after a data breach. When
vendors pitch a product with a database, I insist on a PostgreSQL
backend.

MySQL makes regular appearances on BugTraq. MySQL has over 1700 CVEs
going back to 1999.[1] It tells me there are problems with the
engineering process.

MariaDB adds additional CVEs on top of MySQL, but the count appears
low. I have never separated the purely MariaDB flaws from the
underlying MySQL flaws.

In contrast, PostgreSQL has about 240 CVEs going back to 1999.[2] It
tells me PostgreSQL has a better engineering process.

Jeff

[1] https://cve.mitre.org/cgi-bin/cvekey.cgi?keyword=MySQL
[2] https://cve.mitre.org/cgi-bin/cvekey.cgi?keyword=PostgreSQL