Tyranny of a Google vote

For the past year I’ve been seeing headline blogs analyzing the effect of Google’s last algorithm update, dubbed the Panda. There was much talk of unfair relegation from the first page of Google search results, and general indignance by the SEO community. As with any subject in which I only have cursory knowledge I didn’t …

The Power of Habit by Charles Duhigg

Habits. We all have them. The good ones we celebrate, but the bad ones we struggle with. Duhigg’s book may introduce some ideas to those of us less familiar with behavioral sciences but it fails to effectively teach us how to form good habits and break the bad ones. Filled with pages of stories from …

Bulletproofing MySQL replication with checksums

Also find Sean Hull’s ramblings on twitter @hullsean. Your MySQL replcas running well? You might not even know if they aren’t. One of the scariest things about MySQL replication is that it can drift out of sync with the master “silently”. No errors, no warnings. What and Why? MySQL’s replication solution evolved as a statement …

Don't be that guy–Social tips for geeks

As a tech consultant one of the most interesting parts of the job is being able to observe human relations at work. I’ve learned through the years that because tech people and non-tech people speak different ‘languages’, bridging the communication gap is a critical part of my role as a consultant. Sometimes the relationship between …

5 Ways to fortify MySQL replication

Also find Sean Hull’s ramblings on twitter @hullsean. MySQL replication technology is powerful and flexible. But it doesn’t do everything perfectly all the time. You may experience trouble with the slaves falling behind the master, or want to scale horizontally by building new slaves automatically. Or you might need to build a slave without blocking …

Easy MySQL replication with hotbackups

Also find Sean Hull’s ramblings on twitter @hullsean. Setting up replication in MySQL is something we need to do quite often. Slaves die, replication fails, or tables and data get out of sync. Whenever we build a slave, we must start with a snapshot of all the data from the master database. MySQLdump is the …

Thank You for Arguing – Persuasion for fun and profit

Join 10,000 others and follow Sean Hull on twitter @hullsean. I first read about Heinrichs in a Bloomberg Businessweek piece on him. He’s quite a character, with high profile clients like Ogilvy & Mather and the Pentagon. Struck by some of his ideas, I decided to pickup Thank You for Arguing. Related: AirBNB Didn’t Have …

Autoscaling MySQL on Amazon EC2

Also find Sean Hull’s ramblings on twitter @hullsean. Autoscaling your webserver tier is typically straightforward. Image your apache server with source code or without, then sync down files from S3 upon spinup. Roll that image into the autoscale configuration and you’re all set. With the database tier though, things can be a bit tricky. The …

The myth of five nines – Why high availability is overrated

Join 38,000 others and follow Sean Hull on Twitter @hullsean. In the Internet world 24×7 has become the de facto standard. Websites must be always on, available 24 hours a day, 365 days a year. In our pursuit of perfection, performance is being measured down to three decimal places, that is being up 99.999% of …