About multiple MySQL databases

WEBppliance enables support for multiple MySQL databases per site.

A web site is a collection of data entities organized in databases that enable you to retrieve and process information with ease. Often, 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, and is vital to sites that use demanding applications and services. A single database could pose a constraint to superior performance for these sites.

## Enabling MySQL Databases for a site

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

To 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 can not 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: WEBppliance does not implicitly spawn a database when a site is created. Also, if you set the maximum limit to '0', then the Administrator of the site will be unable to create databases for the site. Setting the limit to '-1' permits the Site Administrator to create unlimited databases for a site.
  Also, the disk space used by a site's MySQL databases consume available disk quota. No exclusive disk space is allocated to MySQL databases.

- Database Prefix - The prefix name for the site databases. You must assign a prefix for database names. This is to ensure that the database names are unique and does not conflict with any existing database.

- 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 in your code with the new name of the database.