Set-MgmtSvcMySqlHostingServer

Updates a MySQL hosting server.

Syntax

Set-MgmtSvcMySqlHostingServer
   [-HostingServerId] <String>
   [-Name] <String>
   [-TotalSpaceMB] <Int32>
   [-User] <PSCredential>
   [-AdminUri] <Uri>
   [-Token] <String>
   [-DisableCertificateValidation]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]
Set-MgmtSvcMySqlHostingServer
   [[-HostingServer] <MySqlHostingServer>]
   [-AdminUri] <Uri>
   [-Token] <String>
   [-DisableCertificateValidation]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]

Description

The Set-MgmtSvcMySqlHostingServer cmdlet updates a MySQL hosting server.

Examples

Example 1: Update a MySQL hosting server

PS C:\> $Creds = Get-Credential
PS C:\> Set-MgmtSvcMySqlHostingServer -AdminUri "https://Computer01:30004" -Token $Token -Name "MySQLServer01.Contoso.com" -TotalSpaceMB 4096 -User $Creds -HostingServerId "v48l25"

NOTE: 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 and stores the provided user name and password in the $Credential variable.

The second command updates the total space to 4096 MB for the hosting server named MySQLServer01.Contoso.com.

Required 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
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-HostingServerId

Specifies the ID of a MySQL hosting server.

Type:String
Position:5
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-Name

Specifies the name of a SQL hosting server.

Type:String
Position:2
Default value:None
Accept pipeline input:True (ByPropertyName)
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
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-TotalSpaceMB

Specifies the size, in megabytes (MB) of the hosting server.

Type:Int32
Position:3
Default value:None
Accept pipeline input:True (ByPropertyName)
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
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

Optional Parameters

-Confirm

Prompts you for confirmation before running the cmdlet.

Type:SwitchParameter
Aliases:cf
Position:Named
Default value: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
Accept pipeline input:False
Accept wildcard characters:False
-HostingServer

Specifies a MySQL hosting server object.

Type:MySqlHostingServer
Position:2
Default value:None
Accept pipeline input:True (ByValue)
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
Accept pipeline input:False
Accept wildcard characters:False