2 ms·
interesting, 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
by chaostheory 19y ago
interesting, 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/