MySQL servers optimization

[Before optimization – current state]

  1. orion.star.bnl.gov (3306, 3346), Apache, Drupal, SKM

  2. duvall.star.bnl.gov (3336, 3306), FC slave, operations (many databases)

  3. brando.star.bnl.gov (3336), FC slave

  4. heston.star.bnl.gov (3306), Nova, logger, gridsphere + some outdated/not used dbs

  5. connery.star.bnl.gov – Tomcat server

  6. alpha.star.bnl.gov – test node (zrm backup, Monitoring, mysql 5.0.77)

  7. omega.star.bnl.gov (3316) – Offline backup (mysql 5.0.77)

  8. omega.star.bnl.gov (3336) – FC backup (mysql 5.0.77)

Most servers have bin.tgz MySQL 5.0.45a

 

[After optimization]

    new orion, duvall, brando = beefy nodes

  1. orion : Apache server, JBoss server (replaces Tomcat), FC slave db, drupal db, SKM db, Nova;

  2. duvall: FC slave, copy of web server, drupal db slave, operations db, logger, gridsphere, jboss copy;

  3. brando: FC slave, copy of web server, drupal db slave, operations db slave, jboss copy

  4. alpha : test node (mysql upgrade, infobright engine, zrm backup(?));

  5. omega : Offline backup slave, FC backup slave, operations db backup slave;

 

All servers will have MySQL 5.0.77 rpm – with possible upgrade to 5.1.35 later this year.

 

[free nodes after replacement/optimization]

  1. connery

  2. orion

  3. duvall

  4. brando

  5. dbslave03

  6. dbslave04

  7. + several nodes from db0x pool (db04, db05, db06, db11, bogart, etc...)