Azure SQL HADR options

Naturally, the options are much better when you use Azure SQL Database than with MySQL. Brief highlights of all the options are listed and users are encouraged to choose their database server based on their own needs. You can create a test database to see the options yourself, as shown in the following screenshot:

The advanced options are shown in the following screenshot:

We only want to highlight two of the advanced options that we looked at in the previous section for MySQL, which are also available with Azure SQL Database:

  • Active Directory (AD) admin: You can connect your company's Azure AD to provide controlled access to the databases.
  • Auditing: Fine-grained auditing, even for row-level access, can be set.

Another great feature is that Geo-Replication can also be easily added, as shown in the following screenshot:

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset