Ralph

Ralph

Dispatches On Everything Tech!


Navigation
Featured

General

Rsync to AWS EC2 Using .PEM key

Posted on March 2nd, 2017.

How to use Rsync with standard Amazon Web Services instances that utilise a .pem key file instead of traditional username/password authentication or conventional SSH key pairs: The standard AWS EC2 instances support using a .PEM key to log in, instead of a more common SSH username/password combination. If you want to use Rsync to transfer […]

Featured

General

Safely Restart a MySQL Slave Server

Posted on June 7th, 2016.

Ensure it’s not accessible by any clients, if you use a load balancer, you should take it off temporarily. Connect to the MySQL Server via the command line: Stop the replication: Now is a good time to make any changes you want to. Resume replication: Check the status to confirm replication is running normally, and […]

Featured

General

Painlessly Transfer a Heroku Postgresql DB to a Virtual Private Server (VPS)

Posted on June 2nd, 2016.

After spending hours researching a method to easily transfer (backup / restore) a heroku postgresql database to a VPS, I finally found a quick way to do it that didn’t involve tons of errors about version mismatches, incomplete restores (using psql), and etcetera. I’m documenting this here in case I need to refer to it, […]

Featured

General

How To: Install “Log.io” on Ubuntu 14.04

Posted on November 6th, 2015.

This tutorial presents the steps to install and monitor local log files in real time from a browser using Log.io – For information on Log.io and how it works, see its home page: https://logio.org/

Featured

General

Getting a Static IP Address in Nigeria

Posted on October 27th, 2015.

Chances are you’re reading this because you’re interested in obtaining a static IP address from a Nigerian based Internet Service Provider (ISP). Continue reading if you’re interested in the requirements as well as the uses and advantages.