azure-database-for-mysql-5c70499.md

Azure Database for MySQL

Consume Azure Database for MySQL with SAP Private Link service.

Creation Request

The following Cloud Foundry service-specific configuration parameters are supported during a service instance creation:

resourceId (required)	Identifies the resource on Azure the private link should be created for.
subResource (required)	Identifies the subresource on Azure the private link should be created for.
requestMessage (optional)	Specifies a message which is shown for the approval request on Azure for the specified resource.

Sample Code:

{
    "resourceId": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/myResourceGroup/providers/Microsoft.DBforMySQL/servers/myMySQL",
    "subResource": "mysqlServer",
    "requestMessage": "Please approve connection"
}

Binding Credentials

The following binding credentials are provided:

---

hostname

DNS entry to connect to the Azure resource. This DNS entry resolves to the internal IP address associated with this private link.

Sample Code:

{
    ...
    "privatelink": [
        {
            ...
            "credentials": {
                "hostname": "MySQL.mysql.database.azure.com"
            }
        }
    ]
}

Further Information

Note:

Basic version of MySQL is not supported since it does not allow Private Endpoints creation. All supported versions can be found in the official Azure Database for MySQL documentation.

Sample Applications

There is no custom configuration needed to connect to the MySQL server via SAP Private Link.

Just use a MySQL client library of your choice and configure it to use the hostname from the service binding (and of course, username, password and any other settings).

Tutorials

Martin Pankraz published a blog post outlining the steps how set up a MySQL server and consume it via SAP Private Link:

SAP private linky swear with Azure – connecting to PaaS DBs with SAP Private Link Service