How Easy for me to use MySQL NDB Cluser

[surapuramakhil]

Can I know weather back-end code designed keeping NoSQL databases in mind? will there be any problem of using NoSQL db engine when it comes to user functionality

Edit:
Even though I marked Answer. its confusing what Answer it is. So I am Adding this. Answer is
Sorry to say, I haven't tested or considered using MySQL NDB Cluser

[surapuramakhil]

@LinkinStars

[LinkinStars]

I'm not quite sure what the definition of NoSQL databases means in relation to what you're talking about. To my knowledge, NoSQL means the key value database or cache. With this knowledge, Answer is not supported to save all data to key-value DB. Of course caching is fine.

But then I see that your title says MySQL NDB Cluser , and I'm confused. Obviously MySQL NDB Cluser is not a NoSQL database. So, sorry, maybe there are still some issues with my understanding. Maybe you can continue to describe your problem a bit more.

[surapuramakhil]

when I say NoSQL. Here are the Major differences.

1. CAP theory - RDBMS Consistency over Availability, in NoSQL Availability over Consistency -> Usually done by Eventual consistency
2. NoSQL doesn't support database Transactions quite well they do Read Commit (It depends from implementation i.e database type)
3. Through put - Trade off for transactions which you get higher read and write speeds
4. Distributed database functionality etc

Also there are other differences like Normalized vs Denormalised. Also Foreign Key support etc

Mysql Added NDB engine for NoSQL support (NoSQL means Not Only SQL)
https://www.mysql.com/products/cluster/nosql.html

[surapuramakhil]

@LinkinStars

[LinkinStars]

Answer also just uses the github.com/go-sql-driver/mysql engine for access DB. If the MySQL NDB Cluser protocol is no different from MySQL itself, I don't think the upper tier applications should care what the underlying database is. Sorry to say, I haven't tested or considered using MySQL NDB Cluser so I can't give you any more suggestions.

[surapuramakhil]

No worries. I just asked you because you are the Top Contributor. you are the one who knows this system pretty well

[surapuramakhil]

And when it comes to your another statement "I don't think the upper tier applications should care what the underlying database is"
its not true. Upper tier applications rely on guarantee of lower tier applications. it there is a miss match when it comes to db usually data corruption is seen