I really need to what Shlomo describes as well. I want to run select queries on a MERGE table, which should pass the queries onto underlying FEDERATED tables, which then should pass the queries on to underlying MyISAM tables on other servers. I had a look in the code of Merge and it did not seem to be any real reason why Merge shouldn't work on a FEDERATED table referecing a MyISAM table. Do you agree? I understand that some changes might have to be implemented to pass on the error messages from the refereced FEDERATED tables, but that should be too difficult.
Parallelizing the execution of the queries the MERGE table sends to underlying tables does, however, at least sound like something more complicated to implement.
I really need these two adaptations, so I am willing to put some money 1000$ on the table if someone can implement this. Can anyone else join me with another 1000$ for completing this project, so we can see faster progress? I suggest using the escrow service of Guru.com to ensure all parties that they will get the code/money they are promised.
I can give access to three servers to test the performance of your solution (there should be a significant performance boost).
You are welcome to contact me on
david@andersen.gs.
Regards,
David