Embedded MPP Promotions¶

Each Denodo environment should have its own embedded MPP cluster configured, so for each environment you have a Denodo cluster and an MPP cluster that can communicate to each other. From a security perspective this ensures each environment is isolated and from a performance perspective this ensures each environment has an MPP cluster that is configured and scaled according to the expected workload of each scenario.

The MPP cluster can be deployed using the Presto cluster on Kubernetes tool that is available at the Denodo Support Site. This deployment process includes a final step that creates a new special data source in Denodo called “embedded_mpp”. This step is described in detail in Section Register Presto as Denodo’s MPP. You should use this option to create this necessary metadata on each environment, instead of promoting the embedded MPP data source using the Solution Manager.

Once you have the embedded MPP configured on each environment you can promote any changes normally using the Solution Manager. For example, if you configure bulk load on your embedded MPP data source and configure the credentials to access the object storage of your choice you can include the data source in a revision to update the data source on the target environment. The same happens if you create a new base view over one of the routes defined on your embedded MPP data source. You can promote your base view normally, just remember to include the data source in case it has been created over a route that does not exist yet on the target environment or over a route that has been modified.