Designing an effective data model is imperative to scale any application. This is true both in the relational and non relational world. Data modelling in Apache Cassandra is no different than any relational database. It requires a good understanding of the target domain and usage patterns within the domain. A deep understanding of your target […]
Debugging Transactional And Locking Issues in MySQL
Introduction Database transactions are a logical unit of work or a group of related changes executed against a database. Transactions enable us to execute reliable units of work against a database and recover in case of failures. Transactions are “all-or-nothing” i.e they enable us to either execute all changes within the logical group or have […]
A Practical Introduction To Cassandra Query Language
Cassandra Query Language (CQL) Tutorial is an updated version of this tutorial. It is applicable to Apache Cassandra version 3.x and above. Continue to use this tutorial if you are using Apache Cassandra version 2.x.x. Introduction In two earlier posts, An Introduction To Apache Cassandra and Apache Cassandra Architecture, I provided a theoretical overview of […]

Apache Cassandra Architecture
Introduction An Introduction To Apache Cassandra , introduced us to various types of NoSQL database and Apache Cassandra. In this article I am going to delve into Cassandra’s Architecture. Cassandra is a peer-to-peer distributed database that runs on a cluster of homogeneous nodes. Cassandra has been architected from the ground up to handle large volumes of data while providing […]

Five Ways of Installing Apache Cassandra for Development Purposes
The best way learn about Apache Cassandra is to install and play with it. We will cover five ways to install Apache Cassandra for development purposes. The five ways covered are : Installing a single node Apache Cassandra on your development machine. Installing a multi node Apache Cassandra cluster on your development machine. Running Apache Cassandra in Eclipse Installing a multi node […]

An Introduction To NoSQL & Apache Cassandra
Introduction For over thirty years Relations Database Management Systems (RDBMS) has been the de facto choice for an applications data storage needs. In the recent years RDBMS domination over the storage space has been challenged due to need to store huge amounts of structured, semi structured and unstructured data. The recent explosion in data, both […]

Architecture of a Relational Database Management System
Relational Database Management Systems (RDBMS) have been around for over 20 years. RDBMS were one of the first multi-server multi user systems developed. Although a number of alternatives exist an RDBMS is still widely used. It is still the de facto storage engine for most applications. RDBMS have greatly evolved over the past 30 years. […]