I am currently using the embedded derby database with oozie. We are running into database locking issues, and are looking to migrate off of derby to mysql. I am having issues finding a guide that explains how to migrate, and not lose any data. I am using ambari 1.6 with HDP 2.1.
I would follow our guide to move to MySQL and follow this guide for moving data from derby.