Installation and Setup (Docker Compose)
This section describes the steps you must perform to install the Hyperscale Compliance Orchestrator.
Hyperscale Compliance installation
Pre-requisites
Ensure that you meet the following requirements before you install the Hyperscale Compliance Orchestrator.
Download the Hyperscale tar file (
delphix-hyperscale-masking-12.0.0.tar.gz
) from download.delphix.com.You must create a user that has permission to install Docker and Docker Compose.
Install Docker on VM. The minimum supported docker version is 20.10.7.
Install Docker Compose on the VM. The minimum supported docker-compose version is 1.29.2.
Check if docker and docker-compose are installed by running the following command:
docker-compose -v
The above command displays an output similar to the following:docker-compose version 1.29.2, build 5becea4c
docker -v
The above command displays an output similar to the following:Docker version 20.10.7, build 3967b7d
[Only Required for Oracle Load Service] Download and install Linux-based Oracle’s instant client on the machine where the Hyperscale Compliance Orchestrator will be installed. The client should essentially include
instantclient-basic
(Oracle shared libraries) along withinstantclient-tools
containingOracle’s SQL*Loader
client. Both the packages instantclient-basic and instantclient-tools should be unzipped in the same directory. A group ownership id of 50 with a permission mode of 550 or a user id of 65436 with a permission mode of 500 must be set recursively on the directory where Oracle’s instant clientbinaries/libraries
will be installed. This is required by the Hyperscale Compliance Orchestrator to be able to read or execute from the directory.
Oracle Load doesn’t support Object Identifiers(OIDs).
Procedure
Perform the following procedure to install the Hyperscale Compliance Orchestrator.
1. Unpack the Hyperscale tar file.
tar -xzf delphix-hyperscale-masking-12.0.0.tar.gz
2. After unpacking, you should see 7 docker image tar files. The controller-service.tar
, masking-service.tar
, and proxy.tar
are common docker images for both Oracle, MS SQL data source, and Delimited Files masking. The unload-service.tar
and load-service.tar
image files are required for Oracle unload/load services whereas the mssql-unload-service.tar
and mssql-load-service.tar
image files are required for MS SQL data source masking. The delimited-unload-service.tar and delimited-load-service.tar are required for Delimited Files masking. AS such, proceed to load the concerned images into docker:
For Oracle data source masking:
docker load --input unload-service.tar
docker load --input load-service.tar
docker load --input controller-service.tar
docker load --input masking-service.tar
docker load --input proxy.tar
For MS SQL data source masking:
docker load --input mssql-unload-service.tar
docker load --input mssql-load-service.tar
docker load --input controller-service.tar
docker load --input masking-service.tar
docker load --input proxy.tar
For Delimited Files masking:
docker load --input delimited-unload-service.tar
docker load --input delimited-load-service.tar
docker load --input controller-service.tar
docker load --input masking-service.tar
docker load --input proxy.tar
3. Create an NFS shared mount, that will act as a Staging Area, on the Hyperscale Compliance Orchestrator host where the Hyperscale Compliance Orchestrator will perform read/write/execute operations:
Create a ‘Staging Area’ directory. For example:
/mnt/hyperscale/staging_area
. The user(s) within each of the docker containers part of the Hyperscale Compliance Orchestrator and the appliance OS user(s) in the Continuous Compliance Engine(s), all have the user id as 65436 and/or group ownership id as 50. As such, the ‘staging_area’ directory, along with the directory(hyperscale
) one level above, require the following permissions, based on the UID/GID of the OS user, so that the Hyperscale Compliance Orchestrator and the Continuous Compliance Engine(s) can perform read/write/execute operations on the staging area:If the Hyperscale Compliance OS user has a UID of 65436, then the ‘staging_area’ directory, along with the directory(
hyperscale
) one level above, must have a UID of 65436 and 700 permission mode.If the Hyperscale Compliance OS user has a GID of 50 and does not have a UID of 65436, then the ‘staging_area’ directory, along with the directory(
hyperscale
) one level above, must have a GID of 50 and 770 permission mode.
Mount the NFS shared directory on the staging area directory(
/mnt/hyperscale/staging_area
). This NFS shared storage can be created and mounted in two ways as detailed in the NFS Server Installation section. Based on the umask value for the user which is used to mount, the permissions for the staging area directory could get altered after the NFS share has been mounted. In such cases, the permissions(i.e. 770 or 700 whichever applies based on point 3a) must be applied again on the staging area directory.
The directory created in step 3a (‘staging_area’) will be provided as the mountName
and the corresponding shared path from the NFS file server as the mountPath
in the MountFileSystems API.
4. After unpacking the tar, docker-compose-sample.yaml
file should be available. This sample file can be used to create docker-compose.yaml
file. Configure the following docker container volume bindings for the docker containers by editing the docker-compose.yaml
:
For each of the docker containers, except the ‘proxy’ container, add a volume entry binding the staging area path (from 3(a),
/mnt/hyperscale
) to the Hyperscale Compliance Orchestrator container path(/etc/hyperscale
) as a volume binding under the ‘volumes’ section.[Only Required for Oracle Load Service] For the load-service docker container, add a volume entry that binds the path of the directory on the host where both the Oracle instant Client packages were unzipped to the path on the container (
/usr/lib/instantclient
) under the ‘volumes’ section.[Only Required for Delimited Unload Service] For Delimited Files unload-service, the source NFS location has to be mounted to the container as docker volume in order for it to access the source files. The path mounted on the container is passed during the creation of the source connector-info.
CODE# Mount your source NFS location onto your Hyperscale Engine server sudo mount [-t nfs4] <source_nfs_endpoint>:<source_nfs_location> <nfs_mount_on_host>
CODE# Later mount <nfs_mount_on_host> as a docker volume to the delimited unload-service container (in docker-compose.yaml) unload-service: image: delphix-delimited-unload-service-app:${VERSION} ... volumes: ... - <nfs_mount_on_host>:<source_files_mount_passed_during_connector_info_creation>
[Only Required for Delimited load Service] For Delimited Files load-service, the target NFS location has to be mounted to the container as docker volume in order for it to access the target location where masked files will be placed. The path mounted on the container is passed during the creation of the target connector-info.
CODE# Mount your target NFS location onto your Hyperscale Engine server sudo mount [-t nfs4] <target_nfs_endpoint>:<target_nfs_location> <target_nfs_mount_on_host>
CODE# Later mount <nfs_mount_on_host> as a docker volume to the delimited load-service container (in docker-compose.yaml) load-service: image: delphix-delimited-load-service-app:${VERSION} ... volumes: ... - <target_nfs_mount_on_host>:<target_location_passed_during_connector_info_creation>
[Optional] Some data (for example, logs, configuration files, etc.) that is generated inside the docker containers may be useful to debug possible errors or exceptions while running the hyperscale jobs, and as such it may be beneficial to persist these logs outside docker containers. The following data can be persisted outside the docker containers:
The logs generated for each service i.e. unload, controller, masking, and load services.
The sqlldr utility logs and control files at opt/sqlldr location in the load-service container.
The file-upload folder at
/opt/delphix/uploads
in the controller-service container
If you would like to persist the above data on your host, then you have the option to do the same by setting up volume bindings in the respective service as indicated below, that map locations inside the docker containers to locations on the host in the docker-compose.yaml
file. The host locations again must have a group ownership id of 50 with a permission mode of 770 or a user id of 65436 with a permission of 700, due to the same reasons as highlighted in step 3a.
Here are examples of the docker-compose.yaml
file for Oracle, MS SQL data source and Delimited Files masking:
For Oracle data source masking:
version: "3.7"
services:
controller-service:
image: delphix-controller-service-app:${VERSION}
healthcheck:
test: 'curl --fail --silent http://localhost:8080/actuator/health | grep UP || exit 1'
interval: 30s
timeout: 25s
retries: 3
start_period: 30s
depends_on:
- unload-service
- masking-service
- load-service
init: true
networks:
- hyperscale-net
restart: unless-stopped
volumes:
- hyperscale-controller-data:/data
- /home/hyperscale_user/logs/controller_service:/opt/delphix/logs
- /home/hyperscale_user/uploads:/opt/delphix/uploads
environment:
- API_KEY_CREATE=${API_KEY_CREATE:-false}
- EXECUTION_STATUS_POLL_DURATION=${EXECUTION_STATUS_POLL_DURATION:-12000}
- LOGGING_LEVEL_COM_DELPHIX_HYPERSCALE=${LOG_LEVEL_CONTROLLER_SERVICE:-INFO}
- API_VERSION_COMPATIBILITY_STRICT_CHECK=${API_VERSION_COMPATIBILITY_STRICT_CHECK:-false}
- LOAD_SERVICE_REQUIREPOSTLOAD=${LOAD_SERVICE_REQUIRE_POST_LOAD:-true}
- SKIP_UNLOAD_SPLIT_COUNT_VALIDATION=${SKIP_UNLOAD_SPLIT_COUNT_VALIDATION:-false}
- SKIP_LOAD_SPLIT_COUNT_VALIDATION=${SKIP_LOAD_SPLIT_COUNT_VALIDATION:-false}
- CANCEL_STATUS_POLL_DURATION=${CANCEL_STATUS_POLL_DURATION:-60000}
unload-service:
image: delphix-unload-service-app:${VERSION}
init: true
environment:
- LOGGING_LEVEL_COM_DELPHIX_HYPERSCALE=${LOG_LEVEL_UNLOAD_SERVICE:-INFO}
- UNLOAD_FETCH_ROWS=${UNLOAD_FETCH_ROWS:-10000}
networks:
- hyperscale-net
restart: unless-stopped
volumes:
- hyperscale-unload-data:/data
- /mnt/hyperscale:/etc/hyperscale
- /home/hyperscale_user/logs/unload_service:/opt/delphix/logs
masking-service:
image: delphix-masking-service-app:${VERSION}
init: true
networks:
- hyperscale-net
restart: unless-stopped
volumes:
- hyperscale-masking-data:/data
- /mnt/hyperscale:/etc/hyperscale
- /home/hyperscale_user/logs/masking_service:/opt/delphix/logs
environment:
- LOGGING_LEVEL_COM_DELPHIX_HYPERSCALE=${LOG_LEVEL_MASKING_SERVICE:-INFO}
- INTELLIGENT_LOADBALANCE_ENABLED=${INTELLIGENT_LOADBALANCE_ENABLED:-true}
load-service:
image: delphix-load-service-app:${VERSION}
init: true
environment:
- LOGGING_LEVEL_COM_DELPHIX_HYPERSCALE=${LOG_LEVEL_LOAD_SERVICE:-INFO}
- SQLLDR_BLOB_CLOB_CHAR_LENGTH=${SQLLDR_BLOB_CLOB_CHAR_LENGTH:-20000}
networks:
- hyperscale-net
restart: unless-stopped
volumes:
- hyperscale-load-data:/data
- /mnt/hyperscale:/etc/hyperscale
- /opt/oracle/instantclient_21_5:/usr/lib/instantclient
- /home/hyperscale_user/logs/load_service:/opt/delphix/logs
- /home/hyperscale_user/logs/load_service/sqlldr:/opt/sqlldr/
proxy:
image: delphix-hyperscale-masking-proxy:${VERSION}
init: true
networks:
- hyperscale-net
ports:
- "443:443"
restart: unless-stopped
depends_on:
- controller-service
#volumes:
# Uncomment to bind mount /etc/config
#- /nginx/config/path/on/host:/etc/config
networks:
hyperscale-net:
volumes:
hyperscale-load-data:
hyperscale-unload-data:
hyperscale-masking-data:
hyperscale-controller-data:
For MS SQL data source masking:
version: "3.7"
services:
controller-service:
image: delphix-controller-service-app:${VERSION}
healthcheck:
test: 'curl --fail --silent http://localhost:8080/actuator/health | grep UP || exit 1'
interval: 30s
timeout: 25s
retries: 3
start_period: 30s
depends_on:
- unload-service
- masking-service
- load-service
init: true
networks:
- hyperscale-net
restart: unless-stopped
volumes:
- hyperscale-controller-data:/data
- /home/hyperscale_user/logs/controller_service:/opt/delphix/logs
- /home/hyperscale_user/uploads:/opt/delphix/uploads
environment:
- API_KEY_CREATE=${API_KEY_CREATE:-false}
- EXECUTION_STATUS_POLL_DURATION=${EXECUTION_STATUS_POLL_DURATION:-12000}
- LOGGING_LEVEL_COM_DELPHIX_HYPERSCALE=${LOG_LEVEL_CONTROLLER_SERVICE:-INFO}
- API_VERSION_COMPATIBILITY_STRICT_CHECK=${API_VERSION_COMPATIBILITY_STRICT_CHECK:-false}
- LOAD_SERVICE_REQUIREPOSTLOAD=${LOAD_SERVICE_REQUIRE_POST_LOAD:-true}
- SKIP_UNLOAD_SPLIT_COUNT_VALIDATION=${SKIP_UNLOAD_SPLIT_COUNT_VALIDATION:-false}
- SKIP_LOAD_SPLIT_COUNT_VALIDATION=${SKIP_LOAD_SPLIT_COUNT_VALIDATION:-false}
- CANCEL_STATUS_POLL_DURATION=${CANCEL_STATUS_POLL_DURATION:-60000}
unload-service:
image: delphix-mssql-unload-service-app:${VERSION}
init: true
environment:
- LOGGING_LEVEL_COM_DELPHIX_HYPERSCALE=${LOG_LEVEL_UNLOAD_SERVICE:-INFO}
- UNLOAD_FETCH_ROWS=${UNLOAD_FETCH_ROWS:-10000}
- SPARK_DATE_TIMESTAMP_FORMAT=${DATE_TIMESTAMP_FORMAT:-yyyy-MM-dd HH:mm:ss.SSSS}
networks:
- hyperscale-net
restart: unless-stopped
volumes:
- hyperscale-unload-data:/data
- /mnt/hyperscale:/etc/hyperscale
- /home/hyperscale_user/logs/unload_service:/opt/delphix/logs
masking-service:
image: delphix-masking-service-app:${VERSION}
init: true
networks:
- hyperscale-net
restart: unless-stopped
volumes:
- hyperscale-masking-data:/data
- /mnt/hyperscale:/etc/hyperscale
- /home/hyperscale_user/logs/masking_service:/opt/delphix/logs
environment:
- LOGGING_LEVEL_COM_DELPHIX_HYPERSCALE=${LOG_LEVEL_MASKING_SERVICE:-INFO}
- INTELLIGENT_LOADBALANCE_ENABLED=${INTELLIGENT_LOADBALANCE_ENABLED:-true}
load-service:
image: delphix-mssql-load-service-app:${VERSION}
init: true
environment:
- LOGGING_LEVEL_COM_DELPHIX_HYPERSCALE=${LOG_LEVEL_LOAD_SERVICE:-INFO}
- SQLLDR_BLOB_CLOB_CHAR_LENGTH=${SQLLDR_BLOB_CLOB_CHAR_LENGTH:-20000}
- SPARK_DATE_TIMESTAMP_FORMAT=${DATE_TIMESTAMP_FORMAT:-yyyy-MM-dd HH:mm:ss.SSSS}
networks:
- hyperscale-net
restart: unless-stopped
volumes:
- hyperscale-load-data:/data
- /mnt/hyperscale:/etc/hyperscale
- /home/hyperscale_user/logs/load_service:/opt/delphix/logs
proxy:
image: delphix-hyperscale-masking-proxy:${VERSION}
init: true
networks:
- hyperscale-net
ports:
- "443:443"
restart: unless-stopped
depends_on:
- controller-service
#volumes:
# Uncomment to bind mount /etc/config
#- /nginx/config/path/on/host:/etc/config
networks:
hyperscale-net:
volumes:
hyperscale-load-data:
hyperscale-unload-data:
hyperscale-masking-data:
hyperscale-controller-data:
For Delimited Files masking:
version: "3.7"
services:
controller-service:
image: delphix-controller-service-app:${VERSION}
healthcheck:
test: 'curl --fail --silent http://localhost:8080/actuator/health | grep UP || exit 1'
interval: 30s
timeout: 25s
retries: 3
start_period: 30s
depends_on:
- unload-service
- masking-service
- load-service
init: true
networks:
- hyperscale-net
restart: unless-stopped
volumes:
- hyperscale-controller-data:/data
- /home/hyperscale_user/logs/controller_service:/opt/delphix/logs
- /home/hyperscale_user/uploads:/opt/delphix/uploads
environment:
- API_KEY_CREATE=${API_KEY_CREATE:-false}
- EXECUTION_STATUS_POLL_DURATION=${EXECUTION_STATUS_POLL_DURATION:-12000}
- LOGGING_LEVEL_COM_DELPHIX_HYPERSCALE=${LOG_LEVEL_CONTROLLER_SERVICE:-INFO}
- API_VERSION_COMPATIBILITY_STRICT_CHECK=${API_VERSION_COMPATIBILITY_STRICT_CHECK:-false}
- LOAD_SERVICE_REQUIREPOSTLOAD=false
- SKIP_UNLOAD_SPLIT_COUNT_VALIDATION=${SKIP_UNLOAD_SPLIT_COUNT_VALIDATION:-false}
- SKIP_LOAD_SPLIT_COUNT_VALIDATION=${SKIP_LOAD_SPLIT_COUNT_VALIDATION:-false}
- CANCEL_STATUS_POLL_DURATION=${CANCEL_STATUS_POLL_DURATION:-60000}
- SOURCE_KEY_FIELD_NAMES=unique_source_files_identifier
unload-service:
image: delphix-unload-service-app:${VERSION}
init: true
networks:
- hyperscale-net
restart: unless-stopped
volumes:
- hyperscale-unload-data:/data
- /mnt/hyperscale:/etc/hyperscale
- /home/hyperscale_user/logs/unload_service:/opt/delphix/logs
# We can have as many source mounts as required, each volume mount on container can be created as a separate source connector-info
- /home/hyperscale_user/source_nfs_mount:/mnt/source
masking-service:
image: delphix-masking-service-app:${VERSION}
init: true
networks:
- hyperscale-net
restart: unless-stopped
volumes:
- hyperscale-masking-data:/data
- /mnt/hyperscale:/etc/hyperscale
- /home/hyperscale_user/logs/masking_service:/opt/delphix/logs
environment:
- LOGGING_LEVEL_COM_DELPHIX_HYPERSCALE=${LOG_LEVEL_MASKING_SERVICE:-INFO}
- INTELLIGENT_LOADBALANCE_ENABLED=${INTELLIGENT_LOADBALANCE_ENABLED:-true}
load-service:
image: delphix-load-service-app:${VERSION}
init: true
networks:
- hyperscale-net
restart: unless-stopped
volumes:
- hyperscale-load-data:/data
- /mnt/hyperscale:/etc/hyperscale
- /home/hyperscale_user/logs/load_service:/opt/delphix/logs
# We can have as many target mounts as required, each volume mount on container can be created as a separate target connector-info
- /home/hyperscale_user/target_nfs_mount:/mnt/target
proxy:
image: delphix-hyperscale-masking-proxy:${VERSION}
init: true
networks:
- hyperscale-net
ports:
- "443:443"
restart: unless-stopped
depends_on:
- controller-service
#volumes:
# Uncomment to bind mount /etc/config
#- /nginx/config/path/on/host:/etc/config
networks:
hyperscale-net:
volumes:
hyperscale-load-data:
hyperscale-unload-data:
hyperscale-masking-data:
hyperscale-controller-data:
5. (OPTIONAL) To modify the default Hyperscale configuration properties for the application, see Configuration Settings.
6. Run the application from the same location where you extracted the docker-compose.yaml
file.
docker-compose up -d
Run the following command to check if the application is running. The output of this command should shows five containers up and running.
docker-compose ps
Run the following command to access application logs of a given container.
docker logs -f service_container_name>
Service container name can be accessed by output of the command docker-compose ps
.
Run the following command to stop the application (if required).
sudo docker-compose down
7. Once the application starts, an API key will be generated that will be required to authenticate with the Hyperscale Compliance Orchestrator. This key will be found in the docker container logs of the controller service. You can either look for the key from the controller service logs location that was set as a volume binding in the docker-compose.yaml
file or you could use the following 'docker' command to retrieve the logs.
docker logs -f <service_container_name>
Service container name can be accessed by output of the command docker-compose ps
.
The above command displays an output similar to the following where the string NEWLY GENERATED API KEY
can be grepped from the log::
2022-05-18 12:24:10.981 INFO 7 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext
2022-05-18 12:24:10.982 INFO 7 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 9699 ms
NEWLY GENERATED API KEY: 1.89lPH1dHSJQwHuQvzawD99sf4SpBPXJADUmJS8v00VCF4V7rjtRFAftGWygFfsqM
To authenticate with the Hyperscale Compliance Orchestrator, you must use the API key and include the HTTP Authorization request header with the type apk; apk <API Key>
.
For more information, see the Authentication section under Accessing the Hyperscale Compliance API.
Continuous Compliance Engine Installation
Delphix Continuous Compliance Engine is a multi-user, browser-based web application that provides complete, secure, and scalable software for your sensitive data discovery, masking, and tokenization needs while meeting enterprise-class infrastructure requirements. For information about installing the Continuous Compliance Engine, see Continuous Compliance Engine Installation documentation.