Best How to Posts on Scalable Startups

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.

Automate mysql slow query analysis 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.

How to deploy on amazon EC2 with vagrant

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.

5 tips to cache websites & boost speed

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.

5 tips better db change management

MySQL Scalability

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.

5 ways to boost mysql scalability

Cloud Scalability

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.

3 ways to boost cloud scalability

Fortify MySQL Replication

MySQL replication is pretty awesome for what it is. Still, there are gotchas & potholes. Here’s our guide to smooth sailing.

5 ways fortify mysql replication

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.

Easier mysql replication using hotbackups

MySQL Backups

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.

Conclusion

That’s all the best how to posts on Scalable startups. You can visit and read them from the links above. If you’re having any issue finding these posts from these links, please inform us and we’ll try to fix them as soon as we can. Thanks for reading!