Connecting Your WordPress Site to Xeround Cloud Database

More often than not, you need to migrate an existing WordPress site deployment to a highly scalable architecture by leveraging on a database solution such as Xeround’s. To migrate your existing WordPress installation to use Xeround, follow the steps below:
Prerequisites:

1. First, you need to have the WordPress application installed on your chosen cloud environment (see WordPress installation instructions here.)
2. You need to have a new DB instance created using Xeround’s service. This DB instance would be used to power your WordPress site.
   • 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. )

Migrate your existing WordPress DB to Xeround:

(NOTE: during this step you’d probably want to stop updates to the site so that nothing gets lost in the migration. Alternatively, you can manually synchronize any changes once the migration is over.)

1. Export your Existing WordPress MySQL database.
2. Connect to your new cloud database using an external tool, such as phpMyAdmin (also available from your Xeround online console) and create your database / schema (e.g., wp_db).

   mysql> CREATE DATABASE wp_db;

3. Import your WordPress DB dump into your previously created Xeround DB instance.

Connect your WordPress installation to your Xeround DB Instance:

This is done by updating your WordPress configuration file to with the connection details for your new Xeround cloud database.

1. Locate the WordPress configuration file: it is usually named wp-config.php and it resides under the home directory of your WordPress deployment
2. Open the file in a Text Editor (i.e. Notepad).
3. In the configuration file, update the below database settings:
   1. Database Host:Look for the line that defines the DB_HOST parameter. If your database is on the same server as your WordPress installation than the default line looks like this:

      define('DB_HOST', 'localhost');

      Replace the current value of DB_HOST (e.g. ‘localhost’) with your Xeround instance’s hostname and port, separated by a colon exactly as they appear in the Details tab in your database manager online console.
      
      The result should look like the following:

      define('DB_HOST', 'ec2-174-129-253-124.compute-1.amazonaws.com:3060');

   2. Database Name: Look for the line that defines the defines the DB_NAME parameter, and replace its current value with the name you chose for your database when you created the database schema in step #3 above.
      The result should look like this:

      define('DB_NAME', 'wp_db');

   3. Database Username: Look for the line that defines the defines the DB_USER parameter, and replace its current value with the username you chose for your database when you created your new instance (step #2 in the prerequisites above).
      The result should look like this:

      define('DB_USER', 'put_your_username_here');

   4. Database Password: Look for the line that defines the defines the DB_PASSWORD parameter, and replace its current value with the password you chose for your database when you created your new instance (step #2 in the prerequisites above).
      The result should look like this:

      define('DB_PASSWORD', 'put_your_password_here');

      (For further explanation on modifying the WordPress configuration file see here)

4. Save your changes and exit the editor

And You’re Done: Your WordPress 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:

1. You need to have a new DB instance created using Xeround’s service. This DB instance would be used to power your WordPress site.
   • 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.)

Configure your WordPress installation with your cloud database details:

1. Install the WordPress application on your chosen cloud environment (see WordPress installation instructions here.)
2. As part of the installation process – when you run the installation script, WordPress would look for the configuration file called wp-config.php.
   1. If WordPress can’t find the configuration file, it’ll offer to create it for you – approve by clicking the “Create a configuration File” button and the “Let’s go” button in the following screen.
      
3. The next step of the installation wizard allows you to configure the database connection details, which would get updated in the wp-config.php file.
   
   Update the below database details:
   1. Database Name: give it a name
   2. User Name: the username you chose for your database when you created your Xeround DB instance (step #1 in the prerequisites above).
   3. Password: the password you chose for your database when you created your new instance (step #1 in the prerequisites above).
   4. Database Host: your Xeround instance’s hostname and port, separated by a colon exactly as they appear in the Details tab in your database manager online console.
      Your hostname should look something like this:

      ec2-174-129-253-124.compute-1.amazonaws.com:3060

      

4. Click “Submit” and then “Run the Install” to continue with your WordPress installation.

And You’re Done: Your WordPress site is now powered by Xeround!

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

Back to top