Home > Workload Solutions > SQL Server > White Papers > Running SQL Server 2022 with Red Hat OpenShift on AMD EPYC based Dell PowerEdge servers and Dell ObjectScale > Solution architecture
Validating a solution architecture for running Microsoft SQL Server 2022 on the Red Hat® OpenShift® Container Platform, Red Hat® OpenShift® Data Foundation, and Dell ObjectScale object storage is a critical step to ensure a robust and scalable deployment.
Figure 1 provides an overview of the physical architecture that was used in this validation.
The physical components in this validation include:
The Dell PowerEdge R7625 servers contain two AMD EPYC 9334 processors with each processor containing 32 physical cores. This dual-socket server model was configured as worker nodes. There were seven worker nodes total in this validation. These worker nodes have enough CPU power to handle the compute resources needed for SQL analytic workloads and provide capacity for both persistent block storage and object storage.
For the OpenShift® control plane nodes, we used three Dell PowerEdge R7615 servers. This single socket server model contains one AMD EPYC 9124 processor with 16 physical cores.
The Dell PowerSwitch S5248F-ON delivers 25 GbE open networking that provides state-of-the-art, high-density switching. These switches provide flexibility for changing network configurations and adapt to the containerized compute cluster.
Figures 2 and 3 show the details of the PowerEdge R7625 and R7615 server models.
The following list includes the main components in the logical architecture:
Red Hat OpenShift is the key pillar to this solution because one of the focus areas during development was to create a cloud-native data analytics solution that could be location agnostic and provide a consistent user experience across public cloud, on-premises, hybrid cloud, or edge infrastructure.
We used ODF as a hyperconverged cloud native Block Storage provider for our overall solution. Each SQL Server instance deployed on OpenShift requires a reliable and performant block storage to store its data, logs, and TempDB files.
ObjectScale gives organizations the power to put data closer to the applications they support, reducing latency and improving the user experience. Additionally, object storage from disparate platforms can cross-replicate for greater access, reliability, and redundancy. ObjectScale is an enterprise-grade object storage with these features and functionality:
Delta Lake is open-source software that extends Parquet data files with a file-based transaction log for ACID transactions and scalable metadata handling. Delta Lake is fully compatible with Apache Spark APIs, and was developed for tight integration with Structured Streaming, allowing you to easily use a single copy of data for both batch and streaming operations and providing incremental processing at scale.
The following list describes the key features of Delta Lake:
For more information on the Delta Lake are available on the Delta Lake webpage and the following Delta Lake whitepaper.