-
Database in K8S: Pros & Cons
2023-12-06 in Database
Whether databases should be housed in Kubernetes/Docker remains highly controversial. While Kubernetes (k8s) excels in managing stateless applications, it has fundamental drawbacks with stateful services, especially databases like PostgreSQL and …
-
PostgreSQL Convention 2024
2023-11-27 in Postgres
Background 0x01 Naming Convention 0x01 Design Convention 0x01 Query Convention 0x01 Admin Convention Roughly translated from PostgreSQL Convention 2024 with Google. 0x00 Background No Rules, No Lines The functions of PostgreSQL are very powerful, …
-
Reclaim Hardware Bonus from the Cloud
2023-11-16 in Cloud Exit
Hardware is interesting again, with the AI wave fueling a GPU frenzy. However, the intrigue isn’t limited to GPUs —— developments in CPUs and SSDs remain largely unnoticed by the majority of devs. A whole generation of developers is obscured by cloud …
-
v2.5: Debian / Ubuntu / PG16
2023-10-24 in Releases
v2.5.0 curl https://get.pigsty.cc/latest | bash Highlights Ubuntu / Debian Support: bullseye, bookworm, jammy, focal Dedicate yum/apt repo on repo.pigsty.cc and mirror on packagecloud.io Anolis OS Support (EL 8.8 Compatible) PG Major Candidate: Use …
-
v2.4: Monitoring Cloud RDS
2023-09-14 in Releases
v2.4.0 Get started with bash -c "$(curl -fsSL https://get.pigsty.cc/latest)". Highlights PostgreSQL 16 support The first LTS version with business support and consulting service Monitoring existing PostgreSQL, RDS for PostgreSQL / PolarDB …
-
v2.3: Ecosystem Applications
2023-08-20 in Releases
v2.3.0 PGSQL/REDIS Update, NODE VIP, Mongo/FerretDB, MYSQL Stub Get started with bash -c "$(curl -fsSL https://get.pigsty.cc/latest)" Highlight INFRA: NODE/PGSQL VIP monitoring support NODE: Allow bind node_vip to node cluster with …
-
v2.2: Observability Overhaul
2023-08-04 in Releases
v2.2.0 https://github.com/Vonng/pigsty/releases/tag/v2.2.0 Get started with bash -c "$(curl -fsSL https://get.pigsty.cc/latest)" Release Note: https://doc.pigsty.cc/#/RELEASENOTE?id=v220 Highlight Monitoring Dashboards Overhaul: …
-
FinOps: Endgame Cloud-Exit
2023-07-06 in Cloud Exit
Categories:
At the SACC 2023 FinOps session, I fiercely criticized cloud vendors. This is a transcript of my speech, introducing the ultimate FinOps concept — cloud-exit and its best practice. TL; DR Misaligned FinOps Focus: Total Cost = Unit Price x Quantity. …
-
PostgreSQL, The most successful database
2023-06-28 in Postgres
The StackOverflow 2023 Survey, featuring feedback from 90K developers across 185 countries, is out. PostgreSQL topped all three survey categories (used, loved, and wanted), earning its title as the undisputed “Decathlete Database” – …
-
SLA: Placebo or Insurance?
2023-06-12 in Cloud Exit
In the world of cloud computing, Service Level Agreements (SLAs) are seen as a cloud provider’s commitment to the quality of its services. However, a closer examination of these SLAs reveals that they might not offer the safety net one might …