Can a SQL database really be elastic?
So now that we’ve established the need for an elastic SQL database, the question becomes whether such a thing is even possible.
For those familiar with traditional SQL databases, adjusting for increasing volume has typically been a balance between pre-provisioning and scaling up with new monolithic hardware. As more applications began to require scale-out capabilities, add-on solutions that fit the “distributed but not elastic” database category - such as Oracle Real Application Clusters (RAC) - became available. Yet such solutions added both cost and complexity to the SQL database architecture without providing true elasticity.
While workarounds such as these exist, it has become clear that retrofitting single-server technology for a distributed, cloud-based world often fails to solve the actual problem while adding significant expense and complexity to the architecture.
More recently a new class of SQL databases have emerged that are purpose-built to deliver elasticity, strict transactional consistency, rich ANSI-SQL support, and continuous availability.
These innovative elastic SQL databases enable enterprise application on cloud-style infrastructures and can combine the power, ecosystems, skillsets, and best practices of the traditional SQL database with the benefits of next-generation commodity-based infrastructures.
It’s time for an elastic SQL database. It’s time for NuoDB.