Category Archives: Sys Admin

How to Stop/Start an AWS EC2 instance using AWS CLI command line

by Laurence Posted on February 3, 2023

In my experience the smaller the AWS EC2 instance the more often it freezes / completely locks up. Something goes wrong inside the AWS infrastructure and poof, no ability to SSH or do anything with it. This is regardless of … Continue reading →

Posted in Sys Admin, Work | Tagged aws, command line | Comments Off

Windows 10 Updates Failing with MEMORY_MANAGEMENT due to DiskCryptor

by Laurence Posted on May 5, 2018

Having problems updating to Windows 10 1703, 1709 or 1803? If you have DiskCryptor installed the updates will fail with the unhelpful message `MEMORY_MANAGEMENT`. Then you’ll be trapped in a kind of Windows Update purgatory: Windows downloads update (30 minutes – 1 … Continue reading →

Posted in Sys Admin | Tagged encryption, Windows10 | 1 Comment

How to require SSL when connecting to MySQL on AWS RDS

by Laurence Posted on August 19, 2017

With MySQL you can opt to connect to the database using an encrypted connection. This option is important to consider on AWS if you are using RDS for your MySQL database. The network between your EC2 server and the RDS server … Continue reading →

Posted in Application Development, Data, Sys Admin | Tagged encryption, MySQL | Comments Off

DBAs are Out of Style and Now There’s a Hole In Your Database

by Laurence Posted on July 5, 2017

The concept of a DBA – database administrator, has practically gone out of style as a full time job. DBA work, if it is being done, is handled by someone or something else, perhaps in a more vanilla way that … Continue reading →

Posted in Application Development, Data, Sys Admin | Tagged aws, career, databases, development | Comments Off

Ping your sitemap to Google and Bing with a bash script

by Laurence Posted on December 11, 2016

If you are using a sitemap.xml file you know you need to submit it to the search engines on a regular basis (say nightly). This is done via a GET request to each search engine’s ‘ping’ URL. Many of the … Continue reading →

Posted in Sys Admin | Tagged business, command line, linux | Comments Off

Sending emails through Comcast on Ubuntu using ssmtp

by Laurence Posted on February 14, 2015

Ssmpt is a light weight mail package that is easy to configure and suitable for my needs during local development. It is basically a mail forwarder, can’t receive email, and has very few settings relative to a program like sendmail. … Continue reading →

Posted in Sys Admin | Tagged linux, tools | Comments Off

How to setup the MySQL data directory to be in your encrypted home folder on Ubuntu 14.04

by Laurence Posted on November 11, 2014

Ubuntu has built in home folder encryption similar to OSX. I always turn on this feature on both OSs and have never experienced any perceptible performance hit. This guide shows one approach to migrating the MySQL data directory into the … Continue reading →

Posted in Sys Admin, Work | Tagged encryption, linux, MySQL, security, tools | Comments Off

Ever heard of inodes? You need lots of them.

by Laurence Posted on May 17, 2014

Ran into a situation on a customer’s CentOS server the other day where a service wasn’t working. Symptoms and error messages indicated the disk was full. However ‘$ df -h’ was showing ample free space. What the heck? Turned out … Continue reading →

Posted in Sys Admin | Tagged command line, linux, tools | Comments Off

Category Archives: Sys Admin

How to Stop/Start an AWS EC2 instance using AWS CLI command line

Windows 10 Updates Failing with MEMORY_MANAGEMENT due to DiskCryptor

How to require SSL when connecting to MySQL on AWS RDS

DBAs are Out of Style and Now There’s a Hole In Your Database

Ping your sitemap to Google and Bing with a bash script

Sending emails through Comcast on Ubuntu using ssmtp

How to setup the MySQL data directory to be in your encrypted home folder on Ubuntu 14.04

Ever heard of inodes? You need lots of them.

Categories

Recent Posts

Category Archives: Sys Admin

Categories

Tags

Recent Posts