在 Azure Stack Hub 中使用 SQL 数据库Use SQL databases on Azure Stack Hub

Azure Stack Hub 上使用 SQL 资源提供程序来提供 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 数据库服务器和主机。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 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 服务器的服务器,为称作宿主服务器的数据库提供容量。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 服务器资源提供程序Deploy the SQL Server resource provider