oozie / MySQl - Qiestion

[#1]

I am trying to use MySql instead of derby to be used for oozie. I installed MySql on oozie server host and also created a database. Now on Ambari during installation it says below. Ambari-server is already setup and I am trying to add services on multiple nodes now. Do I have to install MySql on Ambari-server also. This is not clear to me.

Also if I use derby to start with, can I changed it to MySql later ?

Be sure you have run:
ambari-server setup --jdbc-db=mysql --jdbc-driver=/path/to/mysql/mysql-connector-java.jar on the Ambari Server host to make the JDBC driver available and to enable testing the database connection.

[#2 · Accepted solution]

You do not have to change the Ambari database. But Ambari needs the jdbc drivers for mysql available to check on oozie and do the initial setups.

"Also if I use derby to start with, can I changed it to MySql later ?"

Yes you can switch later but you will lose all the data inside unless you do a migration. So just do it with mysql from the start.