SoylentNews
SoylentNews is people
https://soylentnews.org/

Title    Why Uber switched from Postgres to MySQL
Date    Thursday July 28 2016, @06:30AM
Author    n1
Topic   
from the they-forgot-about-mssql dept.
https://soylentnews.org/article.pl?sid=16/07/27/2120242

[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

Links

  1. "Original Submission" - https://soylentnews.org/submit.pl?op=viewsub&subid=14981

© Copyright 2024 - SoylentNews, All Rights Reserved

printed from SoylentNews, Why Uber switched from Postgres to MySQL on 2024-04-18 18:26:14