Originally Written by Tony Barbagallo
If a business uses a cloud database—whether delivered as a service or managed traditionally through a public or private cloud—chances are it is going to be an SQL one.
According to a recent survey of 500 developers, 79 percent were using a SQL database—either MySQL or NewSQL—while only 16 percent said they were using NoSQL. At one point in time, industry pundits speculated as to whether NoSQL would threaten SQL’s dominance of the database market. Based on the previous results, this is no longer thought to be the case.
So why hasn’t NoSQL gained much traction? Perhaps because of the rise of NewSQL, the scale-out relational cloud database that is proving its merits in e-commerce applications.
Like traditional RDBMS’s such as MySQL, NewSQL ensures that all transactions that occur in the cloud database are ACID-compliant, as they guarantee atomicity, consistency, isolation and durability (ACID) during each transaction. NoSQL cannot ensure ACID compliance, and as such is a non-starter for e-commerce applications.
Correspondingly, because of the evolution of technology and the rise of Big Data, MySQL has reached its limits. It cannot scale horizontally or process large amounts of data concurrently. NewSQL, on the other hand, scales horizontally and is able to accommodate large amounts of transactions. It also ensures an optimal e-commerce experience for customers.
Therefore, NewSQL is the answer for e-commerce retailers that want to ensure that their cloud databases can accommodate traffic spikes, whether occurring predictably or not. A seller of school supplies can assume that business will pick up in August every year. However, a small retailer that makes hand-knit ties, for example, might be surprised to have a product “go viral,” and be suddenly inundated with Internet traffic.
As the need for stronger, faster and more versatile cloud databases continues to proliferate, it’s likely even more companies will turn toward NewSQL to enhance their e-commerce operations.