Article ID: 115206, created on Nov 26, 2012, last review on May 27, 2016

  • Applies to:
  • Plesk Automation

Information

Plesk Automation (PA) allows to register several database servers to host customers databases. The article describes how you can set the exact server for customer's databases on their subscriptions.

Follow steps below to give ability for customers to create databases:

  1. Include resource based on the Database Service Resource class into the Service Template. Limit for this resource should be set to 1. The resource defines possibility to create databases, but not the amount of databases.

  2. Set the limit for the sub-resources "Number of DATABASE_TYPE databases" on the IIS Webspace or Apache webspace resources. Where DATABASE_TYPE value is:

    • Microsoft SQL Server
    • MySQL
    • PostgreSQL (Click to expand screenshot)

The resource based on the "Database Service" Resource class has the following properties:

  • Activation parameters
    • Database server type
    • Port
    • IP address
  • Provisioning attributes Based on the combination of these properties, PA defines database server for the customer. Selection algorithm is shown at the table below:
IP address value Provisioning attribute Result
IP address of the database server any or empty Database server with the specified IP address
Automatic IP (IP address field is empty) No attribute Unsupported configuration. Provisioning will fail with the error.
Automatic IP (IP address field is empty) 'WebHost' attribute The same server with web hosting
Automatic IP (IP address field is empty) Any attribute, e.g. MySQL Service node with the assigned attribute

Search Words

questions about mysql db

DB hosting provisioning

create database on specified server

Create new webspace on existing subscription issue

Database server selection

DB host

MSSQL server does not appear while adding database

Issues while selecting the default Database MSSQL server

e0aff7830fa22f92062ee4db78133079 caea8340e2d186a540518d08602aa065

Email subscription for changes to this article
Save as PDF