在 Azure Stack Hub 上使用 SQL 資料庫Use SQL databases on Azure Stack Hub

使用 SQL 資源提供者在 Azure Stack Hub 上提供 SQL 資料庫。Use the SQL resource provider to offer SQL databases on Azure Stack Hub. 安裝資源提供者並將它連接至一或多個 SQL Server 執行個體之後,您和您的使用者可以建立:After you install the resource provider and connect it to one or more SQL Server instances, you and your users can create:

  • 適用於雲端原生應用程式的 SQL 資料庫。SQL databases for cloud-native apps.
  • 適用於 Web 應用程式的 SQL 資料庫。SQL databases for web applications.

安裝 SQL 資源提供者之前要考量的限制:Limitations to consider before installing the SQL resource provider:

  • 使用者只能建立及管理個別的資料庫。Users can only create and manage individual databases. 終端使用者無法存取資料庫伺服器執行個體。Database Server instance isn't accessible to end users. 這可能會對需要存取 master、Temp DB 或動態管理資料庫的內部部署資料庫應用程式產生相容性限制。This may limit compatibility with on-premises database apps that need access to master, Temp DB, or to dynamically manage databases.
  • 您的 Azure Stack Hub 操作員負責部署、更新、保護、設定和維護 SQL database 伺服器和主機。Your Azure Stack Hub operator is responsible for deploying, updating, securing, configuring, and maintaining the SQL database servers and hosts. RP 服務不會為任何主機和資料庫伺服器執行個體提供管理功能。The RP service doesn't provide any host and database server instance management functionality.
  • 不同訂用帳戶中不同使用者的資料庫可以位於相同的資料庫伺服器執行個體上。Databases from different users in different subscriptions may be located on the same database server instance. RP 不會提供任何機制來隔離不同主機或資料庫伺服器執行個體上的資料庫。The RP doesn't provide any mechanism for isolating databases on different hosts or database server instances.
  • RP 不會提供任何租用戶的資料庫使用報告。The RP doesn't provide any reporting on tenant usage of databases.
  • 您只能將 SQL 主控伺服器移到全域 Azure 中的另一個訂用帳戶。You can only move a SQL hosting server to another subscription in global Azure. Azure Stack Hub 不支援將 SQL 主控伺服器移至另一個訂用帳戶。Azure Stack Hub doesn't support moving a SQL hosting server to another subscription.

針對內部部署的傳統 SQL Server 工作負載,建議您使用 Azure Stack Hub 上的 SQL Server 虛擬機器。For traditional SQL Server workload on premises, SQL Server virtual machine on Azure Stack Hub is recommended.

SQL 資源提供者配接器架構SQL resource provider adapter architecture

資源提供者是由下列元件所組成:The resource provider consists of the following components:

  • SQL 資源提供者配接器虛擬機器 (VM),這是可執行提供者服務的 Windows Server VM。The SQL resource provider adapter virtual machine (VM), which is a Windows Server VM that runs the provider services.
  • 資源提供者:這會處理要求並存取資料庫資源。The resource provider, which processes requests and accesses database resources.
  • 裝載 SQL Server 的伺服器,可為稱為主控伺服器的資料庫提供容量。Servers that host SQL Server, which provide capacity for databases called hosting servers.

您必須建立至少一個 SQL Server 執行處理,或提供外部 SQL Server 執行個體的存取權。You must create at least one instance of SQL Server or provide access to external SQL Server instances.

注意

建立安裝在 Azure Stack Hub 整合式系統上的主控伺服器時,必須從租用戶訂用帳戶建立。Hosting servers that are installed on Azure Stack Hub integrated systems must be created from a tenant subscription. 無法從預設提供者訂用帳戶建立這些伺服器。They can't be created from the default provider subscription. 必須從使用者入口網站或使用 PowerShell 搭配適當登入來建立這些伺服器。They must be created from the user portal or by using PowerShell with the appropriate sign-in. 所有主控伺服器都是可計費的 VM,而且必須具有授權。All hosting servers are billable VMs and must have licenses. 服務管理員可以是租用戶訂用帳戶的擁有者。The service admin can be the owner of the tenant subscription.

後續步驟Next steps

部署 SQL Server 資源提供者Deploy the SQL Server resource provider