AWS – Using DMS to migrate MySQL 8 on RDS to Amazon Aurora

To migrate MySQL 8 to Amazon Aurora we will be using AWS Data Migration Service (DMS). AWS is currently offering free use for 6 months per instance if you are migrating Amazon Aurora, Amazon Redshift, Amazon DynamoDB or Amazon DocumentDB. For more on this visit this link. Data Migration Service Setup Step 1 – Create…

Read More

AWS – Setup read replica for MySQL on RDS

Step 1 – Setup MySQL Read Replica instance Select RDS MySQL instance Click on Actions > Create read replica Step 2 – Configure read replica DB instance Instance specifications DB instance classSelect Database instance class of your choice. Multi-AZ deploymentChoose Multi-AZ deployment for high availability (i.e. for production workloads) Storage typeChoose Provisioned IOPS (SSD) for…

Read More
SSL

Generating Certificate Signing Request (CSR) and SSL installation on Windows Server IIS 10

Logon to your Windows server and open IIS Step 1 – Select the server (top level) on the Connections pane Step 2 – Double click on Server Certificates Step 3 – Click on Create Certificate Request Step 4 – Fill in details for the certificate Enter the following details: Country/region – This is the two-letter abbreviation…

Read More
SSL

Generating a Private Key and Certificate Signing Request (CSR) in Ubuntu 18.04

Logon to your Ubuntu server using SSH. Step 1 – Setup a new Directory Create a folder to store the files called in home directory called ssl. Go into the newly created directory. Step 2 – Create Private Key Generate a private key by executing the following command. Type in pass phrase. Step 3 –…

Read More

How can I list ALL DNS records?

On Ubuntu or Mac OS use the following commands: or

Read More

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

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

Get a Quote