Stories
Slash Boxes
Comments

SoylentNews is people

Why Uber switched from Postgres to MySQL

posted by n1 on Thursday July 28 2016, @06:30AM   Printer-friendly
from the they-forgot-about-mssql dept.

[redacted] Coward writes:

https://eng.uber.com/mysql-migration/

The early architecture of Uber consisted of a monolithic backend application written in Python that used Postgres for data persistence. Since that time, the architecture of Uber has changed significantly, to a model of microservices and new data platforms. Specifically, in many of the cases where we previously used Postgres, we now use Schemaless, a novel database sharding layer built on top of MySQL. In this article, we’ll explore some of the drawbacks we found with Postgres and explain the decision to build Schemaless and other backend services on top of MySQL.

[...] We encountered many Postgres limitations:

Inefficient architecture for writes
Inefficient data replication
Issues with table corruption
Poor replica MVCC support
Difficulty upgrading to newer releases

Original Submission

 
This discussion has been archived. No new comments can be posted.
Why Uber switched from Postgres to MySQL | Log In/Create an Account | Top | 34 comments | Search Discussion
Display Options Threshold/Breakthrough Mark All as Read Mark All as Unread
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

  • (Score: 2) by Thexalon on Thursday July 28 2016, @06:01PM

    by Thexalon (636) on Thursday July 28 2016, @06:01PM (#381270)

    MySQL has got a lot better in the last 10 years, but that doesn't erase it's rocky and spotty history

    Which is one reason it makes a perfect pairing with PHP, which has the exact same problem! And in both cases, one of the problems is that they have to deal with legacy code the relies on the stupid decisions they made years ago before they knew better.

    Also, apropos of nothing else, I agree that the Linux Standard Database, or "LSD" for short, ought to be ACID-compliant.

    --
    The only thing that stops a bad guy with a compiler is a good guy with a compiler.
    Starting Score:    1  point
    Karma-Bonus Modifier   +1  
    Total Score:   2