Parallel Module for MySQL?

David Kirlin asks: "I work for a non-profit orginization at Western Illinois University, and we want to implement a database server. We are especially interested in having it run over a parallel system. So far Oracle is the only one we have found that will do that, but I would rather go with a more inexpensive MySQL. I have looked for a parallel processing module for MySQL, but have been unable to find one. Is anyone planning on implmenting this feature, if so how soon would it be done? How difficult would is it to implement MySQL using MPI, PVM, or something similar? "

Try thus clustering toolkit

[Internet Ninja]

I can't say I've used it myself. I was looking at the prometheus library for PHP and found this along the way. Might be a good place to start though.
http://prometheus.zerodivide.net/my sql_cluster/ [zerodivide.net]

A // module ?

[Betcour]

Do you mean a switch that would duplicate all operations to 2 mirrors ?

Well it should be pretty easy to write - after all it is just a proxy that relays order to 2 servers instead of one. Since all orders arrive thru text SQL commands it shouldn't be too difficult. Also it should be easy to implement a simple load balancing for read operations.

Re:A // module ?

[Thomas Charron]

It'd be a bit more complex then that. One could implement it as you suggest, but you'd find that the process of performing the load balancing would eventually saturate a machine, and not take full advantage of your farm. You would also end up with problems keeping your data in sync due to the lack of row locking in MySQL.