Migrate Bold BI and Bold Reports from Window to Oracle Kubernetes Engine

Published:

This section details the process of migrating the Bold BI and Bold Reports from a Windows environment to an Oracle Kubernetes Engine (OKE) environment.

Before migrating Bold BI, create a Kubernetes cluster in Oracle Kubernetes Engine (OKE) where Bold BI will be deployed. Refer to the following documentation for instructions on creating an Oracle Kubernetes Engine (OKE) cluster for Bold BI deployment:

How to Create an Oracle Cluster for Deploying Bold BI

For more detailed instructions on creating a Kubernetes cluster, refer to Oracle’s documentation:

Oracle Kubernetes Engine (OKE) Tutorials
To store the Bold BI and Bold Reports data, create a File System volume. Follow the link below for detailed instructions:
Creating a File System Volume in Oracle
To migrate the app_data to the File System, follow these steps:
- Since Oracle File System mounting is not supported in Windows, you will need to create a Linux VM for file mounting and migrate the app data from a Windows machine to the file system.
- Create a Linux VM and mount the file system on the Linux VM by navigating to the export details and clicking Mount commands. You’ll find the NFS client installation command, mount point command, and mount command.
- After mounting the file system in a Linux VM, copy the app_data files from the Windows machine to the file system mounted directory in the Linux VM.
  
  Source directory: Windows {Deployed Location}/BoldServices
  
  Destination directory: The volume mounted directory in Linux machine
- After copying the files, ensure that the files are available in the file system by checking the file system size.
To install Bold BI and Bold Reports with Configured Filesystem and Nginx Load Balancer follow the below steps:
- Connect to your OKE cluster and install Nginx Load balancer using the following command:
```
kubectl apply -f https://raw.githubusercontent.com/boldbi/boldbi-kubernetes/main/deploy/nginx-deploy.yaml
```
  For more information about the load balancer installation, please refer to this link.
- Domain mapping is mandatory when installing Bold BI using Helm. Obtain the Nginx external IP address by running the following command and map the IP with the domain name you used for Bold BI installed on your Windows machine.
```
kubectl get svc -n ingress-nginx
```
  Note: If you don’t have domain mapping and want to access the application via IP manually, apply the Nginx file after installation.
- Note the File System OCID, Mount Target IP, and Export Path to configure a persistent volume for the Bold BI application.
  
  Creating a File System Mount Target and Export
  
  Note: You need to enable firewall rules and allow ports to access the filesystem from the cluster. Refer to the following documentation to enable access to the cluster from the filesystem: Provisioning PVCs on FSS
- Download the helm common-oke-values.yaml file for OKE deployment by running the following command.
```
curl -o common-oke-values.yaml https://raw.githubusercontent.com/boldbi/boldbi-kubernetes/main/helm/custom-values/common-oke-values.yaml
```
- Craft the common-oke-values.yaml file by following the steps:
  - Update the domain name with protocol in the common-oke-values.yaml file as shown below.
  - Update the volumeHandle value to <FileSystemOCID>:<MountTargetIP>:<path>
  where:
  - <FileSystemOCID> is the OCID of the file system defined in the File Storage service.
  - <MountTargetIP> is the IP address assigned to the mount target.
  - <path> is the mount path to the file system relative to the mount target IP address, starting with a slash. For example: ocid1.filesystem.oc1.iad.aaaa______j2xw:10.0.0.6:/FileSystem1
- Install Bold BI and Bold Reports by following the steps below:
  - Install Bold BI and Bold Reports Helm chart:
```
helm repo add boldbi https://boldbi.github.io/boldbi-kubernetes
helm repo update
```
  - Install Bold BI and Bold Reports:
```
helm install boldbi boldbi/bold-common -f common-oke-values.yaml -n bold-services --create-namespace
```
- If you are configuring the site with HTTPS protocol, please create a secret with SSL cert and keys using the below command.
```
kubectl create secret tls bold-tls -n bold-services --key <key-path> --cert <certificate-path>
```
Use the following command to get the pods status.
```
kubectl get pods -n bold-services
```
Wait until all the pods are running. Then, use the appBaseUrl to access the application in your browser.
Now, the Bold BI application has completely migrated from Windows to the OKE environment.