MySQL in the cloud at Airbnb
nerds.airbnb.com
MySQL in the cloud at Airbnb
1–10 of 22 posts
Re: MySQL in the cloud at Airbnb
#2Okay, this justifies my HN-browsing once again. I was thinking about hosting MySQL-using application in the cloud literally thirty minutes ago, and then this caught my eye in the HN front page. RDS looks very promising, I think it will prove itself useful to us. Thanks HN!
Re: MySQL in the cloud at Airbnb
#3How does the scalability offered by Heroku compare to this? Does Heroku let you interface with RDS if you outgrow their db offerings?
Re: MySQL in the cloud at Airbnb
#4How does the scalability offered by Heroku compare to this? Does Heroku let you interface with RDS if you outgrow their db offerings?
It's the very first item on their add-ons listing.
Re: MySQL in the cloud at Airbnb
#5Okay, this justifies my HN-browsing once again. I was thinking about hosting MySQL-using application in the cloud literally thirty minutes ago, and then this caught my eye in the HN front page. RDS looks very promising, I think it will prove itself useful to us. Thanks HN!
Same here! I was on the fence about starting my app with RDS or moving to it later. This article puts me over the edge
Re: MySQL in the cloud at Airbnb
#6Would it be possible to get some figures of how much you pay amazon for this? And also db-size and queries per day or something?
Good post!
Re: MySQL in the cloud at Airbnb
#7Does anybody how much Multi-AZ synchronous replication affects performance? I searched, but I couldn't find any benchmarks. Amazon's FAQ[1] says "You may observe elevated latencies relative to a standard DB Instance deployment in a single Availability Zone as a result of the synchronous data replication performed on your behalf" but they don't quantify it.
Re: MySQL in the cloud at Airbnb
#8I can't imagine life without RDS. I'm a solo developer responsible for a large web app. Before RDS I hosted MySQL on dedicated hardware from Softlayer. I had a dedicated box for the master, one for the slave, and another for storing backups. The DB was about 100GB which made backing up a total nightmare. Mysqldump was too slow, I ended up having to use xtrabackup from Percona. Anyhow it got to the point were I was spending over 50% of my time maintaining the database instead of doing productive things, like building new features for my app.
Then I switched to RDS. I instantly fell in love with snapshots. I love that you can backup your database while it is hot. Sometimes, before doing a scary migration or query I'll take a snapshot just in case. I love that.
Even more amazing is the ability to scale up/down while the database is live. When I was with Softlayer and I needed to migrate to new machines there was always downtime and I always had to pay for both the new machine and the old machine for a small duration of time. Thus migrating would cost a couple grand in lost revenue and servers expenses, not to mention my Friday and Saturday night.
Re: MySQL in the cloud at Airbnb
#9Would it be possible to get some figures of how much you pay amazon for this? And also db-size and queries per day or something? Good post!
Agreed...cost data would be really useful
Re: MySQL in the cloud at Airbnb
#10How does the scalability offered by Heroku compare to this? Does Heroku let you interface with RDS if you outgrow their db offerings?
They do. I think Heroku is the best thing for new apps / developers. You can launch your app for free. Your app would have to be rather successful (and hopefully profitable) to outgrow their free database plan.