Month: June 2013
-
EBS Volumes – deleteOnTermination ?
When using EC2 instances with EBS backed storage, whether or not your instances are setup to delete their EBS volumes on termination can be a big deal — especially if you burn AMIs and provision instances over and over. You could find yourself with many EBS volumes that are unused and pay for lots of […]
-
Could not initialize master info structure; more error messages can be found in the MySQL error log
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 […]
-
MySQL – Large Dataset Dump and Restore
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. […]