During peak traffic early on, our bandwidth to the storage web service simply wasn’t fast enough to keep up with the rate at which WALs were being written to it. Since that time, the architecture of Uber has changed significantly, to a model of microservices and new data platforms. In addition to sending all of the WAL updates from West Coast to East Coast, we archived all WALs to a file storage web service, both for extra assurance that we could restore data in the event of a disaster and so that archived WALs could bring up new replicas from database snapshots. Why Uber Engineering Switched from Postgres to MySQL J/ Global Introduction The early architecture of Uber consisted of a monolithic backend application written in Python that used Postgres for data persistence.
#Postgres vs mysql uber plus
Transactional DDL is a huge advantage of PG, though this is more of a plus of PG than a negative of MySQL, as many other DBMSs lack this as well. Postgres has better explain/query plan analyzing features. PostgreSQL vs MySQL: strategic considerations for your business. This bandwidth problem also caused issues for us with WAL archival. MySQL has a less flexible and just 'worse' (IMO) query planner.
It's terrible at telling you what's wrong and it lacks a lot of features that PostgreSQL has. MySQL is incredibly frustrating to work with. Purchasing very high bandwidth cross-country links is expensive, and even in cases where money is not an issue it’s simply not possible to get a cross-country networking link with the same bandwidth as a local interconnect. These days its when dealing with Wordpress that's about the only time I see old MySQL pop up. However, the verbosity of the Postgres replication protocol can still cause an overwhelming amount of data for a database that uses a lot of indexes. Cascading replication limits the inter–data center bandwidth requirements to the amount of replication required between just the master and a single replica, even if there are many replicas in the second data center.
0 kommentar(er)
