About multiple MySQL databases

Your hosting services make it possible to use multiple MySQL databases with your site.

• Note: To use multiple MySQL databases, your service provider must enable both MySQL and multiple databases for your site.

Need for multiple databases

A Web site is a collection of data entities organized in databases that enable you to retrieve and process information with ease. Often, Web 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.

Creating multiple databases

You can create databases and assign an administrative authority for each database. Your service provider determines the number of databases that can be created for your site. As of now, WEBppliance supports only one user per database.

• Note: WEBppliance does not implicitly create databases when a site is created, even if the site is enabled to support the MySQL database service.
   

• The disk space consumed by a database counts toward a site's total disk quota. If a database consumes disk space in excess of the site's disk quota, you will receive an error stating that the disk is full.  

Administering databases

MySQL databases are administered by the database administrator designated by your service provider. As Site Administrator, you cannot change the database administrator, though you can set and modify the password.

• Note: To perform operations on a database as the Site Administrator, you must be assigned the role of the Database Administrator by your service provider, and log in using this information. You cannot perform operations on a database using your site user name or password.

You can:

• Create MySQL databases

• Delete MySQL databases