Replica Console - description

The basic idea is to allow execution of SQL queries and command-line commands on all the server from the same console. Also, we want to allow execution of the same query or command on multiple server, and display the information in a way that makes it simple to compare results. A screenshot is available.

The most-often-used queries ("show databases", "show master/slave status", ...) and commands ("vmstat", ...) will be pre-made and available at a click of a button.

The program is written and requires Java. To be able to execute remote commands on Windows you will need Plink. You also need to setup public/private authentication: you are not allowed to use password authentication.

Features already implemented:

Server List management: you can add and remove servers and save the list to an XML file
Automatic slave detection by looking at the process list
During a "show master/slave status" the logs are automatically compared to see if a slave is out of synch
Remote command execution through ssh (at a basic level)

Standard SQL query provided:

List of databases displayed as nodes of a tree
List of variables of the server. If the server is a slave and the master is connected, the master's variables are displayed also.
For each database, the tables are display with their row count. If database is a slave and the master is connected, the row count of the master is displayed also.
Process list can be displayed for each server
"show master/slave status" automatically compared with the relative master or slave(s)

This product uses and contains the MySQL JDBC driver written by Mark Matthews. More information about it, including the source code, can be found on his web-site.

Gabriele Carcassi - last modified