首页 > 代码库 > DW(四):polybase集群安装配置
DW(四):polybase集群安装配置
目录:
- Prerequisites
- 集群配置规划
- 创建域控服务器
- polybase install
- firewall config
- 集群配置
- 删除计算节点
install Prerequisites
- Microsoft .NET Framework 4.5
- Oracle Java SE RunTime Environment (JRE) version 7.51 or higher (64-bit) (Either JRE or Server JRE will work)
- Minimum memory: 4GB
- Minimum hard disk space: 2GB
- TCP/IP connectivity must be enabled
- SQL Server (starting with 2016)
- JRE下载地址: http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
- sqlserver2016: https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016?i=1
- ssms2016(SQL Server Management Studio): https://msdn.microsoft.com/en-us/library/mt238290.aspx
集群配置规划:
- 3台Azure A3 虚拟机(polybase0、polybase1、polybase2),虚拟机在同一虚拟子网
- polybase0:域控服务器
- polybase1、polybase2 同一域内二台测试机
- 域帐户: jn\zhushy
- 说明: 在polybase1、polybase2安装sqlserver2016 with polybase
创建域控服务器
- polybase 集群要求所有节点的 PolyBase engine 和 polybase DMS 访问使用相同的 domain account
- 打开server manager Dashboard --> Add Roles and Features
- Server Roles 项,配置如下:
- 按向导默认安装完毕后,配置域控服务器
- 设置信息如下:
- 安装配置成功后,系统会重启,自动会加入到域,如图:
- 域控服务器不能安装polybase
让其他计算机加入该域
- 登陆要加入该域的计算机,先更改IP地址,把首选DNS设置成域控服务器的IP地址
- 然后打开计算机属性,选择更改设置,选择加入域控jn.com,如下图:
- 点击确定,然后输入此台计算机的管理员账户和密码, 后重启计算机后生效
polybase install
- 启动安装向导,在如下的界面选择"New Standalone SQL Server installation or add features",如图:
- 在执行“ feature selection page” 时,选择“PolyBase Query Service for External Data”
- PolyBase Configuration Page 项,配置如下:
- Server Configuration Page 项,configure the SQL Server PolyBase Engine Service and SQL Server PolyBase Data Movement Service to run under the same account
- 安装完成后,如下
- 在上面链接下载的sqlserver2016未集成ssms,需单独安装,通过下面的sql判断是否安装正常
SELECT SERVERPROPERTY (‘IsPolybaseInstalled‘) AS IsPolybaseInstalled
返回“1”则表示安装成功,如下
firewall config
- SQL Server PolyBase setup creates the following firewall rules on the machine
- SQL Server PolyBase – Database Engine - <SQLServerInstanceName> (TCP-In)
- SQL Server PolyBase – PolyBase Services - <SQLServerInstanceName> (TCP-In)
- SQL Server PolyBase - SQL Browser - (UDP-In)
- To enable the firewall rules
- Open the Control Panel
- Click System and Security, and click Windows Firewall
- click Advanced Settings, and click Inbound rules
- Right-click the disabled rule, then click Enable rule
- 如下图:
集群配置
- 选择polybase1作为headnode
- Connect to SQL Server on polybase2. Run the stored procedure sp_polybase_join_group.
-- Enter head node details: -- head node machine name, head node dms control channel port, head node sql server name EXEC sp_polybase_join_group ‘polybase1‘, 16450, ‘MSSQLSERVER‘;
Shutdown the PolyBase engine and restart the PolyBase data movement service
- 连接到sqlserver on polybase1, 查看集群节点状况,如下: select * from sys.dm_exec_compute_nodes
删除计算节点:
- Connect to the compute node SQL Server (polybase2).
- Run the stored procedure sp_polybase_leave_group.
EXEC sp_polybase_leave_group;
- on polybase2 : Start PolyBase Engine. Restart PolyBase data movement service.
- Now polybase2 will function as a standalone head node
DW(四):polybase集群安装配置
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。