pt-online-schema-change error "Error creating new table ... duplicate key"
pt-online-schema-change is a tool in the Percona Toolkit which allows you to make large table alters without locking the database. Newer versions of MySQL have Online »
Quickie: Prevent Mac apps from quitting when last window is closed
There are a few apps on OSX that quit/terminate once their window is closed. This is typical on Windows of course, but it's a bit »
Quickie: Quickly rename MySQL database
There's no way to rename a MySQL database. Typical advice is to dump/restore the database, but this is obviously very slow if you have a »
SSH with a Bastion Host
A bastion host is a server that sits on a public network whose sole purpose is to provide access to an inner private network. For example, »
AWS VPC Network Structure
I recently started playing around with AWS. One of the really cool things about AWS is the Virtual Private Cloud (VPC) features. By creating a VPC, »
Configure a Hyper Key on OSX
If you're anything like me, you like keyboard shortcuts. I like to set up custom shortcuts and macros to automate everything I can. The problem is »
Setting up a new MySQL slave database via steaming xtrabackup
The goal today is to build a new MySQL slave database off an existing database. We'll use Percona's xtrabackup to stream a hot backup over the »
Using NgModelController with Custom Directives
Creating directives with AngularJS is fairly straightforward. But most directives also need to interact with a model which represents their state. You could bake in your »
Ditching Google
Over the years, there have been so many blog posts determined to convince us that Google is becoming evil. This isn't one of those kinds of »