Extracting hosted zone records from AWS Route 53

Install AWS CLI on a linux machine. Get the hosted zone ID for the hosted zone by logging onto AWS console and navigating to Route 53 panel. Ensure that AWS CLI user has permissions to read Route 53 records. You can attach AmazonRoute53ReadOnlyAccess policy to the user. Run the following command to get the output…

Read More
No SQL

Why use NoSQL Database?

Use NoSQL when you have the following need Key-Value store Denormalised cache Personalisation Content management Log store Unstructured big data At Tech Creations we are using MongoDB NoSQL database to store personalisation information in our product Flair Bots. We do this by having a Personalisation micro service that stores the personalised user information (Eg. preferred…

Read More

Setup MongoDB on Ubuntu 16.04

MongoDB is a NoSQL database technology. Why use it? You can setup Ubuntu 16.04 on Amazon Web Services (AWS). Step 1 – Add repository Output after adding repository Step 2 – Create a list file for MongoDB Output Step 3 – Reload local packages Step 4 – Install latest version of MongoDB Step 5 –…

Read More
Relational Database My SQL

Resolve MySQL 5.6 Contention Issues

Default transaction isolation level in MySQL 5.6 is REPEATABLE-READ. This setting can cause contention issues and has impact on both read and write queries. As a good practice you can set the default transaction isolation level to READ-COMMITTED as this is less expensive in terms of performance compared to REPEATABLE-READ. If you have long running…

Read More
Relational Database My SQL

Resolve performance or time out issues in MySQL 5.5 on Ubuntu

Common issues to look out for when you are using MySQL are as follows: too many connections waiting for table metadata lock slow running queries As a diagnostic step run these commands after you login to MySQL server to get detailed information run to get detailed information and to filter using WHERE clause run To…

Read More
Containers

Useful Docker commands

List Docker commands Verify Docker Version Docker system wide information Resource utilisation statistics List all containers (running and non-running) List running containers Stop a container Start a container Restart a container Kill a container Remove a container Download Docker container List all Downloaded Docker container images

Read More

Tech Creations
IT Support You Can Rely On
Call 1300 855 135

Get a Quote