MySQL on AppHarbor’s .NET Platform
Create a free, highly-available MySQL cloud database for your .NET application
Xeround cloud database is engineered from the ground up to be elastic, scalable and resilient to hardware failures. It provides automatic scalability (both up and out) and high-availability guarantee – all in a simple, plug-&-play, database-as-a-service.
Xeround allows you to easily create a 100% MySQL-compatible database instance to use with your .NET application on the AppHarbor platform.
With Xeround’s database-as-a-service you can take advantage of all the great MySQL drivers and other tooling out there to use with your .NET code, without having to worry about learning new APIs or tools.
Xeround’s AppHarbor add-on takes the pain out of deploying, configuring and scaling the database for your .NET MySQL applications. With just 1-click you can ensure scalability and availability of your database- with no need for any maintenance, configuration changes or code changes to your application.
Watch the Product Tour:
There are two ways you can use Xeround Cloud Database with your AppHarbor MySQL application:
Creating your cloud database directly from AppHarbor
Xeround’s add-on for AppHarbor allows you to create your MySQL cloud database instance with a single click from within your AppHarbor environment.
How to use Xeround Cloud Database Add-on for AppHarbor?
- Add the Xeround Cloud Database Add-on to your AppHarbor Environment
- This will automatically create your cloud database instance (in the same datacenter as your AppHarbor application)
- Fetch the connectionstring from the ‘<appSettings/>’ element in your application configuration file (var connectionstring = ConfigurationManager.AppSettings
["XEROUND_DATABASE_INTERNAL_URL"];) - Now you can connect to Xeround using your favourite MySQL-compatible driver or object-relational mapper.
- (See also AppHarbor’s ASP.NET MVC sample application that uses
NHibernate to connect to Xeround.)
- (See also AppHarbor’s ASP.NET MVC sample application that uses
Creating your cloud database from Xeround
You can sign up to create your free cloud database via Xeround, and then connect your AppHarbor MySQL application to it just as you would connect it to any external database.
How to connect your AppHarbor 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 centers — depending on where your AppHarbor 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 AppHarbor .NET app to connect to Xeround’s Cloud Database
- Fetch the connectionstring from the ‘<appSettings/>’ element in your application configuration file (var connectionstring = ConfigurationManager.AppSettings
["XEROUND_DATABASE_INTERNAL_URL"];) - Use the login details you’ve chosen when you created your database instance with Xeround
- Fetch the connectionstring from the ‘<appSettings/>’ element in your application configuration file (var connectionstring = ConfigurationManager.AppSettings
