Gengy - CSBE Database Server

General

SynthSys database server. Runs the following database(s):

MySQL server (DICE)

IBM DB2 server (Selfmanaged)

and an old defunct PGSQL (DICE) database is still held on disk, but not running

Administration operations restricted to users that have csbe-admin role.

Backups

Rsync in LCFG profile:


rsync.mentry_gengy_1 path=/disk/data
rsync.mentry_gengy_2 hosts allow=lammasu.inf.ed.ac.uk

Startup procedure

All services should autostart. See @reboot entries in LCFG profile.

DB2

Locations

/opt/ibm/db2/V9.7/

Accounts

See accounts sheet

Starting DB2 manually (If autostart fails)

(n)su db2inst

DB2INSTANCE =db2inst

export DB2INSTANCE

. /disk/data/db2home/db2inst1/sqllib/db2profile

db2start

Installation/disaster recovery:

Last known software version: IBM DB2 Express-C 9.7.4 x64

Install:

db2 "update dbm cfg using SVCENAME db2c_db2inst"

MySQL

Backups: Run at 3am? to

/disk/data/backup/mysql/year/mysqldump-DayOfWeek

7 day rotating backups. Year has to be manually changed in script (or just ignored)

Installation

DICE-managed:

#include <dice/options/mysql-server.h>
!mysql.datadir mSET(/disk/data/mysql)

Accounts

See accounts sheet

+ many more

Creating a Database

Standard MySQL procedure:

nsu

cd

mysql -S /disk/data/mysql/mysql.sock -u root -p

(enter password)

create database name_of_database

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES on name_of_database.* TO 'username_of_owner'@'localhost' IDENTIFIED BY 'password_for_database';

FLUSH PRIVILEGES;

show databases;

Starting MySQL manually (If autostart fails)

om mysql start

OR the really manual way:

nsu

mysqld_safe --socket=/disk/data/mysql/mysql.sock -u root

Hardware

<TBC>


This topic: DICE > SynthSysServersGengy
Topic revision: r1 - 06 Sep 2012 - 11:34:30 - YanHuang
 
This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback
This Wiki uses Cookies