search

akka / akka-persistence-r2dbc

https://doc.akka.io/docs/akka-persistence-r2dbc/current/index.html
Other
24 stars 17 forks source link

doc: Sharding vs partitioning #570

Closed patriknw closed 2 months ago

patriknw commented 2 months ago

Trigged by some feedback I looked closer at what others say regarding sharding vs partitioning.Seems like sharding is mostly used for horizontal partitioning to distribute the data across multiple servers. While partitioning is a more generic term it mostly refers to splitting up large tables into smaller tables, but still in one database instance (*vertical scaling").

Our primary goal is horizontal scaling so we should highlight database sharding.

That said, the implementation splits the data into multiple tables (partitioning), which can then optionally be located on different database instances (sharding). The documentation still uses data partition and that it corresponds to a table. I think that is fine, but let me know if it's confusing.

patriknw commented 2 months ago

um, was thinking about it, but probably not important enough. Data partitioning is still not wrong, even though end goal is database sharding.