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.

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 codett>/global/misc/puppet/etc/modules/database/files/refresh-ts-db on the HA cluster and change  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