On Jul 3, 2011, at 7:28 PM, Ross Gardler wrote: > On 3 July 2011 03:32, Suresh Marru <[email protected]> wrote: >> Hi All, >> >> One of our incubation goals [1] is to resolve the the incompatible license >> dependencies. AFAIK, the biggest or only incompatible dependency is the >> mysql-connector-jave which is GPL. Suggestions for alternatives? > > Is this the right question? > > Do you *have* to connect to MySQL or can you replace the dependency on > MySQL with another database?
> This has the added advantage of not requiring a user to jump through > installation hoops in order to make the all important first tests. Airavata is not married to MySQL, and I think considering other databases is certainly a good idea. One of the goal for Airavata in Apache is to broaden the community and having tiny steps of evaluation will greatly help. > If the latter then I would suggest using Apache Derby as the default > database. This enables you to bundle the database with Airavata, but > if someone wants to use MySQL they can simply swap it out in their > deployment. This is the approach we took in Wookie and it's worked > really well. Out of the box Wookie runs with Derby but we provide > instructions (and config scripts) for working with MySQL. The only hesitation I have is some sour experiences with using hsqldb in production. Airavata is used as a kernel in large scale deployments and we have seen usage for instance in the messaging system of processing 1 billion requests (which interact heavily with databases) during high activity times. I am not knowledgable enough of scalability and reliability of other databases. But what you said, is very appealing, having Derby as a startup and providing mysql configuration might be a good trade off. But I am not a database expert to judge these but I would vote on derby merely form a packaging and quick start stand point. I will let others dev's jump in to see if they would like to try Derby. Folks, who is willing to jump and try derby in XRegistry? Message Box? Workflow interpreter? message broker (subscription and messages)? Workflow Monitoring? Information Services? Suresh
