Nginx proxy_pass DNS Cache We use nginx to proxy to an Amazon S3 bucket to serve static content to customers. Yesterday, I noticed a high failure rate through the proxy but I couldn't figure out why. After
MySQL 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 DDL which reduce the need for this
Quickie 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 random on OSX. Some (most?) apps stay
DevOps 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 huge database. I found a solution today.
DevOps 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, if you use AWS and have instances
AWS 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, you create a private network for yourself
Productivity 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 that the most convenient keyboard combinations are
DevOps 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 wire to a new machine, while keeping
Javascript 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 own custom model handling, but you can
Products 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 rants. I don't really mind Google as
