Run multiple scripts on multiple servers with a single click using SQL Multi Select

• set up your scripts and servers once, and run multiple times • deploy maintenance scripts across multiple servers fast • set up multiple server lists for different tasks • retrieve data from multiple servers in a single dataset • supports MySQL, Oracle, PostgreSQL, and Firebird

SQL Multi Select lets you run scripts against multiple MySQL databases, and consolidates the results for easy viewing and analysis. To use SQL Multi Select, you first set up query groups comprising your MySQL databases. For example, you could create a group comprising your web-facing MySQL servers: and you could create another group comprising your internal development MySQL servers: Select the query group, add the scripts you want to run to your project: and SQL Multi Select will run your scripts against the MySQL servers in your query group, and consolidate the results. Imagine how this can help you in your daily management of your servers. Need to create a new user account on a set of servers? Just select the appropriate query group, write the script, and run the project. Need to create a new database on a bunch of servers? Prepare the CREATE DATABASE script, select a query group, run the script, and you’re done. It becomes so easy to check things like the version of MySQL that is running, how many active connections are on each server, the uptime of each server, the largest tables in each database, across all your servers, in consolidated result sets, with just a single click. The possibilities are endless. There's even more you can do with SQL Multi Select. You can export your consolidated result sets to text files, or into a SQLite database, for distribution to other users. Why SQLite? That’s because we provide the FREE SQL Multi Select Viewer to view your exported results in a much more useful manner. Thus, if you need to share your result sets, instead of your users seeing this: they see this using SQL Multi Select Viewer: The SQL Multi Select Viewer has the same display features as our other product, SQL Image Viewer, so it can identify a wide variety of image and binary file formats. Learn more about SQL Multi Select Viewer here. You can also use the command-line interface to run your SQL Multi Select projects periodically. So you could run a set of health-check scripts on your MySQL servers daily, allowing you to track and analyse your servers' health over time.