Like what you see? Have a play with our trial version.

Overview

In our steps for setting up a multiple discrete instance deployment of Yellowfin, each instance of Yellowfin has 4GB of allocated RAM, with ports starting at 8080, then 8090, and so on.  

Before deploying a single instance with these defaults, make sure you have already created a repository database and synced it with the same version of Yellowfin that will be used in the Yellowfin container — for each container. To do this, download the full application installer for Yellowfin, and install it on your workstation. This will create a Yellowfin repo DB as well as an instance of Yellowfin in a folder which can be deleted after configuring the containers.   

For a list of supported database types, see the database information on Install And Deploy Yellowfin 

In the steps below, we’ll show you how to deploy two discrete instances of Yellowfin. 

  1.  Install the full application installer version of Yellowfin on your workstation (this is temporary to ensure the repo DB is available for the containers to use) 

  2. Copy the web.xml file from this installation and save it as a backup to your preferred location (this acts as a reference for the Yellowfin credentials required to connect to your Yellowfin repo DB)

  3. Ensure Docker is running in swarm mode

  4. Copy the following text and paste it into your preferred text editor:

    version: '3' 
    services: 
      yellowfin-multi-instance-prod: 
       ports: 
          - "8080:8080" # Maps Yellowfin running on port 8080 to Docker Swarm port 8080 
       deploy: 
          replicas: 1 
          placement: 
            constraints: [node.role == manager] # (Optional) Places the production instance on a manager node 
       environment: 
          # Required environment variables 
          - JDBC_CLASS_NAME=INSERT_DATABASE_TYPE_1_HERE # Database driver class name 
          - JDBC_CONN_URL=jdbc:INSERT_JDBC_CONNECTION_STRING_1_HERE # Database connection string 
          - JDBC_CONN_USER=INSERT_DATABASE_USER_1_HERE # Username to use when accessing the database 
          - JDBC_CONN_PASS=INSERT_JDBC_PASSWORD_1_HERE # Password for the database user 
          - JDBC_CONN_ENCRYPTED=true # Flag for indicating if the database user's password supplied is encrypted or not. 
          - APP_MEMORY=8192 # The amount of memory in megabytes to assign to the Yellowfin Application. 
       image: "yellowfinbi/yellowfin-app-only:<RELEASE_VERSION_GOES_HERE>" # Path to the app-only image of Yellowfin 
     
      yellowfin-multi-instance-dev: 
       ports: 
          - "8090:8080" # Maps Yellowfin running on port 8080 to Docker Swarm port 8090 
       deploy: 
          replicas: 1 
          placement: 
            constraints: [node.role == worker] # (Optional) Places the dev instance on a worker node 
       environment: 
          # Required environment variables 
          - JDBC_CLASS_NAME=INSERT_DATABASE_TYPE_2_HERE # Database driver class name 
          - JDBC_CONN_URL=jdbc:INSERT_JDBC_CONNECTION_STRING_2_HERE # Database connection string 
          - JDBC_CONN_USER=INSERT_DATABASE_USER_2_HERE # Username to use when accessing the database 
          - JDBC_CONN_PASS=INSERT_JDBC_PASSWORD_2_HERE # Password for the database user 
          - JDBC_CONN_ENCRYPTED=true # Flag for indicating if the database user's password supplied is encrypted or not. 
          - APP_MEMORY=4096 # The amount of memory in megabytes to assign to the Yellowfin Application. 
       image: "yellowfinbi/yellowfin-app-only:<RELEASE_VERSION_GOES_HERE>" # Path to the app-only image of Yellowfin 


  5. Read through the text above and modify or delete the constraints: lines in the text above to suit your setup (this is an optional setting, included above to show how to place the “production” instance of Yellowfin on a Docker Swarm Manager node, and the “development” instance on a Docker Swarm Worker node) 

  6. For each container in the text above, replace the environment variable placeholders with your own configuration details (these are located in the web.xml file of the Yellowfin installation); here’s an example to connect to a PostgreSQL instance:

          # Required environment variables 
          - JDBC_CLASS_NAME=org.postgresql.Driver # Database driver class name 
          - JDBC_CONN_URL=jdbc:postgresql://192.168.1.50/docker_multiple_yellowfin _instances # Database connection string 
          - JDBC_CONN_USER=postgres # Username to use when accessing the database 
          - JDBC_CONN_PASS=bXF0oj5gnB1oRB1kZq5 # Password for the database user 
          - JDBC_CONN_ENCRYPTED=true # Flag for indicating if the database user's password supplied is encrypted or not. 
          - APP_MEMORY=4096 # The amount of memory in megabytes to assign to the Yellowfin Application. 
         image: "yellowfinbi/yellowfin-app-only:9.6.0" # Path to the app-only image of Yellowfin 
  7. Save the text to a YAML file called yellowfin-multiple-instances.yml
  8. Run the following command in a terminal to deploy Yellowfin and execute it in the background:
    docker stack deploy --compose-file yellowfin-multiple-instances.yml yellowfin
  9. Start Yellowfin by typing your host URL on port 8080 (or any other port you’ve set)
  10. Ensure that Yellowfin is running from your container and that you can login (this confirms that your login credentials are correct, so you can safely delete the workstation instance of Yellowfin)
  11. Delete the workstation instance of Yellowfin by removing the folder



Section navigation


This page is part of the Install And Deploy Yellowfin section of the wiki, which has these topics:



  • No labels