[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...)