Connecting Your Joomla! Site to Xeround Cloud Database

To instantly add database high-availability and scalability to your existing Joomla! site deployment, all you need to do is migrate your existing database to Xeround, point your Joomla! to it and you’re done! To accomplish this, just follow these steps:

Prerequisites:

1. First, you need to have the Joomla! application installed on your chosen cloud environment (see Joomla!’s installation instructions here).
2. Provision a new Xeround DB instance to be used by your Joomla! site. Preferably, choose the same cloud environment for your DB instance as your Joomla!’s to avoid network latency.
   • To create your new cloud database you will need to sign up with Xeround, then choose “Create New” from your Database Manager Online Console. (detailed instructions on creating a new DB instance can be found here).

Migrate your existing Joomla! DB to Xeround:

(NOTE: you should stop all content updates to your Joomla! site while performing the DB migration to avoid loosing any changes)

1. Dump the contents of your existing Joomla! MySQL database to a file (e.g., by using mysqldump).
2. Create a database schema for your Joomla! database in Xeround’s DB instance. This can be done by connecting to your new cloud database using any MySQL client (for example, phpMyAdmin that’s available from your Xeround online console) and executing the following statement:

   CREATE DATABASE joomla_db;

3. Using any MySQL client, load the Joomla! database dump to your Xeround database instance.

Connect your Joomla! installation to your Xeround DB Instance:

Connecting your Joomla! to a Xeround DB involves providing the new connection details to your Joomla! application.

1. Locate and open for editing the Joomla! configuration file – the file is named configuration.php and should reside in the root directory of your Joomla! deployment
2. In the Joomla! configuration file, update the following:
   1. Database Host: look for the line with the definition of the $host variable and replace its assigned value with your Xeround DB DNS name. If your Joomla! is using a local MySQL server, this line would look like this:

   public $host = 'localhost';

   Replace the current value of $host (e.g. localhost) with your Xeround DB  instance’s hostname and port, separated by a colon exactly as they appear in the Details tab of the DB Instance Manager.

   

   The resulting line in the configuration file should look like the following:

   public $host = 'instance3221.db.xeround.com:3282';

   2. Database Username: Locate the definition of the $uservariable and replace its current value with the username you had assigned to your Xeround DB when it was created. The end result should look similar to the below:

      public $user = 'put_your_username_here');

   3. Database Password: Edit the value of the $passwordvariable and set it to the password of the database user from step c. The result should look like this:

      public $password = 'put_your_password_here';

   4. Database Name: Lastly, set the database’s name to the that of the database you had created in step #2 above. This is done by editing the $db variable, for example:

      public $db = 'joomla_db';

3. Save your changes and exit the editor

That’s it! Your Joomla! site is now powered by Xeround!

If you have any further questions or need assistance, email us at support@xeround.com

Back to top

Prerequisites:

• You need to have a new DB instance created using Xeround’s service. Your Joomla! site will use this DB instance for managing its contents.
  1. To create your new cloud database you need to register for Xeround, then choose “Create New” from your Database Manager Online Console. (Detailed instructions on creating a new DB instance can be found here).
  2. Create a database schema for your Joomla! database in Xeround’s DB instance. This can be done by connecting to your cloud database using any MySQL client (for example, phpMyAdmin that’s available from your Xeround online console) and executing the following statement:

     CREATE DATABASE joomla_db;

Configure your Joomla! installation to use your cloud database:

1. Download Joomla! and begin installing it on your cloud server (see Joomla!’s installation instructions here).
2. Complete steps 1-3 of Joomla!’s installation.
3. In step 4 of Joomla!’s installation, supply the connection details of your Xeround DB instance in the Basic Settings section:
   1. Host Name: the host name and port of your database instance, colon-separated. You can copy-paste it directly from your DB instance Details tab:
      
   2. Username: the username you chose for your database when you created your Xeround DB instance (step #1 of the the Prerequisites).
   3. Password: the password you chose for your database when you created your new instance (step #1 of the the Prerequisites).
   4. Database Name: the database you created in the DB instance (step #2 of the the Prerequisites).

   Your Joomla! Database Configuration page should look like this:
   

4. Click the “Next” button and continue with Joomla!’s installer until it finishes.

And You’re Done! Your new Joomla! site is powered by Xeround!

If you have any further questions or need assistance, email us at support@xeround.com.

Back to top