Azure Classroom Series – 25/Nov/2021

Azure Database for MySQL

  • Azure Database for MySQL is a relational database service offered by Azure
    • Zone redund and same zone high availability
    • Data protection using automatic backups and point in time restore fo up to 35 days
    • Automatic patching and maintenance for underlying hardware, os and database engine
    • Predicatable performance
    • Monitoring and automation to simplify management for large scale deployments
  • Azure Database for MySql is available in two deployment models
    • Flexible Server:
      • This architecture allows users to opt for high availability within single AZ and across multiple AZ
      • Flexible Servers provide better cost optimization controls with the ability to stop/start server.
      • Reservations for Flexibile server allows users to save cost upto 63%
      • Suited for:
        • Ease of deployments, simplified scaling & low database management overhead for functions like backups, HA, security and monitoring
        • Application developments requiring community version of MySQL
        • Enterprise Grade Security
    • Single Server:
      • This is fully managed MySQL designed for minimal customization.
      • The single server platform is designed to handle most of the database management functions such as patching, backups, minimal user configuration
      • The architecture is optimized for built-in HA with 99.99%
      • Suited for:
        • Existing applications already leveraging single server.
      • Recommends flexible server deployment
  • Create an Azure Database for MySQL Flexible Servers Preview Preview Preview Preview Preview Preview
  • Like Offering for MySQL Azure Also offers single server and flexible server for PostgreSQL
  • With Azure Database for MySQL, Postgres ensure you select private access and add your vnet where your applications are running for private connectivity

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

About learningthoughtsadmin