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