Category: Open Source Software

Many applications inside Amazon Web Service are using MySQL inside a Virtual Private Cloud (VPC) and not accessible to the outside network. Oftentimes clients will want to connect to the database directly to inspect data, run a visualization tool, or simply connect a locally run application. The solution to this problem is to NAT connections…

I recently worked with a client where there were a number of Amazon EC2 AMIs where not all of the disk volumes were set to delete on termination. This caused quite a few snapshots to become orphaned when the associated AMI was deleted. This was discovered when there were hundreds of snapshots and no active…

I recently deployed puppet to a host of machines and ran into an issue with getting one of the hosts to read the /catalog. * puppet 2.7 * Amazon Linux Wed Aug 14 22:11:39 +0000 2013 Puppet (err): Could not retrieve catalog from remote server: Error 403 on SERVER: Forbidden request: hostname.example.com. (10.0.1.20) access to…

Instant RSpec Test Driven Development How-to, by Charles Feduke, is another book in the Instant series published by Pakt Publishing designed to get the reader up and running quickly (Short, Fast, Focused). This book covers test driven development (TDD) using rspec with ruby and is designed for developers of all experience levels. As a solutions…

I will often issue a command at the bash prompt and want to re-issue the same command, albeit with a slight modification. This can be a pain if the command is lengthy and I’ve often thought it should be easier. I finally got around to trying something new to make it easier. 1. search for…

I have received a copy of Instant RSpec Test-Driven Development from Pakt Publishing and will be reviewing this book within the next couple weeks.

At times I’ve received this message when restarting a mysql slave server: Could not initialize master info structure; more error messages can be found in the MySQL error log This often occurs when changing the hostname of the slave (ie, master failover) and relay-log is not set in the my.cnf. The answer here is to…

When performing a dump and restore of large datasets in MySQL that take multiple days to perform, I typically use the process outlined here. Note that it is critical to connect to the server in question and establish a screen session to perform all commands and operations within. This prevents issues with client connections dropping.…