Thanks a lot for the prompt reply Robert! I do have lot of data in my derby db which I need to migrate now to either of mysql/oracle/postgres. Is there any known data migration tool which can migrate data from derby to let's say mysql?
I also have one more question. Since traditionally oozie database is local, a node outage can make the database unavailable. Can we have the oozie database on an nfs mount, so that in case of oozie server process outage, the secondary process which will run on another node, can access the database using nfs mount as well? Thanks, Anand On Tue, Feb 18, 2014 at 11:36 PM, Robert Kanter <[email protected]>wrote: > Hi, > > You can run Oozie without an HA database. A non-HA MySQL, Oracle, or > Postgres database will work just fine, other than if the database goes > down, your Oozie becomes unavailable (i.e. the database is a single point > of failure). > > The reason you can't use Derby for Oozie HA is because it doesn't support > multiple concurrent connections. In Oozie HA, each Oozie server connects > to the database, so there are multiple connections; Derby doesn't allow > that so only one of the Oozie servers would be able to connect. > > - Robert > > > On Tue, Feb 18, 2014 at 1:16 AM, Anand Vidwansa <[email protected]> > wrote: > > > Hi, > > > > I wanted to know if there is a way to configure oozie HA support with > derby > > as database. > > I understand oozie HA support expects an HA database. > > But, is there a way to use native replication in derby to replicate data > > between > > two hosts and switch to secondary store in case oozie fails over? > > > > Any help is appreciated! > > > > Thanks, > > Anand > > >
