Data Science

How To Create Your Own Personal Data Science Computing Environment In AWS

Running a training algorithm is such a time-consuming task when you are building a machine learning application. If you are developing it with your computer, you cannot do anything else for a long period of time (hours and maybe days) on that machine. Especially when we do parallel processing using …

AWS

How To Configure Network Access Control Lists (NACLs) and Security Groups in AWS

After setting up VPC, Internet Gateway, Subnets, Route Tables (see here), we need to set up Network Access Control Lists (NACLs) for the subnets and Security Group for EC2 and RDS. This is a step in How To Create Your Personal Data Science Computing Environment In AWS. NACLs are at …

AWS

How To Launch RDS Instance In a Specific Subnet

Let’s launch a Postgres RDS in AWS. You will get 750 hours of Amazone RDS Single-AZ db.t2.micro instance as part of 12 month free tier. You also have a bit of options (MySQL, MariaDB, or SQL Server). I am choosing Postgres here. Amazon RDS makes it easy to set up …

AWS

How To Launch an EC2 Instance From AMI in AWS

Let’s launch an Linux EC2 Instance From AMI. In this example, I am launching Linux Centos 7 from Amazone Machine Image. You can choose whichever OS you want for the use case we’ve been working on here. As a reminder, this is the plan. We are going to launch EC2 …

AWS

How To Attach EBS Volume to EC2 Linux Instance In AWS

Let’s create Elastic Block Store (EBS) volume and attach it to Linux. An EC2 instance comes with a storage. But, this storage only persists with the instance. If you need to terminate the instance and start a new one, you will loose the data. If you keep the data in …

AWS

How To Create and Configure VPC and Subnets In AWS

To create VPC, you first need to specify IP range. Each subnet takes IP range within the IP range of VPC. Before you decide the IP range, it is a good practice to plan first. You need to use CIDR notation for IP range. There is a cool tool to …

AWS

How To Create Admin User In AWS

After you create an AWS account, the best practice is to lock away the root account credential (which you used to create the account) and never use it to do your daily tasks. Instead of using the root account, you should create an admin account with all access. To create …

DBA

How To Create User Credentials And Grant Privileges In Postgres

Creating user credentials and grand privileges in Postgres can be tricky. You have to make sure each user has the right access level to the right tables and schemas. Each database works differently even they all are relational databases. Postgres has its own way of creating users and granting privileges. …

php

How To Migrate WordPress MySQL Data From Production To Sandbox With Talend

Once you create a sandbox environment in your server for WordPress and copied all the files from production, it’s time to copy the production data into the sandbox database. There are many ways to do this. I decided to use Talend Open Studio to insert production data into the sandbox …

php

How To Create a Sandbox Environment For WordPress

When you play with different layouts, content delivery methods or backend logics with WordPress without affecting your public facing site, it is handy to have a sandbox environment where you can go nuts without affecting your production environment. There are many ways to create a sandbox environment. You can created …