SharedHosting - Database Only Hosting


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
  1. MachPanel Control Server has been installed, if not then follow below KB article:
    http://kb.machsol.com/Knowledgebase/Article/50261
  2. 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:
  1. Maximum MS-SQL databases
  2. Maximum MS-SQL database size per database (MB)
  3. Maximum MS-SQL database users
  4. Maximum MY-SQL databases
  5. Maximum MY-SQL database size per dataBase (MB)
  6. Maximum MY-SQL database users
  7. 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".

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