Azure Databases Print

  • microsofttechnology, microsoft, database, backup, restore, woocommerce, performance, firewall, password, caching
  • 0

Managed data services.

WHAT OPTIONS EXIST

Managed relational databases Document and multi-model databases Managed open-source database services In-memory caching

WHAT MANAGED MEANS

Patching, backups, high availability and monitoring provided.

WHAT YOU STILL OWN

The schema Query performance Indexing Access control within the database

WHAT DEPLOYMENT OPTIONS EXIST FOR RELATIONAL DATABASES

A single database Pooled databases sharing capacity A managed instance, closer to a full server

WHAT POOLING SUITS

Many databases with variable, uncorrelated load.

WHY

They share capacity rather than each being provisioned for its peak.

WHAT TO CONFIGURE

Backup retention Geographic replication, where required Firewall rules and private access Authentication through the directory rather than database credentials

WHY THAT LAST POINT

It removes stored passwords and centralises access control.

WHAT TO MONITOR

Query performance Resource utilisation against the purchased tier Storage growth

WHAT TO TEST

Restoring from backup.

WHY

Managed backups are not proof of recoverability until restored.


Was this answer helpful?
Back

Are you happy with your experience? Leave us a review on Trustpilot.


Trustpilot