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

Upgrade MySQL 5.5 to 5.6 on Ubuntu 14.04

Confirm MySQL version Take a backup of all databases Login to MySQL and confirm version. List databases

Read More
Relational Database My SQL

Reset lost MySQL root password on Ubuntu

To reset lost MySQL root password you will need admin access to the Ubuntu server. Execute this command to reset root password System will prompt to enter a new password. Repeat password.

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

Create an EC2 instance (Ubuntu 16) on Amazon Web Services

Login to AWS console and click on Services menu. Step 1 – Select Region of your choice. Step 2 – Create Virtual Private Cloud (VPC). Step 3 – Create EC2 instance Click on EC2 under Compute. Step 4 – Click on Launch Instance button. Step 5 – Choose an Amazon Machine Image (AMI). In this…

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
Application development on Mac

Setup MySQL 5.5 or 5.6 on Docker on OS X

Docker install link https://docs.docker.com/docker-for-mac/install/#what-to-know-before-you-install use Get Docker for Mac (Stable) After you install Docker check if Docker is installed correctly by running command To install MySQL v5.5 on Docker run the following commands. The following will install a Docker container called dock-mysql run To install MySQL v5.6 on Docker run the following commands. The following will install…

Read More

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

Get a Quote