Toolserver:Admin:Toolserver database

The toolserver database holds meta-information about the other databases. The master copy of it is located on the sql-toolserver database, and it is updated on all servers nightly using the script /opt/local/bin/refresh-ts-db.

Changing the schema
If you need to change the schema, or add or remove tables, use the following procedure:

willow% dsh -g database 'pfexec env HOME=/root mysql -e "source /home/jsmith/newschema.sql"'
 * Change the schema on sql-toolserver. For new tables, create MyISAM tables.
 * If you added or removed a table, edit /global/misc/puppet/etc/modules/database/files/refresh-ts-db on the HA cluster and change TABLES appropriately.
 * Apply your schema change to all database servers. For example:
 * If you create new tables on servers other than sql-toolserver, create InnoDB tables. (Otherwise, the database update script will not work properly.)

Category:Admin:Database