Deploying Cluster unaware application on a windows cluster

Hi everyone

Has anyone deployed a cluster unaware application like MySQL on a server 2003 cluster before? I am trying to configure MySQL over two cluster nodes so that the application can failover when one is down. I have come across some article that says we need to install the application on both nodes and create a generic service to start up the service during the failover. Can someone advise me on how to go about doing the configuration?

Thanks.

Regards