This add-on is operated by Xeround
Scalable, highly available, zero-management cloud database for MySQL
This article is a work in progress, or documents a feature that is not yet released to all users. This article is unlisted. Only those with the link can access it.
Table of Contents
This add-on have been deprecated, and is now disabled for new installs.
Xeround is an elastic, always-on database-as-a-service for your MySQL applications that replaces your existing MySQL database and provides seamless MySQL scalability and high availability. You can quickly and easily get your apps up and running with Xeround through the Xeround add-on for Heroku. Your Xeround databases can be used transparently in place of the Heroku-provided PostgreSQL database or a MySQL database such as Amazon RDS.
Deploying to Heroku
To use Xeround on Heroku, simply install the Xeround add-on:
$ heroku addons:create xeround:plan_name
Valid values for plan_name:starter, basic512 and pro512
Note: As database provisioning is carried out asynchronously, please wait until the creation and initialization of the database complete. You can monitor the progress of this process by clicking the Xeround add-on in the Add-ons menu of your application’s Resources.
Connecting to Xeround
The Xeround add-on will store the database’s URLs in two config vars: XEROUND_DATABASE_URL and XEROUND_DATABASE_INTERNAL_URL. The “internal” URL is translated to internal IP addresses and should be used when accessing your database from within the same datacenter. The first URL is used for connecting from outside.
Copy the value of the config variable that is relevant for you -
$ heroku config:set DATABASE_URL=(URL config vars)
Note: Round-robin DNS is used on all of Xeround’s instances and guarantees high availability of the connection to your database in a way that does not require you to tweak your application. Therefore, the config variable XEROUND_DATABASE_FAILOVER_URL that was provided in previous releases is no longer required. For backward compatibility it is set with the same value as XEROUND_DATABASE_URL
Each of the URLs contains a string of the following syntax:
The parts out of which the URLs are made of are also set for your convenience in the following environment variables:
XEROUND_DATABASE_ADAPTER XEROUND_DATABASE_USERNAME XEROUND_DATABASE_PASSWORD XEROUND_DATABASE_HOST XEROUND_DATABASE_PORT XEROUND_DATABASE_NAME XEROUND_DATABASE_INTERNAL_ADAPTER XEROUND_DATABASE_INTERNAL_USERNAME XEROUND_DATABASE_INTERNAL_PASSWORD XEROUND_DATABASE_INTERNAL_HOST XEROUND_DATABASE_INTERNAL_PORT XEROUND_DATABASE_INTERNAL_NAME
That’s it! No additional installation is required, No restart! You are ready to go…