This solution highlights the power of implementing SQL Server 2019 Big Data Cluster technology hosted on Dell EMC VxRail hyperconverged infrastructure (HCI). In the solution use case, we integrate SQL Server 2019 RDBMS, SQL Server Big Data Cluster, MongoDB, and Oracle RDBMS to create a unified data analytics platform. SQL Server 2019 scale-out storage and compute clusters, and new data virtualization techniques are the enabling technologies. This SQL Server 2019 Big Data Cluster solution also benefits from the simplicity of a complete, yet flexible, validated Dell EMC VxRail HCI platform with Kubernetes management and storage integration.
The solution demonstrates the combined value of the following technologies:
With this paper, we include physical and virtual topology diagrams and general connectivity guidelines for the solution. We also provide additional design guidance that focuses on scaling, flexibility, and high availability.
Focusing on the recommended best practices to help make your implementations successful, this white paper describes how to design and build a SQL Server Big Data Cluster solution. In addition, we explore the intersection of SQL Server Big Data Cluster and PolyBase, which supports big data workloads that connect to a larger data sphere. Our solution demonstrates a reliable and repeatable method to deploy the required analytic application services by using automation and orchestration provided by VMware vSphere, Docker, and Kubernetes.