Azure Database

Azure DB gives an organized way to store data in Azure. Azure DB distributes databases in multiple zones and regions which gives high availability.
It increases durability by making copies and transaction logs in more than one zones and Azure region.

Database Categories in Azure

Azure offers multiple database categories to store your data.

Azure SQL Database

  • It gives 99.99 % availability and can store up to 100 TB of data.
  • It is flexible and offers serverless computing.
  • Works well with Microsoft-based applications.

Azure My SQL Database

  • It is a fully managed and scalable database option.
  • While creating MySQL DB in Azure, users can choose a single zone or multiple zones redundant.
  • Automatic updates and backup facility available.

Azure Database for PostgreSQL

  • Users can choose a single zone or multiple zones to increase availability.
  • It gives you the option for a single server and hype scaling.

What is HyperScale?
It allows scaling the database to hundreds of nodes to execute queries.

Read this blog also - 
Microsoft Azure Storage – Benefits, Types and More
Microsoft Azure Fundamentals (AZ-900) Certification Sample Questions

Azure Cosmos DB (Azure No SQL DB)

  • Azure Cosmos provides No SQL DB in Azure
  • Fully managed NoSQL database service by Azure.
  • It automatically replicates data across multiple Azure regions which increases the availability.
  • Azure Cosmos DB is a schema-less DB and offers auto-scaling.
  • It supports Mongo DB, JSON, Cassandra, and Gremlin (Graph) types of data.

In Memory DB (Azure Cache for Redis)

  • Accessing data from memory is much faster than accessing data from a disk.
  • Azure Cache for Redis offers In-Memory DB based on Redis software.
  • Azure Cache for Redis can be used for Caching, Session management etc.
  • It improves performance.

DB for Analytics

Azure Synapse Analytics.

Database Recovery terminology

How quickly we can recover data and how much data loss can happen, is decided by the below 2 points

  • RPO (Recovery Point Objective) – It is the maximum acceptable duration of data loss.
  • RTO (Recovery Time Objective) – It tells about the maximum acceptable downtime

Data Consistency

  • Strong Consistency – It allows synchronous replication to all standby databases. The more standby databases you have the slower your transaction will perform. As it replicates data synchronously to a stand-by database.
  • Eventual Consistency – It is an Asynchronous replication and replicates data to stand-by databases with a little lag.
  • Read After Write Consistency – Data insertion is immediately available in stand-by DB, however, updates follow eventual consistency.

Hope you like this blog. Please follow the blog to get updated notes on Microsoft Azure Cloud Service.

You may read articles on AZ 900.

Leave a Comment