Announcement

Announcement Module
Collapse
No announcement yet.

Tool for querying multiple databases

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Tool for querying multiple databases

    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.

    Comment


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

      Comment


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

        Thanks,

        Tim
        Last edited by scott.nemes; 03-22-2014, 03:04 PM. Reason: Ad

        Comment


        • #5
          You can try dbForge Query Builder for MySQL - http://www.devart.com/dbforge/mysql/querybuilder/

          Comment

          Working...
          X