Category: NoSQL

AWS
Cloud
Datastax
NoSQL
May 28, 2019

How to create a simple Cassandra Cluster on AWS

What is Cassandra? Apache Cassandra is a free and open-source distributed wide column store NoSQL database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure. Wikipedia Apache Cassandra is a high performance, extremely scalable, fault tolerant (i.e. no single point of failure), distributed post-relational database solution. Cassandra […]

Read More
Database
NoSQL
July 16, 2018

A Manager’s Guide to the Database Galaxy in the Cloud – Part 7 (NoSQL – Graph Databases)

PART 7 In the last few blogs we examined a variety of different NoSQL databases and considered some of their appropriate domains and use cases. In this edition we conclude our multi-part database blog series by considering Graph database offerings from different vendors. This is done in an attempt to highlight some of the key […]

Read More
Database
NoSQL
July 10, 2018

A Manager’s Guide to the Database Galaxy – Part 6 (NoSQL – Key Value Stores)

PART 6 In the last blog we considered different Wide Column Store databases and examined some facets of performance and associated costs. In this blog we look at another type of NoSQL databases, the much simpler Key Value Stores. Offerings from different vendors and examined in an attempt to highlight some of the key differences […]

Read More
Database
NoSQL
June 29, 2018

A Manager’s Guide to the Database Galaxy – Part 5 (NoSQL Wide-Column Stores)

PART 5 In the last blogs we examined a variety of different database types and considered some of their appropriate domains and use cases. In this blog we look at actual NoSQL Wide Column Store offerings from different vendors, in an attempt to highlight some of the key differences between otherwise similar technologies. We also […]

Read More
Benchmarking
Datastax
NoSQL
March 12, 2018

Datastax Cassandra benchmark on OCI

In this blog, we show how we created a Datastax Cassandra cluster on Oracle Cloud Infrastructure (OCI) using Terraform and benchmark Oracle Cloud baremetal machines running Cassandra stress. 1. Steps to Create the Cluster Go here to download the Terraform projectFollow the guide to setup your environment Edit the file env-vars and fill in all the relevant […]

Read More
Database
NoSQL
February 10, 2018

A Manager’s Guide to the Database Galaxy – Part 4 (NoSQL Document Stores)

PART 4 In the last blog we examined different relational database offerings and considered some of their unique features and differences. In this blog we will compare and evaluate different NoSQL offerings, starting with Document Stores. This is done in an attempt to highlight some of the key differences between otherwise similar technologies. We also […]

Read More
NoSQL
Spark
October 20, 2017

Spark SQL Query Explain Plan

DSE 5.0.6, Spark 1.6.2 Example 1 From cqlsh, below query works Below query does a Full Table Scan(FTS) Below query does not do FTS, because leading partition key column is txn_status Below query does not return result at all if txn_date is not cast Example 2 Example 3 Example 4 Example 5 CATEGORIES

Read More
AWS
Datastax
NoSQL
October 7, 2017

Datastax Spark on AWS

Configuration: DSE 5.0.6 (See Datastax Cassandra on AWS for Installation Details) so when you start dse spark or dse spark-sql, in spark UI, you can see 3 out of 4 cores allocated Verification: Finding the spark master Spark Web UI: http://<node1>:7080Now in http://:4040/stages/, we can see 1 Fair Scheduler Pool, with schedule mode as FAIRFrom AWS […]

Read More
AWS
NoSQL
September 24, 2017

Datastax Cassandra on AWS

Setting up AWS EC2 Instance Type: m4.xlarge, 4 node cluster, 2 in each AZStorage: Two EBS volumes, data volume 400GB, 150GB log volume, root volume 150GB (General Purpose SSD)OS:Amazon Linux AMI 2016.09.0 (HVM), SSD Volume Type – ami-b953f2daThe Amazon Linux AMI is an EBS-backed, AWS-supported image. The default image includes AWS command line tools, Python, Ruby, Perl, […]

Read More