As you might have followed along the PaaS series on this website then this is the last PaaS resource provider we need to enable. And actually, in my opinion, the easiest one. Its fully automated but it is important that you run this as Administrator. I assumed you have updated the Powershell version on the CLIENTVM to the latest version as described here. I created this script to start the installer script:
1 2 3 4 5 6 7 |
$target = New-Item D:\MySQL -ItemType Directory Invoke-WebRequest -Uri http://aka.ms/MASMySQLRP -OutFile $target\MASMySQLRP.zip $source = "$target\MASMySQLRP.zip" Expand-Archive -Path $source -DestinationPath $target Set-Location $target Start-Process .\Bootstrap.cmd -Credential (Get-Credential AZURESTACK\Administrator) |
When prompted enter the AzureStack Administrator Password:
This will start a bootstrap ISE window. Hit F5 to execute the script
Now before we start you maybe never used the Administrator account to login the CLIENTVM. We need to add the portal.azurestack.local and the login page for Azure AD to the trusted sites. Type in the command shell (blue screen) start https://portal.azurestack.local and login once. Then close the browser. You might need to setup the login for Azure AD to add to the trusted sites and allow cookies:
Ok, From now in its super simple. We start at the prepare mysql prerequisites. Skip the readme tab and select the New-SslCert.ps1 tab and hit F5. Specify password P@ssw0rd for the pfxfile. :
This will as you might expect create a certificate for the MySQL environment. You can verify after the script has ran the files in this location D:\MySQL\Prerequisites\BlobStorage\Container:
Now click on the Download-MySQLServer.ps1 and hit F5. The script will start and open up IE page for the license agreement
Close the IE browser an click continue:
When that’s done go to the next tab Upload-Microsoft.MySQL-RP.ps1 This will create a resource group, a storage account and then uploads the content we downloaded and created earlier:
The last part of the prepare tab is to publish gallery packages. This will enable in the portal the option to deploy the MySQL server from the marketplace. Just hit F5:
And that was the preparation part!
Now hop over to the Deploy-MySQLProvider TAB and start with the subtab Microsoft.MySql-provider.parameters.json and add the username and password:
Next go to the Deploy-Microsoft-MySql-provider.ps1 script and hit F5. It will ask for the tenant Azure AD name. Type yours and hit enter again:
Now the MySQL Resource provider will be deployed in Azure Stack. This might take a while to complete. For me it took 1 hour and 5 minutes:
So when that’s done go to the register-Microsoft.MySQL-fqdn.ps1 and hit F5. Again provide the name of your Azure AD and hit enter. This script will look up the external IP for the MySQL VM and register it in the DNS using an invoke-command to the ADVM:
Then we need to go to the Register-Microsoft.MySQL-Provider.ps1 As you might guess… Hit F5 and enter the Azure AD name and then the credentials you have specified in the parameters.json file earlier in this tutorial (basicAuthUsername & basicAuthPassword):
And if all goes correct we will have the output below:
The last 2 tabs are there for deploying MySQL Database using ARM templates and PowerShell. You can specify parameters and then go to the script(last tab)
In the last tab Hit F5 and you have your first mySQL DB enrolled:
Now let’s add the MySQL resource provider to the POC Plan. Go to the Azure Stack portal as Service Administrator and go to the Plan and add the MySQL resource provider:
You will notice when configure quota it is saying “coming soon”, just click on OK. Now we have the MySQL available for tenants as well. Strange enough i have 2 MySQL items available:
Enjoy!
Mark Scholman