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.

Read More

Let’s say you’ve recently moved your application to the cloud. You’re probably thrilled to no longer worry about hardware upgrades, maintenance, or backups. In fact, having your data in the cloud can (and should) make your life easier.

But with a flourishing company, your database will likely grow rapidly with more users and more transactions. Can your cloud service provider meet the demand? Will your database scale?

Read More

Scalebase was recently mentioned in Paul Burns article, ‘Shard’ Your Database & Speed Analytics Processing, on All Analytics.com

Check around, and you’ll see a small but growing number of companies — as well as open-source offerings — that deliver various types of sharding support. Some companies provide automatic sharding, which removes the difficulty of partitioning a database into shards. ScaleBase, for example, provides automated sharding and a platform that isolates applications from any changes. This means analytics applications can take advantage of sharded databases without any code changes.

Read the full article to learn more about database sharding and how this technique can help boost performance of your analytics environment.