STAR   Computing Tutorials main page
STAR Databases: Server Configuration - online

Online computing tutorial Maintained by Michael DePhillips

onlsun1.starp.bnl.gov

  • cpu0: SUNW,UltraSPARC-II (upaid 1 impl 0x11 ver 0xa0 clock 400 MHz)
  • cpu1: SUNW,UltraSPARC-II (upaid 3 impl 0x11 ver 0xa0 clock 400 MHz)
  • SunOS Release 5.6 Version Generic_105181-26 [UNIX(R) System V Release 4.0] Copyright (c) 1983-1997, Sun Microsystems, Inc.
  • mem = 2097152K (0x80000000)
  • avail mem = 2086993920
  • Ethernet address = 8:0:20:a7:6c:91
  • root nexus = Sun Enterprise 450 (2 X UltraSPARC-II 400MHz)

More detail for the truly interested:

System Configuration: Sun Microsystems sun4u Sun Enterprise 450 (2 X UltraSPARC-II 400MHz)

System clock frequency: 100 MHz

Memory size: 2048 Megabytes

========================= CPUs =========================

BrdCPUModuleRun MHzEcache MBCPU Impl.CPU Mask
SYS11400 4.0US-II 10.0
SYS 3 3 400 4.0 US-II 10.0

========================= Memory =========================

Memory Interleave Factor = 2-way

Bank Interlv.GroupSocket Name Size (MB) Status
0 0 1901 256 OK
0 0 1902 256 OK
0 0 1903 256 OK
0 0 1904 256 OK
1 0 1801 256 OK
1 0 1802 256 OK
1 0 1803 256 OK
1 0 1804 256 OK

========================= IO Cards =========================

Brd Bus Type Freq MHz Slot Name Model
SYS PCI 33 1 pciclass,001000 Symbios,53C875
SYS PCI 33 2 pciclass,001000 Symbios,53C875
SYS PCI 33 3 SUNW,m64B ATY,GT-B
SYS PCI 33 7 pciclass,068000
SYS PCI 33 7 pci108e,1001 SUNW,cheerio
SYS PCI 33 7 pciclass,010000 QLGC,ISP1040B
SYS PCI 33 8 pciclass,068000
SYS PCI 33 8 pci108e,1001 SUNW,cheerio
SYS PCI 33 8 pciclass,010000 QLGC,ISP1040B
SYS PCI 33 9 pciclass,000000

MYSQL Configuration

There are seven production databases servers on onlsun1 on the following ports:
3501, 3502, 3503, 3400, 3401, 3402, 3403.

You can connect to the production databases from onlsun1 using the feedback loop as user starcrew using the follwing command:
mysql --socket=/tmp/mysql.3xxx.sock.

Starting and stopping the Mysql Servers should be done at boot/shutdown time,
if needed to be restarted by hand the scripts can be found as follows:
/online/production/database/config
The production scripts are number according to the Run they represent.

For the production servers use: /etc/init.d/mysql_multi.servers These are calls to the actual start/stop scripts which can be found in
/online/production/dbAdmin/servers

The databases are as follows:

Port 3501:
  • Conditions_rts
  • RunLog
  • SSignupDev
  • Scalers_onl
  • Scalers_rts
  • ShiftLog
  • ShiftSignup
  • ShiftSignupBackup
  • StarDb
  • mysql

Port 3502:
  • Calibrations_test
  • Conditions_bbc
  • Conditions_eemc
  • Conditions_emc
  • Conditions_ftpc
  • Conditions_rhic
  • Conditions_rich
  • Conditions_svt
  • Conditions_tof
  • Conditions_tpc
  • Conditions_trg
  • Log_eemc
  • RunLog
  • RunLog_onl
  • mysql
Port 3503:
  • Calibrations_daq
  • RunLog_daq
  • mysql
Port 3400:
  • Conditions_daq
  • Conditions_onl
  • Conditions_rhic
  • Conditions_rich
  • Conditions_scalar
  • Conditions_svt
  • Conditions_tpc
  • Conditions_trg
  • RunLog
  • RunLog_daq
  • RunLog_onl
  • StarComputers
  • StarDb
  • mysql
  • test
Port 3401:
  • Conditions_emc
  • Conditions_ftpc
  • Conditions_rhic
  • Conditions_rich
  • Conditions_rts
  • Conditions_svt
  • Conditions_tof
  • Conditions_tpc
  • Conditions_trg
  • RunLog
  • RunLog_daq
  • RunLog_onl
  • StarDb
  • mysql
  • test