Blog Category

Viewing blog posts in a specific category.

Verify Connection to MySQL is Encrypted

Posted in AWS, Cloud Computing, MySQL on Jul 15, 2018

How to Verify MySQL Connections are Secure?. These steps can be followed to verify client connections to MySQL Server are using SSL and verify all the data over the wire is encrypted.

Hosting Website from Home

Posted in AWS, Cloud Computing on Apr 15, 2018

I was hosting site from AWS on m3.xlarge Instance. Even though its reserved instance , the cost of hosting has crossed the threshold limit of hobby project. So I have decided to host the site from Home . In this blog post, I am sharing my experiences with hosting the website from Home instead of public cloud provider.

Bulk Load Data Files in S3 Bucket into Aurora RDS

Posted in AWS, Cloud Computing on Jul 15, 2017

We typically get data feeds from our clients ( usually about ~ 5 - 20 GB) worth of data. We download these data files to our lab environment and use shell scripts to load the data into AURORA RDS . We wanted to avoid unnecessary data transfers and decided to setup data pipe line to automate the process and use S3 Buckets for file uploads from the clients.

AWS RDS First Touch Penalty

Posted in AWS, Cloud Computing, SQL Server on Aug 03, 2016

The first time a DB instance is started and accesses an area of disk for the first time, the process can take longer than all subsequent accesses to the same disk area. This is known as the “first touch penalty.”

AWS SQL Server Native Backup Restore

Posted in AWS, SQL Server on Jun 30, 2016

These are the steps I followed to enable Native Backup and Restores on AWS SQL Server RDS 1. Created NativeBackupRestore Role and Enabled S3 Bucket Access 2. Created Custom Options Group and enabled to use the NativeBackupRestore Role 3. Modified existing instance to use custom options Group. 4. Successfully Backed up the Database from RDS Instance to S3 Bucket 5. Successfully Restored Native Backups on S3 on SQL Server RDS.