Enabling multiple MySQL databases

Quick-start Guide: Home 1 2 3 4 5 6 7 8 9 10

The control panel enables support for multiple MySQL databases per site.

# Need for multiple databases

Web sites comprise data entities that can be organized in databases enabling you to retrieve and process the data with ease. Often, the volume of data can get overwhelming, and you will be challenged with the need to distribute your data efficiently.

Multiple databases enable you to organize your site's data more effectively and efficiently.

## Enabling MySQL Databases for a site

You can enable MySQL database support for a site at the time of creating the site.

How to enable MySQL for a site

- Note: The MySQL databases are backed up when you back up the site.

When you enable MySQL, you must provide the following information:

- Database Administrator - Name of the Database Administrator for the site. The Database Administrator has complete administrative access and control privileges on the site's databases.

- Note: The Administrator of the site cannot change the Database Administrator assigned to the site.

- Number of Databases - Number of databases the Administrator of the site can create for the site

- Important: The control panel does not implicitly spawn a database when a site is created. Setting the limit to '0', enables the administrator to create unlimited databases for the site.
  Also, the disk space used by a site's MySQL databases consume available disk quota.

- Database Prefix - The prefix name for the site's databases. The prefix ensures that the database names are unique and do not conflict with any existing database. By default, the name of the site is used as the database prefix.

- Important: Changing the prefix cascades a name change across all the databases of the site, causing your site databases to be inaccessible. Once you set the prefix for a database, it is strongly recommended that you do not change the prefix.
  If you change the prefix, then you must replace the obsolete name references with the new name of the database.

Next Quick-start topic:

Backing up and restoring data