IS noSQL a better choice when considering sharding

Rohit Bajaj
Rohit Bajaj used Ask the Experts™
on
HI,
Need experts view on the following line  -
Most NoSQL solutions however are built with the assumption that the data does not fit on a single machine and hence have sharding builtin.

Is it that noSQL solutions have easier or better sharding capabilites than relational databased like mysql ?

And should one use noSQL always in case of sharding ?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
it is better to consider on example.
Mongo is noSQL solution. Look these articles:
https://www.mongodb.com/compare/mongodb-mysql
https://www.upwork.com/hiring/data/sql-vs-nosql-databases-whats-the-difference/
Distinguished Expert 2018
Commented:
Relational databases also offer sharding. I know for sure Oracle does (not by default though), MySql also does as well (again, not by default I think). I am not sure if NoSql databases have better sharding capabilities or not, I still haven't seen a comparison of NoSql Sharding vs RDBMS Sharding.

And should one use noSQL always in case of sharding ?

It depends. Sharding exists naturally in RDBMS, when you do a JOIN this is essentially sharding. But I guess you're talking about sharding as in different physical machines. You should use NoSql if transactions and ACID is of no concern to your application, not just sharding.

Commented:
There is no activity from author.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial