Search

Language:  
Search for:

Available article translations:

Database server selection algorithm in PPA

APPLIES TO:
  • Parallels Plesk Automation

Information

PPA allows to register several database servers to host customers databases. The article describes how you can set the exact server for customers' 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
Expand to see the 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, PPA 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 Server with the assigned attribute



b315de483b3ce496b93860f954cd3118 caea8340e2d186a540518d08602aa065

FEEDBACK
Was this article helpful?
Tell us how we may improve it.
Yes No
 
 
 
 
 
 
Desktop Virtualization
- Parallels Desktop 9 for Mac
- Parallels Transporter
- Parallels Desktop Switch to Mac Edition
- Parallels Desktop for Mac Enterprise Edition
- Parallels Management-Mac for Microsoft SCCM
Server Virtualization
- Parallels Cloud Server
- Parallels Containers for Windows 6.0 Beta
- Parallels Virtuozzo Containers
Automation
- Parallels Automation
- Parallels Automation for Cloud Infrastructure
- Parallels Business Automation Standard
- Parallels Virtual Automation
- Parallels Plesk Panel Suite
- Web Presence Builder
- Parallels Plesk Automation
- Parallels Small Business Panel
- Value-added Services for Hosters
- Parallels Partner Storefront
Services & Resources
- Cloud Acceleration Services
- Professional Services
- Support Services
- Training & Certification