Best of both worlds?
Can NuoDB make relational databases cool again?
With the rise of the NoSQL database in the last decade, the number of people wanting to dabble with nonrelational datastores is undeniably increasing. Yet moving across from the familiar SQL surroundings of a relational database can often be a traumatic process, due to the starkly different models. Many organisations will ignore the lure of NoSQL entirely, opting for the safety of strong transactions instead.
Consequently, another set of databases are gaining prominence. The nauseatingly-coined NewSQL database crowd aim to be the best of both worlds, providing the scalability benefits NoSQL databases claim but with the tried and trusted ACID and SQL query capabilities of a relational counterpart.
The standout new arrival however is the preview of Tungsten Replicator, NuoDB’s high-performance data replication engine for MySQL, that includes global transaction IDs to support failover and sharding. The open source project supports a live replication of a MySQL databases to NuoDB, and the two running side-by-side.
Speaking to Application Development Trends, NuoDB co-founder Barry Morris said he believes “the NoSQL guys threw the baby out with the bathwater.”
"Just because traditional SQL databases don't scale, that doesn't mean that SQL doesn't scale. It means that the old designs don't scale."
In July, NuoDB went on a charm offensive towards organisations still reliant on SQL, with the unveiling of a beta migration program. The open source tool allows companies to part with their traditional database system (MySQL, Microsoft SQL Server, IBM DB2, PostgreSQL and Oracle RDBMS) for NuoDB with minimum fuss. Plenty of NoSQL companies, DataStax and 10gen for example, have realised the importance of that providing a relatively pain-free transition between the monolithic structures of old to the flashy modern alternative.
NuoDB could well be onto a winner by providing a halfway house for scaling out, but is in equal danger of being lost in the noise created by NoSQL solutions such MongoDB and Cassandra. Morris told the Register last month that NuoDB had worked with “20-to-30” customers looking to move away. While this figure shouldn’t be written off, there needs to be a large increase if NuoDB and others really want to see Oracle’s empire crumble.
NuoDB comes in three flavours - an free open source project, a commercial pay-as-you-scale version and an Amazon Web Services ‘Cloud’ Edition.