RDS or MySQL – Ten Use Cases

Amazon’s Relational Database Service is based on MySQL under the hood.  So many colleagues and clients ask me – should I go with RDS or MySQL? As with every technology question, the answer is – it depends. Here are some scenarios to help you decide. I’m replicating into Amazon from a physical datacenter A: This …

Best of Guide – Highlights of Our Popular Content

We cherry pick the top 5 most popular posts of various topics we’ve covered in recent months. 5 Things Toxic to Scalability We use a broad brush to highlight the biggest no-nos in web application scalability. 5 Ways to Boost Scalability for MySQL We dig into scalability, steering to the richest areas to focus on. …

Ten things to remember about MySQL backups

Use Hot Backups Hot backups are an excellent way to backup MySQL.  They can run without blocking your application, and save tons on restore time.  Percona’s xtrabackup tool is a great way to do this.  We wrote a how-to on using xtrabackup for hotbackups. Use Logical Backups Just because we love hot backups using xtrabackup …