Day 10: What is Databases and Networking in azure

Anand RavalAnand Raval
5 min read

Databases

  • Multiple database services to store a wide variety of data types and volumes.

  • Have global connectivity and instant data availability

Azure Cosmos DB

  • ๐Ÿ“ Globally distributed (= multiple regions) database service

  • Supports schema-less data, stores JSON

  • ๐Ÿ’ก Good for Always On applications to support constantly changing data.

  • ๐Ÿ’ก Good for data used by & maintained by users around the globe.

Azure Cache for Redis

  • Caches frequently used and static data to reduce data and application latency

Azure SQL Database Options

  • Azure Database for MySQL: Fully managed and scalable MySQL

  • Azure Database for PostgreSQL: Fully managed and scalable PostgreSQL

  • Azure Database for MariaDB: Fully managed and scalable MariaDB

  • SQL server on VMs: Host SQL servers in own VPNs

Azure SQL Database

  • Relational database as a service (DaaS)

  • Based on the latest stable version of the Microsoft SQL Server database engine.

  • High-performance, reliable, fully managed and secure database

Azure Database Migration Service

  • Allows to migrate existing SQL Server to Azure

  • Performs all of the required steps.

  • Minimal downtime

  • Uses the Microsoft Data Migration Assistant

    • Generate assessment reports that provide recommendations

Azure Synapse Analytics

  • Formerly SQL Data Warehouse

  • ๐Ÿ“ A cloud data warehouse for the enterprise

  • Characterized by high resiliency through automatic scaling.

  • Massive parallel processing (MPP) to run complex queries quickly across petabytes of data

Azure HDInsight

  • ๐Ÿ“ A big data and advanced analytics service providing open-source analytics, processing and integrations with big data frameworks, including:

    • Apache Hadoop

    • Apache Spark

    • Apache HBase

    • Apache Kafka

  • Useful for big data tasks such as ETL (Extract, Transform, Load), data warehousing, machine learning, and IoT.

Networking

  • Helps you optimize application performance & scalability

  • Links compute resources and provides access to applications

  • Configure & control traffic into and out of Azure efficiently e.g. from on-premises to Azure and vice versa.

Loosely Coupled Architecture

  • Architecture behind Azure

  • Different services/components that sends and receives data from one another

    • They have little to no knowledge about other components.
  • See also micro-services.

  • ๐Ÿ’ก Recommended because:

    • Can be updated independently: Allows non-breaking changes as long as communication strategy is consistent.

    • Allows services to be changed without significant impact to the rest of the system.

    • Can be scaled proportionally.

      • Scale up/down, out/in only services that are relevant.

      • ๐Ÿ’ก Take advantage of asynchronous messaging in Azure for communication for scalability.

N-tier architecture

  • Can be used to build loosely coupled architectures.

  • Divides an application into two or more logical tiers.

    • A higher tier can access services from a lower tier, but a lower tier should never access a higher tier.
  • Tiers help separate concerns and are ideally designed to be reusable.

  • Simplifies maintenance: Tiers can be updated or replaced independently, and new tiers can be inserted if needed.

  • Three-tier refers to an n-tier application that has three e.g.

    • Web tier (front-end)

    • Application tier (back-end that runs application logic)

    • Data tier (database)

    • Observe that each tier can access services only from a lower tier.

  • Read more

Concepts

Region

  • One or more Azure data centers within a specific geographic location

  • E.g. East US, West US, and North Europe

Azure Virtual Network

  • Enable you to group and isolate related systems

  • Logically isolated network on Azure

  • Allows Azure resources to securely communicate with โ€ข each other โ€ข VPNS โ€ข the internet โ€ข on-premises networks

  • โ— Scoped to a single region

  • ๐Ÿ’ก๐Ÿ“ Virtual networks, subnets, NICs (network interfaces) are free (no $$) resources

    • Public IP addresses, reserved IP, network appliances such as VPN Gateway & Application Gateway are charged.
  • You choose which networks your virtual network can reach, whether that's the public internet or other networks in the private IP address space.

Subnet

  • A virtual network can be segmented into one or more subnets.

  • Help you organize and secure your resources in discrete sections.

  • E.g. users interact with the web tier directly, so that VM has a public IP address along with a private IP address.

    • Users don't interact with the application or data tiers, so these VMs each have a private IP address only.

VPN Gateway

  • ๐Ÿ“ Also called virtual network gateway

  • ๐Ÿ“ Provide a secure connection between an Azure Virtual Network and an on-premises location over the internet.

  • ๐Ÿ“ Your on-premises network is represented as Local network gateway object in Azure.

  • E.g. enables you to keep your data tiers in on-premises network, and web tier in cloud.

  • Azure manages the physical hardware for you, virtual networks & gateways are configured through software.

  • ๐Ÿ“โ— Must be deployed in a subnet called gateway subnet.

Network security group (NSG)

  • ๐Ÿ“ Control what traffic can flow through a virtual network.

  • Allows or denies inbound network traffic to your Azure resources.

  • Can be thought as a cloud-level firewall for your network.

  • E.g. web tier allows inbound traffic on ports 22 (SSH) and 80 (HTTP).

    • Port 22 enables you to connect directly to Linux systems over SSH.

      • You might configure VPN access to your virtual network to increase security.
  • ๐Ÿ’ก Configure a NSG to accept traffic only from known sources, such as IP addresses that you trust.

Other services

  • Azure ExpressRoute

    • Connects to Azure over high-bandwidth dedicated secure connections
  • Azure Network Watcher

    • Monitors and diagnoses network issues using scenario-based analysis
  • Azure Virtual WAN

    • Creates a unified wide area network (WAN), connecting local and remote sites
  • Network protection services: โ€ข Azure DDoS Protection โ€ข Azure Firewall

0
Subscribe to my newsletter

Read articles from Anand Raval directly inside your inbox. Subscribe to the newsletter, and don't miss out.

Written by

Anand Raval
Anand Raval

"I'm a 3rd-year Computer Engineering student at Marwadi University with skills in C++, web development (MERN stack), and DevOps tools like Kubernetes. I contribute to open-source projects and share tech knowledge on GitHub and LinkedIn. I'm learning cloud technologies and app deployment. As an Internshala Student Partner, I help others find jobs and courses." now currently focusing on #90DaysOfDevops