Hello All, I've been using the MYSQL database for our remote execution service (RES) and productivity has significastly increased. Most of the annoying databases update errors I was obtaining using derby have disappeared.
One thing I've noticed was a seemingly high rate of access to the sql database by the RES. For example, the sql log would grow to 13 GB in size in just 1-2 days. We needed to turn off the logging to prevent filling up the filesystem where logs are stored. Most of the sql commands captured looked to be simply polling for state. The rate seems to be ~1 per sec. (a very crude measurement). I've been trying to identify a parameter to adjust the update rate but was unable to find it. I also cannot determine if it is the RES of the Taverna workbench itself that is requesting the update. If such a parameter exists, can someone please point me to it? --jeff Stian Soiland-Reyes wrote: > On Tue, Mar 3, 2009 at 13:59, Jeffrey L. Tilson <[email protected]> wrote: > >> Hello All, >> I am currently using v0.5.0+ of the REE. Generally it works well. I want >> to replace the derby embedded database with something abit more >> production oriented like mysql. Can someone point me to any >> documentation or tips on how to do that? >> > > The remote execution service is using the official Java Persistance > API (JPA) and Hibernate. > > You can change the configuration of this in the file > ./WEB-INF/classes/META-INF/persistence.xml inside your unzipped .war > file. > > > These are the properties you would need to change: > > <property name="hibernate.connection.driver_class" > value="org.apache.derby.jdbc.EmbeddedDriver" /> > <property name="hibernate.connection.url" > value="jdbc:derby:/tmp/remoteTavernaDB;create=true" > /> > <property name="hibernate.dialect" > value="org.hibernate.dialect.DerbyDialect" /> > > > You would need to download the mysql driver JAR (which due to GPL we > can't distribute together with the remote execution service) and place > it in WEB-INF/lib - see http://dev.mysql.com/downloads/connector/j/ - > I'm uncertain if you should use a 5.x version or 3.x version - again I > guess it depends on what version of the mySQL database you're > connecting to. > > As the driver_class, try com.mysql.jdbc.Driver > > For the connection URL, try something like: > > jdbc:mysql://localhost/myDatabase?user=monty&password=greatsqldb"); > > > For the dialect I believe org.hibernate.dialect.MySQLDialect should > work, otherwise try any of the other MySQL ones at > http://www.hibernate.org/hib_docs/v3/api/org/hibernate/dialect/package-summary.html > > > If you are changing these directly in remotetaverna/WEB-INF unzipped > by Tomcat, you just need to restart Taverna. Otherwise, zip together > again the .war to include your changed settings and redeploy to your > Tomcat. > > -- ****************************************** Jeffrey L. Tilson, Ph.D. Senior Research Scientist Renaissance Computing Institute (RENCI) Campus Box 3455 University of North Carolina Chapel Hill, NC 27599-3455 919.445.9657 (o) 919.962.1380 (f) ***************************************** ------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ taverna-hackers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/taverna-hackers Developers Guide: http://www.mygrid.org.uk/usermanual1.7/dev_guide.html FAQ: http://www.mygrid.org.uk/wiki/Mygrid/TavernaFaq
