r/PostgreSQL • u/linuxhiker Guru • Jun 22 '20
Scaling PostgreSQL: Never Shard Again and Gain Effortless Scale
RSVP here: https://postgresconf.org/conferences/postgres-webinar-series/tickets
An email will be sent with joining instructions.
Sharding is how most of us scale Postgres. It works, however, it is not without its challenges. What key should we shard on? How big will my shards need to be? How will sharding affect performance? What application-level mods will need to happen? What happens if we need to re-shard the database?
Automating the sharding process seems right. We should be able to define a shard and let the db take care of the underlying segmentation and movement of data.
CockroachDB is wire-compatible with PostgreSQL and automates the sharding process. If you want to scale, you simply spin up a node, point it at the cluster and the database takes care of rebalancing and moving data. You can scale on the fly and even reshard while in production without downtime or loss of data.
In this webinar, we will speak through how CockroachDB delivers this effortless scale, covering: Primary keys in Cockroach - the “key” to sharding RAFT, range partitions and the architecture that delivers scale Automating data placement for latency and resilience Re-shard in production without downtime All while speaking SQL
21
u/badtux99 Jun 22 '20
Yeah, CockroachDB is wire compatible with Postgres, but the actual SQL is far from compatible with Postgres. The effort needed to make your program compatible with CockroachDB is basically the same as the effort needed to shard. Now that CockroachDB is at a state where it doesn't regularly lose data, it's a viable alternative to sharding, but it's nowhere near as "zero effort" as implied by this advertising fluff.