Join 28,000 others and follow Sean Hull on twitter @hullsean.
MySQL slow query on RDS
If you run MySQL as your backend datastore is there one thing you can do to improve performance across the application?.
Those SQL queries are surely key. And the quickest way to find the culprits is to regularly analyze your log. I’ve put together a howto & script for doing this on Amazon RDS.
Vagrant & Amazon EC2
Among the automation tools that are getting a lot of attention these days are Chef, puppet & ansible for devops, plus Docker & Vagrant.
Can we use vagrant to spinup EC2 instances? As it turns out yes. And it can be a great way to automate dev environments and works in conjunction with docker.
Cache websites for speed
Is Fred Wilson right that speed is an essential feature? We certainly think so.
And besides tweaking & tuning the database, the next best way is caching. You cache objects at the browser, add a page cache and memcache, redis or elasticache. Here’s our howto.
DB Change Management
Everyone uses version control for application code, whether it’s PHP, Ruby or Node.js. But are you using it for database changes?
DDL, those statements that create objects should also be included in version control. But how to do it properly? Database change management is one part art, but there are some helpful tools to get you on the right track.
With some luck you’ll be able to roll forward & backward to versions of your database schema just as easily as you can versions of your software.
MySQL is the big bad beast that still hobbles a lot of site performance. Here are some key tips, narrowed down to just the essentials.
The cloud enables scalability, but is it ready out of the box? There are some key things to remember on your road to high scalability in the cloud.
Fortify MySQL Replication
MySQL replication is pretty awesome for what it is. Still there are gotchas & potholes. Here’s our guide to smooth sailing.
MySQL replica with Hotbackup
If you’re building your own MySQL instances on EC2, you’ll also build your own replicas. Luckily there are some great tools that make this reliable & smooth. Install percona’s hotbackup tool & you’re off to the races.
If you’ve forgotten all about backups since your cloud or managed solution does all that for you, think again! There are still things you should do in addition. At the very least run a fire drill & find out if all the parts are there for rebuild.