sysadmin
@
extreme.indiana.edu


Home
Machines
CSG
    Support
    Packages
Lab
    User's Guide
    Sysadmin's Guide
    Packages
Projects
    Portal
    LEAD
    Grid Info

MySQL Sysadmin's Guide

Installed Versions

3.23.58 (Solaris)

3.23.49 (Solaris)

4.0.16 (Linux)

3.23.58

3.23.58 was installed locally on rainier in /usr/local/mysql-3.23.58-sun-solaris2.8-sparc/, with a symlink /usr/local/mysql pointing to it. The data files are still on xraid in /l/local/packages/MySQL/3.23.49/data/.

Backups

User emysql has a cron job on rainier that executes nightly that uses mysqldump to create a full backup of all the databases. This is stored as ~emysql/backups/rainier/backup_all.sql. logrotate is then used to keep 7 days worth of these, compressed.

3.23.49

Download (Solaris binary)

http://mirror.sit.wisc.edu/mysql/Downloads/MySQL-3.23/mysql-3.23.49-sun-solaris2.8-sparc.tar.gz

Logs

solaris install - 3-1-2002

Configuration

% Set root password
/l/local/packages/MySQL/3.23.49/bin/mysqladmin -u root password '<super secret password>'
/l/local/packages/MySQL/3.23.49/bin/mysqladmin -u root -h rainier.extreme.indiana.edu password '<super secret password>'


/l/local/packages/MySQL/3.23.49/bin/mysql -u root -h rainier.extreme.indiana.edu -p
% Creating Databases
mysql> create database IUExtremeMDB;
mysql> create database WRFMDB;
mysql> create database componentBrowser;
mysql> create database eventdb;


% Creating regular Users and granting rights
mysql> grant all on IUExtremeMDB.* to yuma@"%.extreme.indiana.edu" identified by '<super secret password>' with grant option;
mysql> grant all on WRFMDB.* to yuma@"%.extreme.indiana.edu" identified by '<super secret password>' with grant option;

mysql> grant all on componentBrowser.* to ranantha@"%.extreme.indiana.edu" identified by '<super secret password>' with grant option;

mysql> grant all on eventdb.* to ysimmhan@"%.extreme.indiana.edu" identified by '<super secret password>' with grant option;
mysql> grant all on eventdb.* to aslom@"%.extreme.indiana.edu" identified by '<super secret password>' with grant option;
mysql> grant all on eventdb.* to arossi@"%.extreme.indiana.edu" identified by '<super secret password>' with grant option;
mysql> grant all on eventdb.* to mafarrel@"%.extreme.indiana.edu" identified by '<super secret password>' with grant option;

mysql> grant all privileges on *.* to ysimmhan@localhost identified by '<super secret password>' with grant option;
mysql> grant all privileges on *.* to ysimmhan@"%" identified by '<super secret password>' with grant option;


% Creating virtual Users and granting rights
mysql> grant insert, delete, select, update on IUExtremeMDB.* to FileManager@"%";
mysql> grant insert, delete, select, update on IUExtremeMDB.* to FileManager@localhost;

mysql> grant insert, delete, select, update on componentBrowser.* to cb@"%" identified by 'z/x.c,';
mysql> grant insert, delete, select, update on componentBrowser.* to cb@localhost identified by 'z/x.c,';

mysql> grant insert, delete, select, update on eventdb.* to eventuser@"%";
mysql> grant insert, delete, select, update on eventdb.* to eventuser@localhost;

% Save privileges
mysql> flush privileges;


% Export data from previous installation ...
bin/mysqldump -h rainier.extreme.indiana.edu -u root -p IUExtremeMDB > ~/scratch/iu_extreme_mdb
bin/mysqldump -h rainier.extreme.indiana.edu -u root -p WRFMDB > ~/scratch/wrf_mdb
bin/mysqldump -h rainier.extreme.indiana.edu -u root -p componentBrowser > ~/scratch/component_browser
bin/mysqldump -h brick.extreme.indiana.edu -u root -p --no-data eventdb > ~/scratch/event_db

% ... and Import it into current installation
bin/mysql -h rainier.extreme.indiana.edu -u root -p IUExtremeMDB < ~/scratch/iu_extreme_mdb
bin/mysql -h rainier.extreme.indiana.edu -u root -p WRFMDB < ~/scratch/wrf_mdb
bin/mysql -h rainier.extreme.indiana.edu -u root -p componentBrowser < ~/scratch/component_browser
bin/mysql -h rainier.extreme.indiana.edu -u root -p eventdb < ~/scratch/event_db


4.0.16

Download (Linux binary)

http://www.mysql.com/get/Downloads/MySQL-4.0/mysql-standard-4.0.16-pc-linux-i686.tar.gz/from/http://mirror.services.wisc.edu/mysql/

Logs

linux install - 24-Nov-2003

Configuration

% Set root password
bin/mysqladmin -u root -p password 'new-password'
bin/mysqladmin -u root -h linbox1.extreme.indiana.edu password 'new-pasword'

% login and create database GSX and users.
bin/mysql -u root -h localhost -p

% Creating Users and granting rights
grant all on GSX.* to gsx_admin@"%.extreme.indiana.edu" identified by 'qwerty' with grant option;

grant create, drop, insert, select, update, delete on GSX.* to gsx_user@"%";
grant create, drop, insert, select, update, delete on GSX.* to gsx_user@localhost;

flush privileges;


Last updated 31 Mar 2006 by machrist@cs.indiana.edu