Re: MySQL component

Steve Loughran wrote:
>>Phillip Thurmond wrote:
>> Hello all.  I'm currently implementing a performance testing system in 
>> smartfrog.  i was wondering if anyone has written or knew of a smartfrog 
>> component to install and manage MySQL.  I've seen one mentioned in a 
>> couple of presentations, but couldn't find the code anywhere.  All of my 
>> code will be licensed LGPL, so any added features (or bugs :) ) to an 
>> existing component will be shared.  Thanks.
>> 
>> --Phillip
 [snip]

> One of the fun things here is shutting down mysql cleanly. Our normal 
> execution routines shut things down by issuing a destroy() command to 
> the process, there being no portable way to issue kill signals to a 
> process in Java. I worry what state this will leave the database in. 
> I've added a component, mysqladmin-shutdown to issue a shutdown command, 
> which can go into a new workflow component, Finally {}, that will run 
> the program when it terminates

Hi Steve,

First, I'm replying to this on -developer, because the -user mailing list
seems to have disappeared.

>From the dates on the SVN repo, I see that you're still actively working on
this component (and I'm actually looking at using SmartFrog internally at
MySQL AB for some of our system testing).

I'm wondering if you've happened to look at Connector/MXJ which wraps up a
mysqld and gives you configuration and lifecycle methods either as a POJO or
an MBean? It might make your component quite a bit more straightforward:

http://dev.mysql.com/downloads/connector/mxj/1.1.html

Let me know what you think, and I can hook you up with the developer who
maintains it.

Best Regards,

	-Mark


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV