使用 Azure Data Studio 笔记本部署 SQL Server 大数据群集Deploy SQL Server big data cluster with Azure Data Studio notebook

适用于:Applies to: 是SQL Server 2019 (15.x)SQL Server 2019 (15.x)yesSQL Server 2019 (15.x)SQL Server 2019 (15.x)适用于:Applies to: 是SQL Server 2019 (15.x)SQL Server 2019 (15.x)yesSQL Server 2019 (15.x)SQL Server 2019 (15.x)

SQL Server 2019 (15.x)SQL Server 2019 (15.x) 为包含部署笔记本的 Azure Data Studio 提供扩展。provides an extension for Azure Data Studio that includes deployment notebooks. 部署笔记本包含可在 Azure Data Studio 中用于创建 SQL Server 大数据群集的文档和代码。A deployment notebook includes documentation and code that you can use in Azure Data Studio to create a SQL Server big data cluster.

笔记本最初是作为开放源代码项目实现的,现已在 Azure Data Studio 中实现。Implemented initially as an open-source project, notebooks have been implemented into Azure Data Studio. 可以在文本单元格中使用 markdown 作为文本,并使用其中一个可用核心在代码单元格中编写代码。You can use markdown for text in the text cells and one of the available kernels to write code in the code cells.

可以使用笔记本为 SQL Server 2019 (15.x)SQL Server 2019 (15.x) 部署大数据群集。You can use notebooks to deploy big data clusters for SQL Server 2019 (15.x)SQL Server 2019 (15.x).

先决条件Prerequisites

若要启动笔记本,还需要满足以下必备条件:Following prerequisites are required to also launch the notebook:

除上述内容外,部署 SQL Server 2019 大数据群集还需要:In addition to above, deploying SQL Server 2019 big data cluster also requires:

启动笔记本Launch the notebook

  1. 启动 Azure Data Studio。Launch Azure Data Studio.

  2. 在“连接”选项卡上,选择省略号 (...),然后选择“部署 SQL Server...” 。On the Connections tab, select the ellipses (...), then select Deploy SQL Server....

    部署 SQL Server

  3. 从部署选项中选择“SQL Server 大数据群集” 。From the deployment options, select SQL Server Big Data Cluster.

  4. 在“选项”下的“部署目标”中,选择“新建 Azure Kubernetes 群集”或“现有 Azure Kubernetes 服务群集” 。From the Deployment Target, under Options, select either New Azure Kubernetes Cluster or Existing Azure Kubernetes Service cluster.

  5. 接受隐私和许可条款Accept the Privacy and license terms

  6. 此对话框还会检查主机上是否存在部署所选类型的 SQL 所需的工具。This dialog also checks whether the required tools for the chosen type of SQL deployment exist on the host. 工具检查成功后才会启用“选择”按钮 。The Select button isn't enabled until the tools check is successful.

  7. 选择“选择”按钮 。Select the Select button. 此操作将启动部署体验。This action launches the deployment experience.

设置部署配置模板Set deployment configuration template

可以按照以下说明自定义部署配置文件的设置。You can customize the settings of the deployment profile by following the instructions below.

目标配置模板Target configuration template

从可用模板中选择目标配置模板。Select the target configuration template from the available templates. 可用的配置文件是根据前一对话框中选择的部署目标类型来筛选的。The available profiles are filtered depending on the type of deployment target that's chosen in the previous dialog.

部署配置模板 步骤 1

Azure 设置Azure settings

如果部署目标是新的 AKS,则需要额外的信息(例如 Azure 订阅 ID、资源组、AKS 群集名称、VM 计数、大小和其他附加信息)来创建 AKS 群集。If the deployment target is a new AKS, additional information such as Azure Subscription ID, resource group, AKS cluster name, VM count, size, and other additional information are required to create the AKS cluster.

Azure 设置

如果部署目标是现有的 Kubernetes 群集,向导则会提示你输入 kube 配置文件的路径以导入 Kubernetes 群集设置 。If the deployment target is an existing Kubernetes cluster, the wizard prompts for the path to the kube config file to import the Kubernetes cluster settings. 请确保选择适当的群集上下文,可在其中部署 SQL Server 2019 大数据群集。Ensure the appropriate cluster context is selected where the SQL Server 2019 Big Data Cluster can be deployed.

目标群集上下文

群集、docker 和 AD 设置Cluster, docker, and AD settings

  1. 输入 SQL Server 2019 BDC 的群集名称、管理员用户名和密码。Enter the cluster name for the SQL Server 2019 BDC, admin username, and password. 注意:用于控制器和 SQL Server 的是同一个帐户。Note: The same account is used for controller and SQL Server.

    群集设置

  2. 输入适当的 Docker 设置Enter the Docker settings as appropriate

    Docker 设置

  3. 如果 AD 身份验证可用,请输入 AD 设置If the AD authentication is available, enter the AD settings

    Active Directory 设置

服务设置Service settings

此屏幕中包含各种设置的输入,例如“缩放”、“终结点”、“存储”和其他的“高级存储设置” 。This screen has inputs for various settings such as Scale, Endpoints, Storage, and other Advanced storage settings. 请输入适当的值,然后选择“下一步” 。Please enter the appropriate values and select Next.

缩放设置Scale settings

输入大数据群集中每个组件的实例数量。Enter the number of instances of each of the components in the big data cluster.

Spark 实例可以随 HDFS 一起提供。A Spark Instance can be included along with HDFS. 它包含在存储池中,或者单独位于 Spark 池中。It's included in the storage pool or on its own in the Spark pool.

服务设置

有关这些组件的其他信息,可以参考主实例数据池存储池计算池For additional information on each of these components, you can refer to master instance, data pool, storage pool, or compute pool.

终结点设置Endpoint settings

已预填充了默认的终结点。The default endpoints have been pre-filled. 但可以对它们进行适当的更改。However, they can be changed as appropriate.

终结点设置

存储设置Storage settings

存储设置包括数据和日志的存储类和声明大小。The storage settings include storage class and claim size for Data and Logs. 这些设置可应用于存储、数据和 SQL Server 主池。The settings can be applied across Storage, Data, and SQL Server master pool.

存储设置

高级存储设置Advanced storage settings

可以在“高级存储设置”下添加其他存储设置 You can add additional storage settings under Advanced storage settings

  • 存储池 (HDFS)Storage pool (HDFS)

  • 数据池Data pool

  • SQL Server MasterSQL Server Master

    高级存储设置

总结Summary

此屏幕中汇总了用于部署 SQL Server 2019 大数据群集所提供的所有输入。This screen summarizes all the input that was provided to deploy SQL Server 2019 Big Data Cluster. 可以通过“保存配置文件”按钮下载配置文件 。The config files can be downloaded via the Save config files button. 选择“将脚本编写到笔记本”来将整个部署配置的脚本编写到笔记本 。Select Script to Notebook to script out the entire deployment configuration to a Notebook. 打开笔记本后,选择“运行单元格”开始将 SQL Server 2019 BDC 部署到所选目标 。Once the Notebook is open, select Run Cells to start deploying the SQL Server 2019 BDC to the selected target.

总结

后续步骤Next steps

有关部署的详细信息,请参阅 SQL Server 大数据群集部署指南For more information about deployment, see deployment guidance for SQL Server big data clusters.