Tech Creations: Expert IT Support for SMEs

Tech Creations stays at the forefront of IT management practice & technology.

All of our team regularly participate in training programs, skills development sessions, and industry seminars to maintain and develop our skills and ensure that we are up-to-date with the latest developments and technologies.

For the latest news from Tech Creations and the industry, please subscribe to our newsletter using the form below.

In our blog section, you will find articles that we have written or selected – please contact us if you would like any additional information on a topic or would like to discuss how it may apply to your business.

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
API

RESTful Services Development Environment Setup using Spring STS, Tomcat 7, Maven on OSX

1) JDK pre-requisite http://www.oracle.com/technetwork/java/javase/downloads/jdk10-downloads-4416644.html (JRE is not enough) 2) Download Spring STS https://spring.io/tools/sts 3) Download Tomcat 7 from http://tomcat.apache.org/download-70.cgi 4) Extract to a Tomcat folder called Tools in Workspace 5) Setup Spring STS IDE 6) Click on Create New Server under Servers pane 7) Configure the location of Tomcat to the extracted location in Step 3 8) Download Maven https://maven.apache.org/download.cgi 9) Extract to a Maven folder called Tools in Workspace 10) On…

Read More

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

Get a Quote