Summary

This articles describes in detail about the Integration of Database Only Hosting (Shared/Web Hosting) and Database Only Subscriptions and Management.

Applies To

This article applies to MachPanel v6 and above.

Pre-Requisites

MachPanel Control Server has been installed, if not then follow below KB article:
http://kb.machsol.com/Knowledgebase/Article/50261
MachPanel Remote Server has been installed, if not then follow below KB article:
http://kb.machsol.com/Knowledgebase/Article/50262

STEP-1: Integrating Database Service with MachPanel Web Hosting:

Open MachPanel Control Panel Website (You can do it by opening MachPanel Control Server Configuration Studio and then navigating to Configure > Control Panel Website, and then clicking on the URL in it). Log in with the provider credentials.
Add Web Hosting server Group if not added already. Navigate to Home > Service Director > Web Hosting > Server group and then click on Add Server Group. For more details click Add Web Hosting Server Group
Now Click on Server Group Name, new tab "Web Hosting Servers" will open and you will also see Services in options column.

Click Services in the options menu against the desired server then click on Add Service button.

To add Database Service to your Hostmatic/Web server, select Database from the drop down list.

Now, select Provider for the Database service and provide necessary details such as SQL Database Settings, Database Backup, Account Limits, DNS Record. Click Save when done See the snapshots below:

Hit Test Service for each service and if you get Successful message in Green then integration of that service is successful.

STEP-2: Creating Database Only Product/Package:

To add a Database Only - Shared Hosting Product navigate to path: Home >> Service Plans >>Hosting Products. Select Customer Product Listing tab for Customer plan.
Click Add New Product button as shown below:

Now provide basic details such as Server Group, Product name and select Package Type Database Only.

Under Resources tab, Provide Resources for the Database Hosting.Provide Following fields:

Maximum MS-SQL databases
Maximum MS-SQL database size per database (MB)
Maximum MS-SQL database users
Maximum MY-SQL databases
Maximum MY-SQL database size per dataBase (MB)
Maximum MY-SQL database users
Maximum ODBC DSN

Select Payment Cycles and Payment Groups and click Next.
Add Price Group and click Next.
Associate Add-on (if any) and then Finish to create the Package.

STEP-3: Provisioning and Selling of Database Only - Shared Hosting Plan:

In this step you have to sell and provision the Database Only Plan to the customer. Select Shared Hosting under "Service".

Select the Database Only Plan under "Package".

Please review the following KB article for more details on selling and provisioning of services: http://kb.machsol.com/Knowledgebase/Article/50275

STEP-4: Management of Database Only Subscriptions:

Navigate to following path to manage Database Only Subscription: Home >> Service Director >> Web Hosting >> Hosting Accounts
Select Database Only Subscription tab as shown below:

Now you can add & manage Databases and Database Users under their respective tabs as shown below:

By clicking on Manage button you will see
Under Manage Database section, there are two operations Backup Database and Restore Database
By clicking Backup Database, backup of database can be saved \Root\Backups
To Restore from a backup, you need to click on Restore Database, on clicking you will see a section as shown below

Locate file by clicking Browse button, select file by clicking the Name of Database backup file

Click Done, you will see

Click Restore button.
Under Database Users Tab user related operation, setting password, Set as Owner or Removing a user can be performed