Configure SQL Server and MySQL Application databases for tenant use

 

Applies To: Windows Azure Pack

Use the following information to configure SQL Server and MySQL in Windows Azure Pack. Once you have connected to the SQL or MySQL instances, you can organize your database instances into groups.

Connect to the SQL Server instance

Use the following steps in the management portal for administrators to connect your newly installed SQL instance to Windows Azure Pack.

To connect to SQL Server

  1. In the management portal for administrators, click SQL Servers in the left navigation pane.

  2. At the bottom of the window, click New or Add, and then click Connect to to add the new instance.

  3. Enter the SQL Server instance information: group name, server name, administrator user name (sa), administrator password, and the size of the hosting server (in GBs).

  4. Click Connect.

    A message will be displayed at the bottom of the window indicating whether the action succeeded or failed.

  5. Click OK.

The SQL Server instance you just added is now displayed in the list of SQL Servers. Click the instance to view the details. You can confirm the hosting server’s capacity on the Dashboard and the list of databases in the instance on the Databases tab.

Note

If you are using SQL Server Availability Groups or Resource Governor (both may be on the same server), the SQL Server instances in the groups must comply with the following requirements:

  1. A SQL Server instance must not be configured for both high availability and non-high availability.

  2. A SQL Server instance must not be part of more than one group even if the groups are the same type (for example, both high availability).

Failure to follow these requirements will cause issues in the interaction between the SQL Server resource provider and the SQL Server.

Connect to the MySQL instance

Use the following steps in the management portal for administrators to connect your newly installed MySQL instance to Windows Azure Pack.

To connect to MySQL

  1. In the management portal for administrators, click MySQL Servers in the left navigation pane.

  2. At the bottom of the window, click New or Add, and then click Connect to to add the new instance.

  3. Enter the MySQL Server instance information: group name, server name, administrator user name, administrator password, and the size of the hosting server (in GBs).

  4. Click Connect.

    A message will be displayed at the bottom of the window indicating whether the action succeeded or failed.

  5. Click OK.

The MySQL Server instance you just added is now displayed in the list of SQL Servers. Click the instance to view the details. You can confirm the hosting server’s capacity on the Dashboard and the list of databases in the instance on the Databases tab.

Create groups

You can use groups to organize your SQL server or MySQL instances.

To create a SQL Server group

  1. On the SQL Servers dashboard, click Add, and then click Create a Group.

  2. Choose the type of group you want to create. You have two choices: Standalone servers or High availability (Always on enabled).

    If you want to use the SQL AlwaysOn availability groups feature, as described in Configure SQL AlwaysOn Availability Groups in Windows Azure Pack, choose High availability (Always on enabled).

  3. If you chose to create a standalone server group, enter a name for the group.

  4. If you chose to create a high availability group, enter a name for the group and enter the path to the network file share.

  5. Select Enable resource governance to create a group of servers that will be managed by the resource governor. Only servers running SQL Server 2014 Enterprise or later can be added to this group.

  6. Click Create a group

After the SQL Server group is created, you can add SQL servers to it from the Groups list.

To create a MySQL Server group

  1. On the MySQL Servers dashboard, click Add, and then click Create a Group.

  2. Enter a name for the group.

  3. Click Create a group

After the MySQL Server group is created, you can add MySQL servers to it from the Groups list.