I’m currently running HDP 2.1 (upgraded recently from HDP 2.0). I currently have Derby configured as the Oozie database and would like to change this to MySQL. Unfortunately I cannot make this change using Ambari, as it won’t let me change the database (there are 4 radio buttons, one for each different database, but they are disabled/read-only) via the web user-interface.
The discussion about using /var/lib/ambari-server/resources/scripts/configs.sh to change properties makes sense, and I have tested it out. However I’m not sure which values need to be changed, and what those values should be. For example, if I do a “get” on the “global” config type I can see
“oozie_database”: “New Derby Database”
“oozie_derby_database” : “Derby”
But what should these values be if I want to use MySQL? Note that there is also “oozie_jdbc_driver” too and I assume that will need to be set to the correct mysql jdbc connector.
Related to this, I’m also a bit confused as to whether I should configure oozie by updating its configuration files directly, or if I should use Ambari. For example, this link http://oozie.apache.org/docs/4.0.0/AG_Install.html provides instructions for configuring a database for oozie. I suspect however that I really need to make these changes through ambari, but would like confirmation on this.