4 ms·
These are good points, but from what I'm seeing it's now more in vogue to use sharding (or other favorite term for same) to split your data by user across diffe
by mattculbreth 19y ago
These are good points, but from what I'm seeing it's now more in vogue to use sharding (or other favorite term for same) to split your data by user across different DBs. That way you can still scale horizontally.
- chaostheory 19y agointeresting, I'm not a sysadmin guy so could you explain the differences between clustering and sharding from a db standpoint? Is there an open source sharding solution for Postgres?
- mattculbreth 19y agoWell clustering is having multiple servers addressing the same content. Boosts performance and reliability. Sharding is where you split the data across multiple servers, based on some identifying category like users, functional area, etc.
- dood 19y agoA little on sharding: An Unorthodox Approach to Database Design : The Coming of the Shard [http://news.ycombinator.com/item?id=38407 http://news.ycombinator.com/item?id=38407] Partitioning vs. Federation vs. Sharding [http://www.lethargy.org/~jesus/archives/95-Partitioning-vs.-Federation-vs.-Sharding.html http://www.lethargy.org/~jesus/archives/95-Partitioning-vs.-...]
- cpinto 19y agoCheck pgpool-ii: http://pgpool.projects.postgresql.org/pgpool-II/en/ http://pgpool.projects.postgresql.org/pgpool-II/en/