Server concepts in Azure Database for MySQL
This article provides considerations and guidelines for working with Azure Database for MySQL servers.
What is an Azure Database for MySQL server?
An Azure Database for MySQL server is a central administrative point for multiple databases. It is the same MySQL server construct that you may be familiar with in the on-premises world. Specifically, the Azure Database for MySQL service is managed, provides performance guarantees, and exposes access and features at server-level.
An Azure Database for MySQL server:
- Is created within an Azure subscription.
- Is the parent resource for databases.
- Provides a namespace for databases.
- Is a container with strong lifetime semantics - delete a server and it deletes the contained databases.
- Collocates resources in a region.
- Provides a connection endpoint for server and database access.
- Provides the scope for management policies that apply to its databases: login, firewall, users, roles, configurations, etc.
- Is available in multiple versions. For more information, see Supported Azure Database for MySQL database versions.
Within an Azure Database for MySQL server, you can create one or multiple databases. You can opt to create a single database per server to use all the resources or to create multiple databases to share the resources. The pricing is structured per-server, based on the configuration of pricing tier, Compute Units, and storage (GB). For more information, see Pricing tiers.
How do I connect and authenticate to an Azure Database for MySQL server?
The following elements help ensure safe access to your database.
|Authentication and authorization||Azure Database for MySQL server supports native MySQL authentication. You can connect and authenticate to a server with the server's admin login.|
|Protocol||The service supports a message-based protocol used by MySQL.|
|TCP/IP||The protocol is supported over TCP/IP and over Unix-domain sockets.|
|Firewall||To help protect your data, a firewall rule prevents all access to your database server, until you specify which computers have permission. See Azure Database for MySQL Server firewall rules.|
|SSL||The service supports enforcing SSL connections between your applications and your database server. See Configure SSL connectivity in your application to securely connect to Azure Database for MySQL.|
How do I manage a server?
You can manage Azure Database for MySQL servers by using the Azure portal or the Azure CLI.