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 …
Tag Archives: database management
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. …
Continue reading “Best of Guide – Highlights of Our Popular Content”
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 …
Continue reading “Ten things to remember about MySQL backups”