Tool for querying multiple databases


Does Percona Toolkit have a tool to throw a statement to multiple databases? I looked at the doc but I couldn’t find it (maybe I missed it). I have +30 databases and I have a simple php program to do that but I’m looking for a more robust tool (if it does the queries in parallel will be great).

In case Percona Toolkit doesn’t have one, do you know any tool to recommend?


PT can’t do this. I recommend xargs with the -p option.

ok, I will give it a try. Thanks for your answer!

Do i need the latest version of the .net framework for this?



You can try dbForge Query Builder for MySQL -