Describe relational Azure data services Flashcards
Azure SQL - Family
Azure SQL is a collective term for a family of Microsoft SQL Server based database services in Azure. Specific Azure SQL services include:
-SQL Server on Azure Virtual Machines (VMs)
-Azure SQL Managed Instance
-Azure SQL Database
-Azure SQL Edge: A SQL engine that is optimized for Internet-of-things (IoT) scenarios that need to work with streaming time-series data.
SQL Server on Azure Virtual Machines (VMs)
A virtual machine running in Azure with an installation of SQL Server.
-Type of cloud service: IaaS
-SQL Server compatibility: Fully compatible with on-premises physical and virtualized installations. Applications and databases can easily be “lift and shift” migrated without change.
-Architecture: SQL Server instances are installed in a virtual machine. Each instance can support multiple databases.
-Availability: 99.99%
-Management: You must manage all aspects of the server, including operating system and SQL Server updates, configuration, backups, and other maintenance tasks.
-Use cases: Use this option when you need to migrate or extend an on-premises SQL Server solution and retain full control over all aspects of server and database configuration.
Azure SQL Managed Instance
Provides near-100% compatibility with on-premises SQL Server instances while abstracting the underlying hardware and operating system.
-Type of cloud service: PaaS
-SQL Server compatibility: Near-100% compatibility with SQL Server. Most on-premises databases can be migrated with minimal code changes by using the Azure Database Migration service.
-Architecture: Each managed instance can support multiple databases. Additionally, instance pools can be used to share resources efficiently across smaller instances.
-Availability: 99.99%
-Management: Fully automated updates, backups, and recovery.
-Use cases: Use this option for most cloud migration scenarios, particularly when you need minimal changes to existing applications.
Azure SQL Database
A fully managed, highly scalable PaaS database service that is designed for the cloud.
-Type of cloud service: PaaS
-SQL Server compatibility: Supports most core database-level capabilities of SQL Server. Some features depended on by an on-premises application may not be available.
-Architecture: You can provision a single database in a dedicated, managed (logical) server; or you can use an elastic pool to share resources across multiple databases and take advantage of on-demand scalability.
-Availability: 99,995%
-Management: Fully automated updates, backups, and recovery.
-Use cases: Use this option for new cloud solutions, or to migrate applications that have minimal instance-level dependencies.
Azure SQL - Single Database & Elastic Pool
Azure SQL Database is available as a Single Database or an Elastic Pool:
-Single Database enables you to quickly set up and run a single SQL Server database. You create and run a database server in the cloud, and you access your database through this server. Microsoft manages the server, so all you have to do is configure the database, create your tables, and populate them with your data. You can scale the database if you need more storage space, memory, or processing power. By default, resources are pre-allocated, and you’re charged per hour for the resources you’ve requested. You can also specify a serverless configuration.
-Elastic Pool by default multiple databases can share the same resources, such as memory, data storage space, and processing power through multiple-tenancy. The resources are referred to as a pool. You create the pool, and only your databases can use the pool. This model is useful if you have databases with resource requirements that vary over time, and can help you to reduce costs.
Azure database services for open-source database systems
In addition to Azure SQL services, Azure data services are available for other popular relational database systems, including MySQL, MariaDB, and PostgreSQL. The primary reason for these services is to enable organizations that use them in on-premises apps to move to Azure quickly, without making significant changes to their applications.
Azure Database for MySQL
Azure Database for MySQL is a PaaS implementation of MySQL in the Azure cloud, based on the MySQL Community Edition.
-High availability features built-in.
-Predictable performance.
-Easy scaling that responds quickly to demand.
-Secure data, both at rest and in motion.
-Automatic backups and point-in-time restore for the last 35 days.
-Enterprise-level security and compliance with legislation.
-The system uses pay-as-you-go pricing so you only pay for what you use.
-Azure Database for MySQL servers provides monitoring functionality to add alerts, and to view metrics and logs.
Azure Database for MariaDB
Azure Database for MariaDB is an implementation of the MariaDB database management system adapted to run in Azure. It’s based on the MariaDB Community Edition.
The database is fully managed and controlled by Azure. Once you’ve provisioned the service and transferred your data, the system requires almost no additional administration.
-Built-in high availability with no additional cost.
-Predictable performance, using inclusive pay-as-you-go pricing.
-Scaling as needed within seconds.
-Secured protection of sensitive data at rest and in motion.
-Automatic backups and point-in-time-restore for up to 35 days.
-Enterprise-grade security and compliance.
Azure Database for PostgreSQL
Azure Database for PostgreSQL to run a PaaS implementation of PostgreSQL in the Azure Cloud. This service provides the same availability, performance, scaling, security, and administrative benefits as the MySQL service.
Some features of on-premises PostgreSQL databases aren’t available in Azure Database for PostgreSQL. These features are mostly concerned with the extensions that users can add to a database to perform specialized tasks, such as writing stored procedures in various programming languages (other than pgsql, which is available), and interacting directly with the operating system. A core set of the most frequently used extensions is supported, and the list of available extensions is under continuous review.
-Is a highly available service. It contains built-in failure detection and failover mechanisms.
-Users of PostgreSQL will be familiar with the pgAdmin tool, which you can use to manage and monitor a PostgreSQL database. You can continue to use this tool to connect to Azure Database for PostgreSQL.
Azure Database for PostgreSQL Flexible Server: The flexible-server deployment option for PostgreSQL is a fully managed database service. It provides a high level of control and server configuration customizations, and provides cost optimization controls.