CockroachDB Architecture and Performance Overview

What is CockroachDB?

An online database management system providing create, Read, Update, Delete (crud) operations that expose the graph data model. Click to explore about, Graph Database Architecture

Why it is important?

What are the key features?

• Simplified Deployment
• Strong Consistency
• Support of SQL
• Distributed Transactions
• Automated Scaling and Repair
• High Availability
• Open Source

How it Works?

• cockroach start with a --join flag for all of the initial nodes in the cluster, so the process knows all of the other machines it can communicate with cockroach init to perform a one-time initialization of the cluster.

Once the process is running, developers interact with CockroachDB through a SQL API. Send SQL RPC requests to any of nodes that are available due to the symmetric function that cockroach had, and this makes Cockroach easy to integrate with load balancers. After receiving SQL RPC requests, nodes convert them into operations that work with its distributed key-value store. As these RPCs start filling cluster with data, cockroach starts distributing data among available nodes, breaking the data up into 64 MiB chunks these chunks are also known as the range.

Each range replicated to at least three nodes. This way if any nodes go down, copies of the data is still there which can be used for reading operations and write operations as well as replicating the data to other nodes. If a node receives a read or writes request, it cannot directly serve. Cockroach finds the node that can handle the requests and communicates with it. Cockroach tracks everything and enables symmetric behavior for each node.

Any changes made to data in a range rely on a raft consensus algorithm to ensure a majority of its replicas or nodes agree to commit the change, ensuring industry-leading (best in this industry) isolation guarantees and providing application consistent reading regardless of which node used for communication. Ultimately, data is read from and written to disk using an efficient storage engine, which can keep track of the data's timestamp. It has the benefit of support the SQL standard AS OF SYSTEM TIME clause allowing and finding historical data for a period.

An online database management system providing create, Read, Update, Delete (crud) operations that expose the graph data model. Click to explore about, Database Testing Types

How does it scale?

It scales horizontally with minimum operator overhead. It runs on any local computer, single server, corporate development cluster, or a private-public cloud. Adding capacity in CockroachDB is as easy as pointing a new node at the running cluster. At the key-value level, it starts with a single, empty range. This unique range eventually reaches a threshold size (64 MiB by default) when data put in a database.

When that happens, the data split into two ranges, each range covering a contiguous segment of the entire key-value space and this process continues indefinitely as new data flows, existing ranges continue to split into new range aiming to keep a relatively small and consistent range size. When any cluster spans multiple nodes, newly split ranges are automatically rebalanced to nodes with more capacity. It communicates opportunities for re-balancing using a peer-to-peer gossip protocol by which nodes exchange network addresses, store capacity, and other information.

How does it survive failures?

Replication

• Different servers tolerate server failures.
• Different servers on different racks within a data center to tolerate rack power/network failures.
• Different servers in different datacenters to endure large-scale network or power outages.

Automated Repair

CockroachDB vs MongoDB vs PostgreSQL

How to install?

The steps to install CockroachDB is defined below:

Download The Binary

• Download its archive for Linux, and extract the binary -

$ wget -qO- https://binaries.cockroachdb.com/cockroach-v2.0.6.linux-amd64.tgz | tar xvz

• Copy the binary into PATH so it's easy to execute cockroach commands from any shell -

$ cp -i cockroach-v2.0.6.linux-amd64/cockroach /usr/local/bin

Use Docker

$ docker version

$ sudo docker pull cockroachdb/cockroach:v2.0.6

• Install Docker for Linux.
• Confirm that the Docker daemon is running in the background -
• Pull the image for the v2.0.6 release of CockroachDB from Docker Hub -

How to get geting Started?

Start First Node

$ cockroach start --insecure --host=localhost

• The --insecure flag makes communication unencrypted.
• cockroach-data directory stores node data.
• --host=localhost conveys node to listen only on localhost, with default ports used for internal and client traffic (26257). HTTP requests from the Admin UI (8080).

Add more nodes to the cluster

$ cockroach start --insecure --store=node2 --host=localhost --port=26258 --http-port=8081 --join=localhost:26257

$ cockroach start --insecure --store=node3 --host=localhost --port=26259 --http-port=8082 --join=localhost:26257

Test the cluster by adding data using SQL

$ cockroach sql --insecure

  
$ cockroach sql --insecure --port=26258

Step 4 -> Stop the clusters

$ rm -rf cockroach-data node2 node3

Overview of Admin UI 

• Node Map
• Cluster Health
• Hardware Metrics
• Runtime Metrics
• SQL Performance
• Storage Utilization
• Replication Details
• Node Details
• Database details
• Statement details

Decisions Through Data-Small data, Predictive modeling expansion, and real-time analytics are three forms of data analytics Healthcare data will continue to accumulate rapidly. Click to explore about, Big Data and Predictive Analytics Solution

Concluding 

It is easy to get started, and it is a fully distributed SQL database. It works well with Containers like Kubernetes. It is compatible with Postgresql. It has a fault tolerant system, very sophisticated replica placement rules. It is Cloud-ready and fully Open Source. CockroachDB is an excellent database to use.

• Click To explore about Performance Tracing Tools
• Explore more about various types of Databases