It is a constant, yet interesting debate in the world of big
data. What scales best? OldSQL, NoSQL, NewSQL?
I have a longer post coming on this soon. But for now, let
me make the following comments. Generally, most data
technologies can be made to scale - somehow. Scaling up
tends not to be too much of an issue, scaling out is where the
difficulties begin. Yet, most data technologies can be
scaled in one form or another to meet a data challenge even if
the result isn’t pretty.
What is best? Well that comes down to the resulting
complexity, cost, performance and other trade-offs.
Trade-offs are key as there are almost always significant
concessions to be made as you scale up.
A recent example of mine, I was looking at scalability aspects of
MySQL. In particular, MySQL
Cluster. It is …[Read more]