The MyCAT project is a toolset for managing MySQL/Linux servers, and could be helpful for anyone managing a network of *nix servers whether running MySQL Cluster, standard replication, or not running MySQL at all. At present, it contains three programs. rcall eases use and administration of groups (clusters) of *nix servers by creating logical groupings and a single location from which to run commands on all servers while entering it only once. It requires only an SSH connection. rep_mon is a replication monitor that notifies if a server is lagging or has encountered any errors. It handles any replication topology easily. binlog_mon monitors disk space used by MySQL binary logs, purging only when disk space is needed. It checks all slaves to ensure that purged files are not still being read by slaves. It has configurable behavior in the event that a slave still needs the oldest file.
|Tags||Systems Administration Networking Monitoring Clustering/Distributed Networks Database|