question Re: 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. in Archives of Support Questions (Read Only)

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.

robi — Fri, 16 Sep 2022 10:07:31 GMT

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

Re: 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.

aervits — Mon, 07 Mar 2016 05:19:12 GMT

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_db_matrix_hdp.html

Re: 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.

robi — Mon, 07 Mar 2016 05:23:12 GMT

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 🙂

Re: 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.

Shelton — Mon, 07 Mar 2016 05:29:32 GMT

@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

Re: 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.

aervits — Mon, 07 Mar 2016 05:32:10 GMT

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.

Re: 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.

Shelton — Mon, 07 Mar 2016 05:35:50 GMT

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

Re: 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.

robi — Mon, 07 Mar 2016 05:39:42 GMT

thank you both. yes at ambari-server setup.