Edit

Remove the MySQL resource provider in Azure Stack Hub

  • Article

Important

Starting from Azure Stack Hub build 2108, the SQL and MySQL resource providers are offered to subscriptions that have been granted access. If you want to start using this feature, or if you need to upgrade from a previous version, open a support case and our support engineers will guide you through the deployment or upgrade process.

Removing the MySQL resource provider will delete:

  • The MySQL resource provider.
  • The associated plans and quotas managed by operator.
  • The metadata in Azure Stack Hub for the hosting server, database, and logins.

Removing the SQL resource provider will not delete:

  • The tenant databases on the hosting servers.
  • The packages used to install MySQL RP.

To remove the MySQL resource provider V1

  1. Verify that you've removed all the existing MySQL resource provider dependencies.

    Note

    Uninstalling the MySQL resource provider will proceed even if dependent resources are currently using the resource provider.

  2. Get a copy of the MySQL resource provider installation package and then run the self-extractor to extract the contents to a temporary directory. You can find the download links for the resource provider installers in Deploy the MySQL resource provider prerequisites.

  3. Open a new elevated PowerShell console window and change to the directory where you extracted the MySQL resource provider installation files.

    Important

    We strongly recommend using Clear-AzureRmContext -Scope CurrentUser and Clear-AzureRmContext -Scope Process to clear the cache before running the script.

  4. Run the DeployMySqlProvider.ps1 script using the following parameters:

    • Uninstall: Removes the resource provider and all associated resources.
    • PrivilegedEndpoint: The IP address or DNS name of the privileged endpoint.
    • AzureEnvironment: The Azure environment used for deploying Azure Stack Hub. Required only for Microsoft Entra deployments.
    • CloudAdminCredential: The credential for the cloud administrator, necessary to access the privileged endpoint.
    • AzCredential: The credential for the Azure Stack Hub service admin account. Use the same credentials that you used for deploying Azure Stack Hub. The script will fail if the account you use with AzCredential requires multi-factor authentication (MFA).

To remove the SQL resource provider V2

  1. Sign in to the Azure Stack Hub administrator portal.

  2. Select Marketplace Management on the left, then select Resource providers.

  3. Select MySQL resource provider from the list of resource providers. You may want to filter the list by Entering “SQL Server resource provider” or “MySQL Server resource provider” in the search text box provided.

    Select RP in the Marketplace.

  4. Select Uninstall from the options provided across the top the page.

    Select Uninstall in the Marketplace.

  5. Enter the name of the resource provider, then select Uninstall. This action confirms your desire to uninstall:

    • The MySQL Server resource provider.
    • All admin/user created SKU/Quota/HostingServer/Database/Login metadata.

    Screenshot of uninstall confirmation.

  6. (Optional) If you want to delete the installation package, after uninstalling the MySQL resource provider, select Delete from the MySQL resource provider page.

    Screenshot of deleting package.

Next steps

Offer App Services as PaaS