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, Funny) by Anonymous Coward on Thursday July 28 2016, @02:39PM

    by Anonymous Coward on Thursday July 28 2016, @02:39PM (#381203)

    Will you two just stop disagreeing with each other in a civil manner? This is the internet and one of you is an AC! Fight! Fight! Fight!

    Starting Score:    0  points
    Moderation   +2  
       Funny=2, Total=2
    Extra 'Funny' Modifier   0  
    Total Score:   2  

  • (Score: 1, Touché) by Anonymous Coward on Thursday July 28 2016, @02:50PM

    by Anonymous Coward on Thursday July 28 2016, @02:50PM (#381208)
    I wasn't very civil. In my earlier post I told him not to shoot his mouth off. Does that make you feel better?

    • (Score: 3, Touché) by Common Joe on Thursday July 28 2016, @03:14PM

      by Common Joe (33) <common.joe.0101NO@SPAMgmail.com> on Thursday July 28 2016, @03:14PM (#381220) Journal

      Sounds like you're the AC who was "uncivil" to me. I'm glad you're reading my followup stuff.

      What I'm most happy about is you had a good and informative reply. (Thank you.) Yeah, you were a bit uncivil, but you're an AC, this is the Internet, and I tried to pay attention more to learning from your response.

    • (Score: 0) by Anonymous Coward on Thursday July 28 2016, @03:46PM

      by Anonymous Coward on Thursday July 28 2016, @03:46PM (#381225)

      Does that make you feel better?

      Not exactly. There was no name calling or personal attacks. Not even mention of his insensitiveness or his clodiness. Ugh, I'm going over to 4chan to balance the internet's scales.

      • (Score: 2) by bzipitidoo on Thursday July 28 2016, @04:31PM

        by bzipitidoo (4388) on Thursday July 28 2016, @04:31PM (#381244) Journal

        You want a fight? Ask these:

        Which P in LAMP is best, PHP, Python, or Perl?

        And for that matter, Apache, nginx, lighttpd, or something else?

        vi or emacs?

        Is systemd Lucifer in the flesh?

        SoylentNews or Slashdot?

        • (Score: 2) by mtrycz on Thursday July 28 2016, @07:51PM

          by mtrycz (60) on Thursday July 28 2016, @07:51PM (#381299)

          The obvious response to each end every one is:

          To each their own.

          Except Slashdot. Obviously :3

          --
          In capitalist America, ads view YOU!