Growth comes with success and we love to see it — and as your business expands, so does your database, increasing both concurrent connections and transactions. In previous blog entries, we’ve discussed a few MySQL database scaling strategies and how database sharding solves scalability issues, and how easy it is with ScaleBase automation.
One Server or Many?
With database sharding, the individual shards — a.k.a horizontal partitions of data — are typically created with the vision of being placed on multiple machines for massive parallelization of data processing and storage. But, there are also valuable benefits from running a sharded database where all shards are on a single server.