Pigsty Blog Articles

Posts in 2023
  • How Can MySQL's Correctness Be This Garbage?

    December 28, 2023 in Database

    How Can MySQL's Correctness Be This Garbage?

    MySQL's transaction ACID has flaws and doesn't match documentation promises. This may lead to serious correctness issues - use with caution.

    MySQL's transaction ACID has flaws and doesn't match documentation promises. This may lead to serious correctness issues - use with caution.

  • S3: Elite to Mediocre

    December 26, 2023 in Cloud

    S3: Elite to Mediocre

    S3 is no longer "cheap" with the evolution of hardware, and other challengers such as cloudflare R2.

    S3 is no longer "cheap" with the evolution of hardware, and other challengers such as cloudflare R2.

  • Cloud Exit FAQ: DHH Saves Millions

    December 21, 2023 in Cloud

    Cloud Exit FAQ: DHH Saves Millions

    DHHs cloud exit journey has reached a new stage, saving nearly a million dollars so far with potential savings of nearly ten million over the next five years.

    DHHs cloud exit journey has reached a new stage, saving nearly a million dollars so far with potential savings of nearly ten million over the next five years.

  • Database in K8S: Pros & Cons

    December 06, 2023 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 …

    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 …

  • Pigsty v2.5: Ubuntu & PG16

    December 01, 2023 in Pigsty

    Pigsty v2.5: Ubuntu & PG16

    Pigsty v2.5 adds Ubuntu/Debian support (bullseye, bookworm, jammy, focal), new extensions including pointcloud and imgsmlr, and redesigned monitoring dashboards.

    Pigsty v2.5 adds Ubuntu/Debian support (bullseye, bookworm, jammy, focal), new extensions including pointcloud and imgsmlr, and redesigned monitoring dashboards.

  • From Cost-Reduction Jokes to Real Cost Reduction and Efficiency

    November 29, 2023 in Cloud

    From Cost-Reduction Jokes to Real Cost Reduction and Efficiency

    Alibaba-Cloud and Didi had major outages one after another. This article discusses how to move from cost-reduction jokes to real cost reduction and efficiency — what costs should we really reduce, what efficiency should we improve?

    Alibaba-Cloud and Didi had major outages one after another. This article discusses how to move from cost-reduction jokes to real cost reduction and efficiency — what costs should we really reduce, what efficiency should we improve?

  • Are Specialized Vector Databases Dead?

    November 21, 2023 in Database

    Are Specialized Vector Databases Dead?

    Vector storage and retrieval is a real need, but specialized vector databases are already dead. Small needs are solved by OpenAI directly, standard needs are captured by existing mature databases with vector extensions. The ecological niche left for specialized vector databases might support one company, but trying to build an industry around AI stories is impossible.

    Vector storage and retrieval is a real need, but specialized vector databases are already dead. Small needs are solved by OpenAI directly, standard needs are captured by existing mature databases with vector extensions. The ecological niche left for specialized vector databases might support one company, but trying to build an industry around AI stories is impossible.

  • Reclaim Hardware Bonus from the Cloud

    November 16, 2023 in Cloud

    Reclaim Hardware Bonus from the Cloud

    Hardware is interesting again, developments in CPUs and SSDs remain largely unnoticed by the majority of devs. A whole generation of developers is obscured by cloud hype and marketing noise.

    Hardware is interesting again, developments in CPUs and SSDs remain largely unnoticed by the majority of devs. A whole generation of developers is obscured by cloud hype and marketing noise.

  • What Can We Learn from Alibaba-Cloud's Global Outage?

    November 13, 2023 in Cloud

    What Can We Learn from Alibaba-Cloud's Global Outage?

    Alibaba-Cloud's epic global outage after Double 11 set an industry record. How should we evaluate this incident, and what lessons can we learn from it?

    Alibaba-Cloud's epic global outage after Double 11 set an industry record. How should we evaluate this incident, and what lessons can we learn from it?

  • Harvesting Alibaba-Cloud Wool, Building Your Digital Homestead

    November 08, 2023 in Cloud

    Harvesting Alibaba-Cloud Wool, Building Your Digital Homestead

    Alibaba-Cloud's Double 11 offered a great deal: 2C2G3M ECS servers for ¥99/year, low price for three years. This article shows how to use this decent ECS to build your own digital homestead.

    Alibaba-Cloud's Double 11 offered a great deal: 2C2G3M ECS servers for ¥99/year, low price for three years. This article shows how to use this decent ECS to build your own digital homestead.