The case study reflects a business problem a fictious manufacturing customer is facing to solve by enabling cloud technology.

Business Problem:

  • EarthBuild is a fictional heavy equipment manufacturing company operates mainly in two industries — construction (80%) and building automation(20%). They are also planning on launching new industry sub-verticals in precision tools, home and building security.
  • Currently they have 1000 dealers in 50 countries. Supports 30 million EarthBuild equipment and devices.
  • Approximately 60,000 (2%) vehicles are connected to cellular network to collect data directly through maintenance port and upload to FTP server with 100 fields of data for 18 hours a day…

The case study illustrates a business case study of a fictious manufacturing customer who is facing a business problem and finding a way to solve it by enabling cloud technology.

Business Problem:

  • EarthBuild is a fictional heavy equipment manufacturing company operates mainly in two industries — construction (80%) and building automation(20%). They are also planning on launching new industry sub-verticals in precision tools, home and building security.
  • Currently they have 1000 dealers in 50 countries. Supports 30 million EarthBuild equipment and devices.
  • Approximately 60,000 (2%) vehicles are connected to cellular network to collect data directly through maintenance port and upload…

In this example. I will illustrate steps to

  1. download RDS SSL certificates
  2. Add them to java key store
  3. Configure JDBC configuration to use SSL certificates
  4. Test whether a database client connection is in encrypted mode

Download SSL certification the AWS site below

Next download mysql & postgres database JDBC drivers (We test both database connections) and stage them in a director.

For example mysql jdbc driver setup

Next add RDS certificate to java keystore

Next test the connection. As of mysql version 5.6, there isn’t a table store client connections data to query. …


The slides are an example of how to deploy MongDB cluster on AWS using cloud formation templates


In this example a containerized python application deployed on AWS ec2 instance(s) to access database password using SecretManager will help avoid security risks with typical deployment config as part of image builds.

The idea is to separate sensitive dependencies and access keys from deployment using a secret vault such as AWS secret manager service and use an API to get access to database on demand.

In this diagram below, getPassword() method is an API call to get database user password from secret manager AWS service to connect to source and target databases. Not all components mentioned below are covered in…


Before you get started, install required Azure tools to access services on Azure cloud

When ready, login to Azure cloud using az login. You will see something like below output on Mac OS X

Create service principal set environment variables. for example

Terraform AKS declaration

Kubernetes app deployment declaration

Create AKS infrastructure and deploy app docker image into AKS cluster


Programming tools and libraries used in this example

Python, Flask* libraries, HTML, YAML, SSL certificates

Flask is a micro web framework written in Python. It is classified as a micro-framework because it does not require particular tools or libraries. It has no database abstraction layer, form validation, or any other components where pre-existing third-party libraries provide common functions.

Flask aims to keep the core simple but extensible. Flask won’t make many decisions for you, such as what database to use. Those decisions that it does make, such as what templating engine to use, are easy to change.

As your codebase…


Deployment workflow diagram

Image for post
Image for post
  1. Build Docker file for Go lang web app

2. Build image, add tag and push docker image to GCR (Google Container Registry)

GuestBook Go webapp pod declaration

GuestBook Go webapp service declaration

3. Create WebApp pod(s) & WebApp service (Load Balancer)

5. Testing App ..

Go WebApp URL


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 data storage platform always available and fault tolerant highly resilient to single point of failures on open cloud platform.

Though, AWS Aurora fits into some of the features mentioned above and able to scale up to 15 replicas, I often tend to ask the question myself, what is the point…

@kondlawork

I am a software engineering manager, and cloud architect who design, build, deploy, scale ,simplify and cost optimize platform architecture.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store