Tool for querying multiple databases

Polyglot Projects Other Tools
1

Hi,

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?

Thanks,
Luciano

2

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

3

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

4

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

Thanks,

Tim

5

You can try dbForge Query Builder for MySQL - [url]http://www.devart.com/dbforge/mysql/querybuilder/[/url]