Add-MgmtSvcMySqlHostingServer
Adds a MySQL hosting server to Windows Azure Pack.
Syntax
Add-MgmtSvcMySqlHostingServer
[-ServerGroupId] <String>
[-Name] <String>
[-TotalSpaceMB] <Int32>
[-User] <PSCredential>
[-AdminUri] <Uri>
[-Token] <String>
[-DisableCertificateValidation]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Add-MgmtSvcMySqlHostingServer
[-ServerGroupId] <String>
[[-HostingServer] <MySqlHostingServer>]
[-AdminUri] <Uri>
[-Token] <String>
[-DisableCertificateValidation]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Description
The Add-MgmtSvcMySqlHostingServer cmdlet adds a MySQL hosting server to Windows Azure Pack for Windows Server.
Examples
Example 1: Add a MySQL hosting server
PS C:\> $Creds = Get-Credential
PS C:\> Add-MgmtSvcMySqlHostingServer -AdminUri "https://Computer01:30004" -Token $Token -Name "MySQLServer01.Contoso.com" -TotalSpaceMB 2048 -ServerGroupId "foe629" -User $CredsNOTE: This example assumes that you have created a token by using Get-MgmtSvcToken and have stored it in a variable named $Token.
The first command prompts the user for credentials which are stored in the $Creds variable.
The second command uses the credentials provided in the first command to add the MySQL server named MySQLServer01.Contoso.com to the MySQL server group with the ID of foe629.
Parameters
-AdminUri
Specifies the URI of the Windows Azure Pack administrator API. Use the following format: https://<computer>:<port>, where <computer> is the computer on which the administrator API is installed.
| Type: | Uri |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-Confirm
Prompts you for confirmation before running the cmdlet.
| Type: | SwitchParameter |
| Aliases: | cf |
| Position: | Named |
| Default value: | False |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DisableCertificateValidation
Disables certificate validation for the Windows Azure Pack installation.
If you specify this parameter, you can use self-signed certificates.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-HostingServer
Specifies a MySQL hosting server object.
| Type: | MySqlHostingServer |
| Position: | 2 |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-Name
Specifies the name of a SQL server.
If you want your application databases to be publically accessible, ensure that you use a publically-accessible IP address or FQDN.
| Type: | String |
| Position: | 2 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-ServerGroupId
Specifies the ID for a SQL server group.
| Type: | String |
| Position: | 5 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-Token
Specifies an identity token. To create a token, use the Get-MgmtSvcToken cmdlet.
| Type: | String |
| Position: | 1 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-TotalSpaceMB
Specifies the size, in megabytes (MB) of the hosting server.
| Type: | Int32 |
| Position: | 3 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-User
Specifies a user account and password as a PSCredential object. To create a PSCredential object, use the Get-Credential cmdlet.
| Type: | PSCredential |
| Position: | 4 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-WhatIf
Shows what would happen if the cmdlet runs. The cmdlet is not run.
| Type: | SwitchParameter |
| Aliases: | wi |
| Position: | Named |
| Default value: | False |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |