Running the script

When you run the script, note that there are a couple of phases through which you can accomplish your task.

Firstly you backup your Profiler database and next you can restore the Profiler database.

To backup the Profiler database:

  1. Stop the Profiler Manager and Profiler Scheduler services from the Cloudera Manager instance of the DataHub cluster.
  2. SSH to the node where Profiler Manager is installed as a root user.
  3. Execute the profiler_backup_db.sh script:
    bash /opt/cloudera/parcels/PROFILER_MANAGER/profileradmin/scripts/users/backup_db.sh
    
  4. Delete the Profiler cluster.
  5. Install a new version of Profiler cluster:
    • [Scenario-1] When the Data Lake upgrade is successfully completed.
    • [Scenario-2] When the user decides to launch a new version of the Profiler cluster.
To restore the Profiler database:
  1. Stop the Profiler Manager and Profiler Scheduler services from the Cloudera Manager instance of the DataHub cluster.
  2. SSH to the node where Profiler Manager is installed as a root user.
  3. Execute the profiler_restore_db.sh script:
    bash /opt/cloudera/parcels/PROFILER_MANAGER/profileradmin/scripts/users/restore_db.sh
    
  4. Start the Profiler Manager and Profiler Scheduler services from Cloudera Manager.
  • Schedule
  • Last Run Check
  • Number of Executors
  • Executor Cores
  • Executor Memory (in GB)
  • Driver Core
  • Driver Memory (in GB)