You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@answer.apache.org by "surapuramakhil (via GitHub)" <gi...@apache.org> on 2024/02/06 13:28:20 UTC

[D] How Easy for me to MySQL NDB Cluser [incubator-answer]

GitHub user surapuramakhil created a discussion: How Easy for me to MySQL NDB Cluser

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

GitHub link: https://github.com/apache/incubator-answer/discussions/775

----
This is an automatically sent email for commits@answer.apache.org.
To unsubscribe, please send an email to: commits-unsubscribe@answer.apache.org


Re: [D] How Easy for me to MySQL NDB Cluser [incubator-answer]

Posted by "surapuramakhil (via GitHub)" <gi...@apache.org>.
GitHub user surapuramakhil added a comment to the discussion: How Easy for me to MySQL NDB Cluser

@LinkinStars 

GitHub link: https://github.com/apache/incubator-answer/discussions/775#discussioncomment-8384310

----
This is an automatically sent email for commits@answer.apache.org.
To unsubscribe, please send an email to: commits-unsubscribe@answer.apache.org


Re: [D] How Easy for me to use MySQL NDB Cluser [incubator-answer]

Posted by "surapuramakhil (via GitHub)" <gi...@apache.org>.
GitHub user surapuramakhil added a comment to the discussion: How Easy for me to use MySQL NDB Cluser

No worries. I just asked you because you are the Top Contributor.


GitHub link: https://github.com/apache/incubator-answer/discussions/775#discussioncomment-8384483

----
This is an automatically sent email for commits@answer.apache.org.
To unsubscribe, please send an email to: commits-unsubscribe@answer.apache.org


Re: [D] How Easy for me to use MySQL NDB Cluser [incubator-answer]

Posted by "surapuramakhil (via GitHub)" <gi...@apache.org>.
GitHub user surapuramakhil added a comment to the discussion: How Easy for me to use MySQL NDB Cluser

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 

GitHub link: https://github.com/apache/incubator-answer/discussions/775#discussioncomment-8384588

----
This is an automatically sent email for commits@answer.apache.org.
To unsubscribe, please send an email to: commits-unsubscribe@answer.apache.org


Re: [D] How Easy for me to use MySQL NDB Cluser [incubator-answer]

Posted by "surapuramakhil (via GitHub)" <gi...@apache.org>.
GitHub user surapuramakhil edited a comment on the discussion: How Easy for me to use MySQL NDB Cluser

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



GitHub link: https://github.com/apache/incubator-answer/discussions/775#discussioncomment-8384303

----
This is an automatically sent email for commits@answer.apache.org.
To unsubscribe, please send an email to: commits-unsubscribe@answer.apache.org


Re: [D] How Easy for me to MySQL NDB Cluser [incubator-answer]

Posted by "surapuramakhil (via GitHub)" <gi...@apache.org>.
GitHub user surapuramakhil added a comment to the discussion: How Easy for me to MySQL NDB Cluser

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

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



GitHub link: https://github.com/apache/incubator-answer/discussions/775#discussioncomment-8384303

----
This is an automatically sent email for commits@answer.apache.org.
To unsubscribe, please send an email to: commits-unsubscribe@answer.apache.org


Re: [D] How Easy for me to use MySQL NDB Cluser [incubator-answer]

Posted by "surapuramakhil (via GitHub)" <gi...@apache.org>.
GitHub user surapuramakhil edited a comment on the discussion: How Easy for me to use MySQL NDB Cluser

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 line 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



GitHub link: https://github.com/apache/incubator-answer/discussions/775#discussioncomment-8384303

----
This is an automatically sent email for commits@answer.apache.org.
To unsubscribe, please send an email to: commits-unsubscribe@answer.apache.org


Re: [D] How Easy for me to MySQL NDB Cluser [incubator-answer]

Posted by "surapuramakhil (via GitHub)" <gi...@apache.org>.
GitHub user surapuramakhil added a comment to the discussion: How Easy for me to MySQL NDB Cluser

@LinkinStars 

GitHub link: https://github.com/apache/incubator-answer/discussions/775#discussioncomment-8382776

----
This is an automatically sent email for commits@answer.apache.org.
To unsubscribe, please send an email to: commits-unsubscribe@answer.apache.org


Re: [D] How Easy for me to use MySQL NDB Cluser [incubator-answer]

Posted by "surapuramakhil (via GitHub)" <gi...@apache.org>.
GitHub user surapuramakhil edited a discussion: How Easy for me to use MySQL NDB Cluser

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**

GitHub link: https://github.com/apache/incubator-answer/discussions/775

----
This is an automatically sent email for commits@answer.apache.org.
To unsubscribe, please send an email to: commits-unsubscribe@answer.apache.org


Re: [D] How Easy for me to use MySQL NDB Cluser [incubator-answer]

Posted by "surapuramakhil (via GitHub)" <gi...@apache.org>.
GitHub user surapuramakhil edited a discussion: How Easy for me to use MySQL NDB Cluser

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

GitHub link: https://github.com/apache/incubator-answer/discussions/775

----
This is an automatically sent email for commits@answer.apache.org.
To unsubscribe, please send an email to: commits-unsubscribe@answer.apache.org


Re: [D] How Easy for me to use MySQL NDB Cluser [incubator-answer]

Posted by "LinkinStars (via GitHub)" <gi...@apache.org>.
GitHub user LinkinStars added a comment to the discussion: How Easy for me to use MySQL NDB Cluser

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. 

GitHub link: https://github.com/apache/incubator-answer/discussions/775#discussioncomment-8384408

----
This is an automatically sent email for commits@answer.apache.org.
To unsubscribe, please send an email to: commits-unsubscribe@answer.apache.org


Re: [D] How Easy for me to use MySQL NDB Cluser [incubator-answer]

Posted by "surapuramakhil (via GitHub)" <gi...@apache.org>.
GitHub user surapuramakhil edited a comment on the discussion: How Easy for me to use MySQL NDB Cluser

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


GitHub link: https://github.com/apache/incubator-answer/discussions/775#discussioncomment-8384483

----
This is an automatically sent email for commits@answer.apache.org.
To unsubscribe, please send an email to: commits-unsubscribe@answer.apache.org


Re: [D] How Easy for me to MySQL NDB Cluser [incubator-answer]

Posted by "LinkinStars (via GitHub)" <gi...@apache.org>.
GitHub user LinkinStars added a comment to the discussion: How Easy for me to MySQL NDB Cluser

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.


GitHub link: https://github.com/apache/incubator-answer/discussions/775#discussioncomment-8384130

----
This is an automatically sent email for commits@answer.apache.org.
To unsubscribe, please send an email to: commits-unsubscribe@answer.apache.org