Product Documentation

MySQL Services

Jun 05, 2015
CloudPortal Services Manager MySQL Services host MySQL databases from the cloud.

Prerequisites

To configure MySQL Services

  1. Enable the service (top level) and create a default customer plan:
    1. From the main menu, choose Configuration > System Manager > Service Deployment and then expand MySQL.
    2. Click Customer Plans, enter a Name such as Full, click Create, and then click Save.
  2. Add MySQL credentials: From the main menu, choose Configuration > System Manager > Credentials, click Add, and specify the credentials (using MySQL as the Domain), and then click Add. The MySQL user must have all rights that are listed in the MySQL users table, including References_priv.
  3. Enable and configure the service (location level):
    1. From the main menu, choose Configuration > System Manager > Service Deployment, under Service Filter select Active Directory Location Services, and choose a Location Filter if applicable.
    2. Expand MySQL and then click Service Settings.
    3. Select the MySQL Credentials check box, choose the credentials you created in Step 3, click Apply changes, and then click Save.
  4. Assign server roles:
    1. From the main menu, choose Configuration > System Manager > Server Roles and then expand the entry for the server hosting MySQL.
    2. Under Server Connection Components, select My SQL.
    3. Under Server Roles, select MySQL Hosting and then click Save.
  5. Create a server collection:
    1. From the main menu, choose Configuration > System Manager > Server Collections.
    2. If the Location Filter appears, select the relevant location from the list.
    3. Click New Server Collection.
    4. Enter a Name for the collection, such as MySQLWindows. The name cannot contain spaces.
    5. From the Service list, choose MySQL.
    6. In the Servers list, select each server hosting MySQL to be managed under this server collection and then click Save.
  6. Create a server connection:
    1. From the main menu, choose Configuration > System Manager > Server Connections, click New Connection, and then select or type the following information for the server hosting MySQL.
      Server Role
      Choose MySQL.
      Server
      Choose the server where the MySQL service is running.
      Credentials
      Choose the credentials for the MySQL service.
      URL Base
      If needed, change the default value for the service.
      Protocol
      Defaults to http.
      Port
      Defaults to 8095. If you change the port here, change it also in the Services Manager Web Service.
      Timeout
      Defaults to 200000 milliseconds.
    2. Click Save.
    3. From the main menu, choose Configuration > System Manager > Server Connections and click the icon in the Test column for the SharePoint server. The icon turns green for a successful connection. A red icon indicates an unsuccessful connection. Mouse over it for information about the failed connection.