We are currently on RDS for hosted MySQL but are considering moving to one of the fault tolerant MySQL addons for heroku. The two main ones seem to be xeround and ClearDB, but I'm having a hard time determining the differences between them. We're mainly interested in fault tolerance, consistent and fast performance and UTF8 charset support. Any experiences with either welcome. There doesn't seem to be much discussion of either out there.
ClearDB is a cloud, hybrid, and on-premise database-as-a-service for MySQL powered applications. It stores and manages your MySQL database for you so that you don't have to deal with things like database servers, replication, advanced storage, IT support, and especially things like database failures.
Heroku customers can get started using ClearDB on Heroku for free with our 5MB Ignite package, and move into production use with our Punch package, a great price at $9.99 per month with 1GB of storage.
Postgres offers a wider variety of data types than MySQL. If your application deals with any of the unique data types it has available, or unstructured data, PostgreSQL may be a better pick. If you're using only basic character and numeric data types, both databases will suit you.
I struggled with Xeround. We had an app built for none heroku environment that we migrated to Heroku. We tried Xeround but there was some problems with some of our queries for some reason when run against Xeround. Drastic but we ended running a Slicehost mySQL instance. We've recently re-reviewed and found ClearDB to work much better for us so we're now running on that Db.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With