Database sharding is closely tied with database partitioning. Sharding means horizontal partitioning, where each partition is referred to a “shard”. In general, sharding is used in context of a multi-node distributed system, where shards are stored at different locations or nodes. Whereas “horizontal partitioning” is usually used in a single server or node context. Both techniques are used for performance optimization and scalability reasons over very large databases.
For Acho Studio users, once again, partitioning and sharding are backend structures that they do not need to worry about. The Acho team will configure the backend database structure to ensure performance is always optimized for frontend user experiences.