Author Archives: Sudheer Kondla

Stack used: Terraform, kubectl, YAML, Redis cluster, Python & Go Lang Initialize terraform: Before apply dry run terraform with “plan” option terraform apply to create/modify k8s stack Now Connect to google cloud and browser based authentication from a token Set the project & get creds Add extra pool Deploy Redis Deploy Python docker container: BuildContinue reading “Deploying Apps on Google Cloud – Kubernetes Engine”

Before we begin, understand the CAP theorem CAP (Consistency, Availability and Partition Tolerance), the foundation behind the design of a distributed database system. The foundation of a distributed system is based on the CAP theorem (illustrated in the following diagram), which states that it is impossible for a distributed computing system to simultaneously guarantee Consistency,Continue reading “Cassandra Architecture & Operational Best Practices”

This document helps you understand tools needed to maintain Cassandra cluster. Following tools you may use to maintain Cassandra ring. Tools: nodetool: The nodetool utility is a command line interface for managing a cluster. refer “nodetool help” for more options with node tool. Listed below some of the nodetool command option you would most likely use.Continue reading “Cassandra Tools & Maintenance”

Consistency levels in Cassandra can be configured to manage availability versus data accuracy. Configure consistency for a session or per individual read or write operation. Within cqlsh, use CONSISTENCY, to set the consistency level for all queries in the current cqlsh session. For programming client applications, set the consistency level using an appropriate driver. For example, using the Java driver, call QueryBuilder.insertInto with setConsistencyLevel to set a per-insert consistency level.  The consistency level defaults to ONE for allContinue reading “How the Cassandra consistency level configured”

As of writing this article around mid-march 2019 You can create an Amazon Aurora DB cluster as a Read Replica in a different AWS Region than the source DB cluster.  Taking this approach can improve your disaster recovery capabilities, let you scale read operations into a region that is closer to your users, and makeContinue reading “Replicating AWS Aurora DB Clusters Across AWS Regions”

I came from world of Oracle technology stack where I worked a long time with Oracle RAC clusters on Linux/Exadata platforms until I stared to look at open source world on cloud infrastructure few years ago. Like many, I was thinking, what would it take me to build a scalable database storage platform always availableContinue reading “AWS Aurora DB cluster Scaling”

I started to think about how I can make database service requests more agile and self served. As a Cloud Data platform architect I have access to full resources however, often times I overwhelmed with requests people think I am responsible for , but I am not really, the DBAs are. The point I amContinue reading “Automated snapshots using Python Flask Web API/Curl”

The web interface (HTML) or CURL command can be used to request for a Restoring a database instance from cluster and non-cluster database instances Checking the status of the restore from step 1. Attaching an instances to already existing dB cluster  The API app is written in Python using Flask Web Frame work and blueprintsContinue reading “Automated Restores with Flask web App API”