Illustration Image

Cassandra.Link

The best knowledge base on Apache Cassandra®

Helping platform leaders, architects, engineers, and operators build scalable real time data platforms.

2/11/2022

Reading time:2 min

Tools for Administering the Cassandra

by John Doe


 
 Post Views: 
 3,246
 Dear Readers,In this article we will see Advantages of a NoSQL Database over an RDBMS.While there are hundreds of different “Not Only SQL” (NoSQL) databases offered today,Each with its own particular features and benefits, a NoSQL database generally differs from a traditional RDBMS in the following ways:Data model:While an RDBMS primarily handles structured data in a rigid data model, a NoSQL database typically provides a more flexible and fluid data model and is more adept at serving the agile development methodologies used for modern applications. Further, NoSQL is capable of easily consuming and managing all modern data types. Note that one misconception about NoSQL data models is that they do not handle structured data, which is untrue.Architecture:Whereas RDBMS’s are normally architected in a centralized, scaleup, master-slave fashion, NoSQL systems such as Cassandra operate in a distributed, scale-out, “masterless” manner (there is no ‘master’ node). However, some NoSQL databases (e.g. MongoDB, HBase) are master-slave in design.Data distribution model:Because of their master-slave architectures, most RDBMS’s distribute data to slave machines that can act as read-only copies of the data and/or failover for the primary machine. By contrast, a NoSQL database like Cassandra distributes data evenly to all nodes making up a database cluster and enables both reads and writes on all machines. Furthermore, the replication model of RDBMS’s (including master-to-master) is not designed well for wide-scale, multi geographical replication and synchronization of data between different locales and cloud availability zones, whereas Cassandra’s replication was built from the ground up to easily handle such things.Availability model:RDBMS’s typically use a failover design where a master fails over to a slave machine, whereas a NoSQL system like Cassandra is masterless and provides redundancy of both data and function on each node so that it offers continuous availability with no downtime versus simple high availability in the way an RDBMS does.Scaling and Performance model:An RDBMS typically scales vertically by adding extra CPU, RAM, etc., to a centralized machine, whereas a NoSQL database like Cassandra scales horizontally by adding extra nodes that deliver increased scale and performance in a linear manner.Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updatesKTEXPERTS is always active on below social media platforms.Facebook : https://www.facebook.com/ktexperts/LinkedIn : https://www.linkedin.com/company/ktexperts/Twitter : https://twitter.com/ktexpertsadminYouTube : https://www.youtube.com/c/ktexperts 
Note: Please test scripts in Non Prod before trying in Production.

Illustration Image

Dear Readers,

In this article we will see Advantages of a NoSQL Database over an RDBMS.

While there are hundreds of different “Not Only SQL” (NoSQL) databases offered today,

Each with its own particular features and benefits, a NoSQL database generally differs from a traditional RDBMS in the following ways:

Data model:

While an RDBMS primarily handles structured data in a rigid data model, a NoSQL database typically provides a more flexible and fluid data model and is more adept at serving the agile development methodologies used for modern applications. Further, NoSQL is capable of easily consuming and managing all modern data types. Note that one misconception about NoSQL data models is that they do not handle structured data, which is untrue.

Architecture:

Whereas RDBMS’s are normally architected in a centralized, scaleup, master-slave fashion, NoSQL systems such as Cassandra operate in a distributed, scale-out, “masterless” manner (there is no ‘master’ node). However, some NoSQL databases (e.g. MongoDB, HBase) are master-slave in design.

Data distribution model:

Because of their master-slave architectures, most RDBMS’s distribute data to slave machines that can act as read-only copies of the data and/or failover for the primary machine. By contrast, a NoSQL database like Cassandra distributes data evenly to all nodes making up a database cluster and enables both reads and writes on all machines. Furthermore, the replication model of RDBMS’s (including master-to-master) is not designed well for wide-scale, multi geographical replication and synchronization of data between different locales and cloud availability zones, whereas Cassandra’s replication was built from the ground up to easily handle such things.

Availability model:

RDBMS’s typically use a failover design where a master fails over to a slave machine, whereas a NoSQL system like Cassandra is masterless and provides redundancy of both data and function on each node so that it offers continuous availability with no downtime versus simple high availability in the way an RDBMS does.

Scaling and Performance model:

An RDBMS typically scales vertically by adding extra CPU, RAM, etc., to a centralized machine, whereas a NoSQL database like Cassandra scales horizontally by adding extra nodes that deliver increased scale and performance in a linear manner.

Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates

KTEXPERTS is always active on below social media platforms.

Facebook : https://www.facebook.com/ktexperts/
LinkedIn : https://www.linkedin.com/company/ktexperts/
Twitter : https://twitter.com/ktexpertsadmin
YouTube : https://www.youtube.com/c/ktexperts

Note: Please test scripts in Non Prod before trying in Production.

Related Articles

cluster
troubleshooting
datastax

GitHub - arodrime/Montecristo: Datastax Cluster Health Check Tooling

arodrime

4/3/2024

Checkout Planet Cassandra

Claim Your Free Planet Cassandra Contributor T-shirt!

Make your contribution and score a FREE Planet Cassandra Contributor T-Shirt! 
We value our incredible Cassandra community, and we want to express our gratitude by sending an exclusive Planet Cassandra Contributor T-Shirt you can wear with pride.

Join Our Newsletter!

Sign up below to receive email updates and see what's going on with our company

Explore Related Topics

AllKafkaSparkScyllaSStableKubernetesApiGithubGraphQl

Explore Further

cassandra