InformationPPA 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:
- 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.
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
Expand to see the screenshot »
The resource based on the 'Database Service' Resource class has the following properties:
- Database server type
- IP address
- Provisioning attributes
|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||
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|