Setting Up Remote Database Hosting
After you have set up the required remote database server, you need to register this database server in Parallels Plesk Panel.
To register a database server with Parallels Plesk Panel:
- Log in to Parallels Plesk Panel.
- Go to Home > Database Servers, and click Add Database Server.
- Specify the properties of the database server:
- Click OK.
To set up database hosting preferences that will affect all databases created through Parallels Plesk Panel:
- Go to Home > Database Servers > Preferences.
- To simplify maintenance of customers' databases, select the Add client's login name and underscore to beginning of database names check box. All names of newly created databases will look like client's login name_database name. This will allow you to locate databases related to a particular Parallels Plesk Panel user. Note that even if you do not select this check box, on creation of a new database, Parallels Plesk Panel will add client's login name to the database name input box, and you will be able to edit it or remove it.
- You can also set up Parallels Plesk Panel to add client's login names to corresponding database user names, further simplifying the maintenance of customers' databases. To do so, select the Add client's login name and underscore to the beginning of database user names check box. All names of newly created database users will look like client's login name_database user name. This will allow you to locate database users related to a particular Parallels Plesk Panel user.
- Specify whether creation of databases is allowed on your Parallels Plesk Panel server. Some applications do not support remote databases and can work only with databases hosted on the same server. We recommend leaving the default option Allow local hosting of databases for these Web applications selected, otherwise, you will not be able to use such applications.
- Click OK.
If you want to back up databases hosted on a remote MS SQL Database Server you set up earlier, you need to configure the backup settings for that MS SQL Database Server.
To configure backup settings for remote MS SQL Database Server:
- Go to Home > Database Servers and click the required remote MS SQL Database Server name.
- Specify the temporary directory for remote MS SQL Database Server in the Temporary network directory field.
This directory can be located anywhere in your network and it is required for backing up and restoring MS SQL databases. This directory must be accessible over the network by both the Parallels Plesk Panel server and the MS SQL server: both Parallels Plesk Panel and the user that is running remote MS SQL Database Server must have read/write access to this directory.
- Provide username and password required for accessing the temporary network directory.
- Click OK.