Xeround Cloud Database

This add-on is operated by Xeround

Scalable, highly available, zero-management cloud database for MySQL

Xeround Cloud Database

Last Updated: 19 March 2014

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:add 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:

mysql://username:password@host:port/database

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…