This design for Oracle Big Data SQL with PowerFlex encompasses the following phases:
- Phase I: PowerFlex deployment and configuration—Typically, PowerFlex deployment is carried out at the factory or by authorized service engineers. The deployment can be customized as defined in this guide. Once the PowerFlex infrastructure is received, it is racked and stacked, either by the customer or by Dell Technologies service engineers. All the hardware components, including PowerFlex R840 hyperconverged (HCI) and PowerEdge R640 compute nodes and network switches, are set up and cables are connected. Successful completion of Phase I results in a functional PowerFlex system with access to:
- The customer vCenter (designed for end-users), which can be used to access the HCI and CO nodes to create virtual machines (VMs), datastores, templates, and so on.
- The presentation server, which can be used to access the storage functionality of PowerFlex. Use this server to create, delete, and map volumes, for example.
- Phase II: Installation and configuration—Establish the environment for running Oracle Big Data SQL on top of the infrastructure stack that was set up in Phase I. Phase ll tasks include:
- Creating and setting up PowerFlex storage volumes
- Creating VMs for all the data sources (Oracle, Oracle NoSQL, Microsoft SQL Server, and Hadoop)
- Setting up storage and networks for the VMs
- Phase III: Oracle Big Data SQL installation and configuration—Deploy the Oracle Big Data SQL on the infrastructure that was set up in Phase II. Tasks to accomplish in this phase include:
- Preparing to install Oracle Big Data SQL
- Creating and configuring the different data sources in each environment:
Installing Oracle 19c Grid infrastructure for the stand-alone server (Oracle Restart)
Installing the Hadoop cluster
Installing Oracle NoSQL
Installing Microsoft SQL Server 2019
- Configuring Oracle Big Data SQL for Oracle, Hadoop, and Oracle NoSQL, and configuring Oracle gateways for Microsoft SQL Server