I have got a warning: Derby is not recommended for production use. With Derby, Oozie server HA and concurrent connection support will not be availibale.

[#1]

I didnt see place Derby was in the list, so what I do for this warning?

[#2 · Accepted solution]

@Robin Dong

By default uses an Ambari-installed Derby instance which is not robust for production hence HA

The recommended DB's are

 - PostgreSQL 8 and above
- MySQL 5.6 
- Oracle 11gr2, 12c

Configuring non-default databases

More doc

[#3]

Use any other database vendor that is supported, you have a wide choice http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.0/bk_HDP_Reference_Guide/content/ch_supported_...

[#4]

Thanks Artern. can you let me know any where I can pick database vendor during the ambari installation.

or I can go ahead to process and change the to other database vendor later?, I guess not 🙂

[#5]

For some products switching default db is easier than others. Please refer to our documentation to configure database and save yourself hours of grief figuring it out on your own.

[#6 · Accepted solution]

@Robin Dong

By default uses an Ambari-installed Derby instance which is not robust for production hence HA

The recommended DB's are

 - PostgreSQL 8 and above
- MySQL 5.6 
- Oracle 11gr2, 12c

Configuring non-default databases

More doc

[#7 · Accepted solution]

reinstall-the-mysql.pdf@Robin Dong

You pick it when you launch the ambari-server setup

see attached doc database vendor please see the reinstall first

[#8]

thank you both. yes at ambari-server setup.