Azure Arc-enabled SQL Managed Instance enables the deployment of Azure SQL data services anywhere. Microsoft promises to deliver this service with total compatibility with SQL server database engine and integrated management capabilities. The Azure Arc-enabled SQL Managed Instance was deployed on PowerFlex platform from the Azure portal.
Perform the following steps to deploy the Azure Arc-enabled managed SQL instance on PowerFlex platform:
Log in to Azure Data CLI with the Azure Arc data controller details to ensure that the data controller is present and running. Enter the namespace, username, and password of the data controller to log in.
PS C:\Users\Admin> Azure Data CLI login
Logged in successfully to `https://192.168.150.122:30080` in namespace `arc`. Setting active context to `arc`.
The Azure Arc SQL managed instance is created from the Azure portal. The following set of values is passed as input parameters – resource group, custom location, compute, storage, and administrative account details.
The custom location must be the location on which the data controller is installed. The memory size and CPU values are passed as per the requirement. The storage parameters include data, log and backup volume size, and storage class names.
The Azure Arc-enabled SQL Managed Instance state is verified by using the following Azure Data CLI command:
PS C:\Users\Admin> Azure Data CLI arc sql mi list
Name PrimaryEndpoint Replicas State
------- --------------------- ---------- -------
sqldemo 192.168.150.122,30719 1/1 Ready
The Kubernetes cluster is verified by checking if the status of the sqldemo pod is Running.
From the Azure Data Studio, connect to the deployed Azure Arc-enabled SQL Managed Instance by entering the endpoint and credentials.
The deployed Azure Arc-enabled SQL Managed Instance is monitored and managed from the Azure portal and Azure Data Studio that is installed on the Windows client machine.