MysqlMonitoringServicesP1

Goal

The goal of the Mysql services monitoring task is to provide a web-based, centralized monitoring service for the collection of LRC's among US ATLAS facilities.

Site level configuration

1. be sure port 3306 open to *.bnl.gov
2. Then

    $ mysql
    mysql> use mysql;
    mysql> INSERT INTO user (Host,User,Password) VALUES ('www.atlasgrid.bnl.gov','monitor',PASSWORD('will be provided'));
    mysql> FLUSH PRIVILEGES;
    mysql> exit;

• Yuri will communicate the password.

Validation

Check plots with URL's supplied by Yuri. You should expect to see .....

• Example plots
  • http://www.atlasgrid.bnl.gov/mysqlstat/mysqlstat.cgi?t=tp-grid2.uchicago.edu&m=query&p=h&skin=
  • http://www.atlasgrid.bnl.gov/mysqlstat/mysqlstat.cgi?t=tier2-01.uchicago.edu&m=query&p=h&skin=
  • http://www.atlasgrid.bnl.gov/mysqlstat/mysqlstat.cgi?t=uct2-grid1.uchicago.edu&m=query&p=h&skin=

-- RobertGardner - 05 Jun 2007