MySQL on Heroku:
A scalable, always-on cloud database for your Heroku MySQL-app is just a click away!
Xeround’s cloud database provides unlimited scalability, built-in replicas and automatic failover for high availability — all in a plug-&-play, simple database service.
Xeround’s database is the only horizontally scalable and highly available MySQL database available on the Heroku platform.
Xeround’s Heroku add-on takes the pain out of deploying, configuring and scaling the database for your Heroku MySQL applications. Heroku users can use Xeround Cloud Database transparently in place of the Heroku-provided PostgreSQL database or a manually installed MySQL database.
There are two ways you can use Xeround Cloud Database with your Heroku MySQL application:
Creating your cloud database directly from Heroku
Xeround’s add-on for Heroku allows you to create your MySQL cloud database instance with a single click from within your Heroku environment.
How to use Xeround Cloud Database Add-on for Heroku?
- Add the Xeround Cloud Database Add-on to your Heroku Environment
- Install the Xeround add-on
- This will automatically create your cloud database instance (in the same datacenter as your Heroku application)
- Connect your MySQL-application to your new cloud database (see code samples.)
Creating your cloud database from Xeround
You can sign up to create your free cloud database via Xeround, and then connect your Heroku MySQL application to it just as you would connect it to any external database.
How to connect your Heroku MySQL app to your Xeround Cloud Database:
- Sign up to create your free cloud database or to start your 14-day free trial of any of Xeround’s paid editions
- From the online console create your new Cloud Database Instance
- To minimize latency, be sure to create it on our Amazon-EC2-US-East or Amazon-EC2-EU-West data center, depending on where your Heroku application is hosted.
- Connect to your database using an external tool, such as phpMyAdmin (also available from your Xeround online console) and create your database / schema
- Edit the connection string of your Ruby app to connect to Xeround’s Cloud Database
- Use the login details you’ve chosen when you created your database instance (see code sample)