MySQL Database on Azure service overview
Features of MySQL Database on Azure
MySQL Database on Azure is the MySQL cloud database service that we launched on the Azure platform. It is a type of relational database service that is fully compatible with MySQL protocols. It gives you a fully-managed database service that features stable performance, rapid deployment, high availability, and high security. To cater to various user performance requirements, the MySQL Database on Azure service provides six different versions that offer performance in multiples from low to high.
Benefits of MySQL Database on Azure
With the MySQL Database on Azure fully-managed database platform service, you can focus on service logic development without worrying about infrastructure details. Contrast this efficiency with building your own local database or using solutions that are created with virtual machines (VMs). MySQL Database on Azure provides the following benefits:
You no longer need to keep recalculating your database server configuration requirements, or worry about how to adjust various aspects of the configuration to achieve better database performance.
The MySQL Database on Azure service is available in several versions, so you can choose the version that matches your current performance requirements and then flexibly upscale or downscale it as actual operating conditions change.
If your service scenario has a high read/write ratio, we recommend that you create a read-only instance and separate reading and writing, so that your service has better horizontal scaling. For specifics, see Create and use read-only instances.
To help you monitor real-time indicators and historical data for every aspect of database performance, MySQL Database on Azure provides more than 20 types of monitoring indicators. The indicators help you to better understand database usage, identify problems, and make adjustments in a timely manner.
You can also open and download database logs, which help database administrators to better manage and optimize the database. For specifics, see Monitor and manage MySQL Database on Azure.
To provide high reliability for data, MySQL Database on Azure uses Azure geo-redundant storage. The service automatically synchronizes and replicates three local copies in the same region.
To ensure that a high level of reliability is maintained for your data, MySQL Database on Azure uses an asynchronous method to make three offsite copies in regions that are more than 1,000 kilometers away.
MySQL on Azure provides smart backup and restore solutions.
MySQL Database on Azure provides a firewall function that can whitelist your client-side public IP address (or IP address block) and supports SSL connections for database access. For more information about SSL configuration, see Use SSL to securely access MySQL Database on Azure. More specifically, MySQL Database on Azure provides the following functions:
Full backup: MySQL Database on Azure automatically performs a full backup of your MySQL database every day at a time you specify. Backups are retained for 30 days. You can also instantly create full backups manually. Storage space for backups is provided completely free of charge, so you don’t need to pay any additional fees for backups.
Incremental backup: To enable rollback based on any point in time, MySQL Database on Azure automatically backs up newly added sections or changes to the database for the last seven days.
Database restore: You can restore the database to any point in time in the last seven days, or you can restore a full backup. MySQL Database on Azure can restore to the current database instance or a new instance.
For more information about backup and restore methods, see Back up and restore MySQL Database on Azure.
MySQL Database on Azure uses a high-availability architecture that guarantees database server availability rates in excess of 99.9 percent and delivers rapid failover. To ensure service continuity, MySQL Database on Azure also provides you with disaster recovery solutions. For more information, see MySQL on Azure service continuity solutions.
MySQL Database on Azure makes it easy to deploy a MySQL database server that has high availability in just one or two minutes. It also provides an automatic software patch function, which means that you don’t need to perform any maintenance on the database service. To find out how to quickly deploy a MySQL database server, see the introductory course titled Create and use your first MySQL cloud database server..
MySQL Database on Azure is compatible with MySQL protocols and supports MySQL 5.5, MySQL 5.6, and MySQL 5.7. You can perform database development and integration by using common platforms and technologies that support MySQL. You can also use familiar management tools, such as MySQL Workbench and Navicat for MySQL.
MySQL Database on Azure supports offsite database synchronization. For example, you can set a MySQL instance outside Azure as the primary database and an instance running on Azure as the secondary database. You can then use standard MySQL primary/secondary data synchronization methods to sync the data to Azure. This approach enables MySQL Database on Azure to meet a range of hybrid cloud scenario requirements for business.
Database synchronization features can also help you deliver a superior and more flexible cloud migration experience. For the specific configuration steps involved, see Synchronize the replication of a local database to MySQL Database on Azure.
MySQL Database on Azure supports the use of PowerShell. For more information, see Use PowerShell to rapidly create a MySQL cloud database).
To develop automated deployment directly by using REST API, see Technical documentation for REST API ).