5 ms·
It seems mysql (and hopefully postgresql sometime soon) with custom sharding logic in the app layer still hits the sweet spot for scaling to the order of 100M u
by boomzilla 11y ago
It seems mysql (and hopefully postgresql sometime soon) with custom sharding logic in the app layer still hits the sweet spot for scaling to the order of 100M users. With some thoughts going into designing an appropriate data model and sharding logic, certain join queries can be delegated to the databases too.
- sarnowski 11y agoHi, at Zalando, we are scaling all of our core businesses with PostgreSQL. Depending on your dataset, it can be fairly easy to shard your data for a horizontal scale-out (think of independent customer datasets). We have lots of databases that we scale horizontally to much bigger numbers. But, we also developed several tools that makes working with shards mostly transparent. Did not find a better source but one way we use PostgreSQL can be seen in detail in the following slides: http://gotocon.com/berlin-2013/presentation/Why%20Zalando%20trusts%20in%20PostgreSQL http://gotocon.com/berlin-2013/presentation/Why%20Zalando%20...
- needusername 11y ago5 TB easily fits on a single Oracle instance on a single host.
- detaro 11y agoIt also easily fits in a Postgres instance on a single host, if you only look at "can store X amount of data". And even if Postgres is slower, for the money you save in license costs you can buy a few beefy nodes extra.
- brianwawok 11y agoYou can easily buy 10 postgres nodes for the license cost of 1 Oracle node.
- needusername 11y agoAnd your engineers work for free.
- mhd 11y agoFree, no. Less money than Oracle DBAs? (Yes.