Ralph

Ralph

Techno-babble for the Masses!


Navigation
CategoryGeneral

General

Featured

Rsync to AWS EC2 Using .PEM key

Posted byuserRalph 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 […]

General

Featured

Safely Restart a MySQL Slave Server

Posted byuserRalph 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 […]

General

Featured

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

Posted byuserRalph 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, […]

General

Featured

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

Posted byuserRalph 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/

General

Featured

Getting a Static IP Address in Nigeria

Posted byuserRalph 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.