tag:blogger.com,1999:blog-32881756.post967208505304066263..comments2024-03-27T10:43:33.261-04:00Comments on Code Master Blog: Heroku DB Migration from PostgreSQL to ClearDBAndy Malehhttp://www.blogger.com/profile/10268484073612495328noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-32881756.post-55607625125151048362015-03-21T20:15:44.731-04:002015-03-21T20:15:44.731-04:00Thanks for sharing @Annas. I'm in a similar si...Thanks for sharing @Annas. I'm in a similar situation, fortunately I've realized this pretty early on (before the site is big enough to hit performance issues) but the upgrade path and the staggering price of Heroku Postgres is really turning us off, so we're about to upgrade.<br /><br />We're using Rails` `yaml_db` gem to export and import the database content. I think it's easier than trying to wrangle with database-native dumps.Topher Hunthttps://www.blogger.com/profile/11066350697224951887noreply@blogger.comtag:blogger.com,1999:blog-32881756.post-376096027479596102014-12-16T06:09:22.006-05:002014-12-16T06:09:22.006-05:00funny, I am about to switch from ClearDB to Heroku...funny, I am about to switch from ClearDB to Heroku Postgres because you cannot have stored procedures or triggers with ClearDB unless you pay for one of their packages that's at least 400/month.Cameron Askewhttps://www.blogger.com/profile/12548274421272715080noreply@blogger.comtag:blogger.com,1999:blog-32881756.post-52296160666248685342012-12-12T22:22:45.615-05:002012-12-12T22:22:45.615-05:00Several reasons relevant to my current company:
- ...Several reasons relevant to my current company:<br />- Ease of hiring for MySQL devs in Chicago<br />- Pricing for ClearDB<br />- Dual-master replica fault tolerance in ClearDB<br />- Upgrade path to Amazon RDS MySQL<br />- Friction-free painless vertical scaling with no need to take the site down for DB upgrades (it is more friction free than Heroku Postgres, which required a backup and a restore when we tested it).<br /><br />Heroku PostgreSQL is definitely good too. Heroku now supports a nice Follow feature that lets you generate read-replicas for reporting/off-master queries. They added other useful features too, but ClearDB was the better fit for us.Andy Malehhttps://www.blogger.com/profile/10268484073612495328noreply@blogger.comtag:blogger.com,1999:blog-32881756.post-77881495112755838162012-12-04T07:35:18.351-05:002012-12-04T07:35:18.351-05:00What motivated you to move off of Postgres onto My...What motivated you to move off of Postgres onto MySql? The opposite seems to be the more popular route. What advantages did you see on MySql or weaknesses on Postgres?Anonymoushttps://www.blogger.com/profile/12946646943956308726noreply@blogger.com