The fourth validation environment consisted of a multi cluster SEP deployment:
- Two (2) SEP clusters connected using Stargate connector.
- SEP Cluster 1 connected to data source ECS EX500 with Scale Factor 1000 TPC-DS data.
- SEP Cluster 2 connected to Postgres DB with Scale Factor 1000 TPC-DS data.
The following observations were made:
- Single source TPC-DS queries were executed from SEP Cluster 2 against the ECS data source in remote SEP Cluster 1.
- Federated TPC-DS queries were executed from SEP Cluster 2 against data sources in both Cluster 1 and Cluster 2.
- In both the above cases the advantage of Stargate connector is that Cluster 1 would handle the pre-aggregation and filtering and only send the results back to Cluster 2.
- To enable multicloud or multi region analytics, one could potentially set up SEP Cluster 1 on-prem and SEP Cluster 2 on a public cloud or on-premises in another region and connect them using Stargate connector.