After you add the MySQL agent to the Azure virtualization client, you can configure the instance endpoint. The VM instance must have access to the Azure service endpoints.
Procedure
-
From the CommCell Browser, expand Client Computers > client > MySQL.
-
Right-click the agent, point to All Tasks > New MySQL Server.
The MySQL Create Instance dialog box appears.
-
On the General tab, specify the following information:
-
From the Server Name list, select the Azure database instance.
-
In the Version box, enter the Azure database server version.
-
In the Endpoint box, type the endpoint that you use to connect to the Azure MySQL database.
The endpoint includes the DNS names and the port number, for example, mysqldb.example.eu-central-1.abc.Azure.com:3306.
-
Click the Credential list, and then click Create New to add a new credential.
-
From the Data Storage policy list, select the storage policy.
-
-
Click OK.
Note
-
For a Windows client computer, if the instance creation with SSL certificate fails, you can select only the Use SSL options check box, and leave the SSL CA file box blank. For more information, go to Microsoft Documentation, Connecting to server using the MySQL CLI over SSL.
-
After creating a MySQL instance, for MariaDB, ensure that MariaDB and MySQL 5.6.x or later must be installed on the proxy client. If you have MariaDB under Azure cloud, in the CommCell Console, add MariaDB version, MySQL version along with the bin path in the MySQL cloud node.