To have multiple Oozie instances we need to have either MYSql/Postgres/Oracle DB instead of the Dubey Database
We need to have HA Proxy /F5 Setup for Load Balancing. For Production I would suggest to get the F5 Load Balancer which should be managed by the Network Team.
Steps to setup Multiple oozie servers followed by HAProxy setup.
Please find the attached Steps to add Multiple Oozie Instances
Inorder to enable the HA feature of oozie we need to use zookeeper quorum and expose the Url of the Proxy server.
Oozie-site.xml
ozie.zookeeper.connection.string provide the Zookeepr quorum in my lab e.g. "hwc3206-node2.hogwarts-labs.com:2181,hwc3206-node3.hogwarts-labs.com:2181,hwc3206-node4.hogwarts-labs.com:2181"
Post installation it will it will create a .cfg file (/etc/haproxy/haproxy.cfg)
Configure the Front_End and Back_end Nodes in the haproxy.cfg
Example of haproxy.cfg from my cluster
(Proxy servers are running on hwc3206-node1.hogwarts-labs.com and oozie Instances are running on hwc3206-node3.hogwarts-labs.com,hwc3206-node4.hogwarts-labs.com)