COM+ and distributed mysql on Windows2003 server

[Reggie Burnett]

This is not possible currently.  What type of functionality would you want
to see in the remote servers?  All of mysql, just the query parsing?

As for what would need to be done, the functionality desired would have to
be packaged into a component ready to be deployed across a server farm.  If
you are not distributing all MySQL functionality, then you would need to
provide some type of connection between the distributed parts and the rest.
As an example, if you only distributed query processing then you would need
to provide some interconnect back to the optimizer and data retrieval
modules.

The simplest approach would be to package all of MySQL up into a component,
with each instance taking part in replication.  If this is the desire, you
should be aware that we are working on other forms of load balancing that do
not involve COM+ but provide the same type of functionality.

-Reggie

> hi,
 
> what i am interested in is allowing mysql threads (for each connection) to
be load
> balanced across a Win2003 cluster using Application Center...
 
> 1. is this possible now?
> 2. if not, any ideas on what needs to be done to make it so and how can i
contribute to
> make it happen?
 
> cheers and thanks for your time
> nik