Problem with ServiceGroup dependency
Hi
we have a veritas cluster server here, (totally new for me) . So the VCS manage a tamino application, this tamino application has two database instances f.e. db1 and db2
So i configured for each instance a service group, Tamino and TaminoDB2. Cause the problem is, when database db1 goes down the VCS shutdown also the db2 and that is not what i want. I want to seperate this. Hope you understand me. Here are my main.cf entries for tamino
group Tamino (
SystemList = { np-p62 = 0, np-p61 = 1 }
AutoStart = 0
AutoStartList = { np-p62 }
AutoRestart = 0
)
Application TaminoApache (
Critical = 0
StartProgram = "/opt/VRTSvcs/bin/TaminoApache/online"
StopProgram = "/opt/VRTSvcs/bin/TaminoApache/offline"
MonitorProgram = "/opt/VRTSvcs/bin/TaminoApache/monitor"
)
Application sag2adi (
StartProgram = "/opt/VRTSvcs/bin/sag2adi/online"
StopProgram = "/opt/VRTSvcs/bin/sag2adi/offline"
CleanProgram = "/opt/VRTSvcs/bin/sag2adi/clean"
MonitorProgram = "/opt/VRTSvcs/bin/sag2adi/monitor"
)
Application sag2arg (
StartProgram = "/opt/VRTSvcs/bin/sag2arg/online"
StopProgram = "/opt/VRTSvcs/bin/sag2arg/offline"
CleanProgram = "/opt/VRTSvcs/bin/sag2arg/clean"
MonitorProgram = "/opt/VRTSvcs/bin/sag2arg/monitor"
)
Application sag2argev (
StartProgram = "/opt/VRTSvcs/bin/sag2argev/online"
StopProgram = "/opt/VRTSvcs/bin/sag2argev/offline"
CleanProgram = "/opt/VRTSvcs/bin/sag2argev/clean"
MonitorProgram = "/opt/VRTSvcs/bin/sag2argev/monitor"
)
Application sag2argml (
StartProgram = "/opt/VRTSvcs/bin/sag2argml/online"
StopProgram = "/opt/VRTSvcs/bin/sag2argml/offline"
CleanProgram = "/opt/VRTSvcs/bin/sag2argml/clean"
MonitorProgram = "/opt/VRTSvcs/bin/sag2argml/monitor"
)
Application sag2utx (
StartProgram = "/opt/VRTSvcs/bin/sag2utx/online"
StopProgram = "/opt/VRTSvcs/bin/sag2utx/offline"
CleanProgram = "/opt/VRTSvcs/bin/sag2utx/clean"
MonitorProgram = "/opt/VRTSvcs/bin/sag2utx/monitor"
)
IP NP-DB6 (
Device = eth0
Address = "192.168.0.41"
NetMask = "255.255.255.0"
)
LVMLogicalVolume LVM-Vol-Backup (
Critical = 0
LogicalVolume = backupvol
VolumeGroup = volgtdata
)
LVMLogicalVolume LVM-Vol-Data (
Critical = 0
LogicalVolume = datavol
VolumeGroup = volgtdata
)
LVMLogicalVolume LVM-Vol-Index (
Critical = 0
LogicalVolume = indexvol
VolumeGroup = volgtdata
)
LVMLogicalVolume LVM-Vol-Log (
Critical = 0
LogicalVolume = logvol
VolumeGroup = volgtlog
)
LVMLogicalVolume LVM-Vol-Misc (
Critical = 0
LogicalVolume = miscvol
VolumeGroup = volgtlog
)
Mount BackupMount (
Critical = 0
MountPoint = "/opt/tamino/ino/db/backup"
BlockDevice = "/dev/mapper/volgtdata-backupvol"
FSType = ext3
FsckOpt = "-y"
)
Mount DataMount (
MountPoint = "/opt/tamino/ino/db/data"
BlockDevice = "/dev/mapper/volgtdata-datavol"
FSType = ext3
FsckOpt = "-y"
)
Mount IndexMount (
MountPoint = "/opt/tamino/ino/db/index"
BlockDevice = "/dev/mapper/volgtdata-indexvol"
FSType = ext3
FsckOpt = "-y"
)
Mount LogMount (
MountPoint = "/opt/tamino/ino/db/log"
BlockDevice = "/dev/mapper/volgtlog-logvol"
FSType = ext3
FsckOpt = "-y"
)
Mount MiscMount (
MountPoint = "/opt/tamino/ino/db/misc"
BlockDevice = "/dev/mapper/volgtlog-miscvol"
FSType = ext3
FsckOpt = "-y"
)
TaminoSrv DB1 (
Critical = 0
ServerName = DB1
HaCollection = inoham
TaminoUsername = tamino
TaminoPassword = tamino
SagInstallationUser = tamino
Host = tamino
Timeout = 300
)
requires group LVM-Paralel-Groups online local soft
BackupMount requires LVM-Vol-Backup
DataMount requires LVM-Vol-Data
IndexMount requires LVM-Vol-Index
LVM-Vol-Backup requires NP-DB6
LVM-Vol-Data requires NP-DB6
LVM-Vol-Index requires NP-DB6
LVM-Vol-Log requires NP-DB6
LVM-Vol-Misc requires NP-DB6
LogMount requires LVM-Vol-Log
MiscMount requires LVM-Vol-Misc
DB1 requires sag2utx
TaminoApache requires sag2utx
sag2adi requires BackupMount
sag2adi requires DataMount
sag2adi requires IndexMount
sag2adi requires LogMount
sag2adi requires MiscMount
sag2arg requires sag2adi
sag2argev requires sag2arg
sag2argml requires sag2argev
sag2utx requires sag2argml
group TaminoNews (
SystemList = { np-p62 = 0, np-p61 = 1 }
)
Application TaminoApache_1 (
StartProgram = "/opt/VRTSvcs/bin/TaminoApache/online"
StopProgram = "/opt/VRTSvcs/bin/TaminoApache/offline"
MonitorProgram = "/opt/VRTSvcs/bin/TaminoApache/monitor"
)
Application sag2adi_1 (
StartProgram = "/opt/VRTSvcs/bin/sag2adi/online"
StopProgram = "/opt/VRTSvcs/bin/sag2adi/offline"
CleanProgram = "/opt/VRTSvcs/bin/sag2adi/clean"
MonitorProgram = "/opt/VRTSvcs/bin/sag2adi/monitor"
)
Application sag2arg_1 (
StartProgram = "/opt/VRTSvcs/bin/sag2arg/online"
StopProgram = "/opt/VRTSvcs/bin/sag2arg/offline"
CleanProgram = "/opt/VRTSvcs/bin/sag2arg/clean"
MonitorProgram = "/opt/VRTSvcs/bin/sag2arg/monitor"
)
Application sag2argev_1 (
StartProgram = "/opt/VRTSvcs/bin/sag2argev/online"
StopProgram = "/opt/VRTSvcs/bin/sag2argev/offline"
CleanProgram = "/opt/VRTSvcs/bin/sag2argev/clean"
MonitorProgram = "/opt/VRTSvcs/bin/sag2argev/monitor"
)
Application sag2argml_1 (
StartProgram = "/opt/VRTSvcs/bin/sag2argml/online"
StopProgram = "/opt/VRTSvcs/bin/sag2argml/offline"
CleanProgram = "/opt/VRTSvcs/bin/sag2argml/clean"
MonitorProgram = "/opt/VRTSvcs/bin/sag2argml/monitor"
)
Regards
ACID1943
Application sag2utx_1 (
StartProgram = "/opt/VRTSvcs/bin/sag2utx/online"
StopProgram = "/opt/VRTSvcs/bin/sag2utx/offline"
CleanProgram = "/opt/VRTSvcs/bin/sag2utx/clean"
MonitorProgram = "/opt/VRTSvcs/bin/sag2utx/monitor"
)
IP NP-DB6_1 (
Device = eth0
Address = "192.168.0.41"
NetMask = "255.255.255.0"
)
LVMLogicalVolume LVM-Vol-Backup_1 (
LogicalVolume = backupvol
VolumeGroup = volgtdata
)
LVMLogicalVolume LVM-Vol-Data_1 (
LogicalVolume = datavol
VolumeGroup = volgtdata
)
LVMLogicalVolume LVM-Vol-Index_1 (
LogicalVolume = indexvol
VolumeGroup = volgtdata
)
LVMLogicalVolume LVM-Vol-Log_1 (
LogicalVolume = logvol
VolumeGroup = volgtlog
)
LVMLogicalVolume LVM-Vol-Misc_1 (
LogicalVolume = miscvol
VolumeGroup = volgtlog
)
Mount BackupMount_1 (
MountPoint = "/opt/tamino/ino/db/backup"
BlockDevice = "/dev/mapper/volgtdata-backupvol"
FSType = ext3
FsckOpt = "-y"
)
Mount DataMount_1 (
MountPoint = "/opt/tamino/ino/db/data"
BlockDevice = "/dev/mapper/volgtdata-datavol"
FSType = ext3
FsckOpt = "-y"
)
Mount IndexMount_1 (
MountPoint = "/opt/tamino/ino/db/index"
BlockDevice = "/dev/mapper/volgtdata-indexvol"
FSType = ext3
FsckOpt = "-y"
)
Mount LogMount_1 (
MountPoint = "/opt/tamino/ino/db/log"
BlockDevice = "/dev/mapper/volgtlog-logvol"
FSType = ext3
FsckOpt = "-y"
)
Mount MiscMount_1 (
MountPoint = "/opt/tamino/ino/db/misc"
BlockDevice = "/dev/mapper/volgtlog-miscvol"
FSType = ext3
FsckOpt = "-y"
)
TaminoSrv DB2 (
Critical = 0
ServerName = DB2
HaCollection = inoham
TaminoUsername = tamino
TaminoPassword = tamino
SagInstallationUser = tamino
Host = tamino
Timeout = 600
)
BackupMount_1 requires LVM-Vol-Backup_1
DataMount_1 requires LVM-Vol-Data_1
IndexMount_1 requires LVM-Vol-Index_1
LVM-Vol-Backup_1 requires NP-DB6_1
LVM-Vol-Data_1 requires NP-DB6_1
LVM-Vol-Index_1 requires NP-DB6_1
LVM-Vol-Log_1 requires NP-DB6_1
LVM-Vol-Misc_1 requires NP-DB6_1
LogMount_1 requires LVM-Vol-Log_1
MiscMount_1 requires LVM-Vol-Misc_1
DB2 requires sag2utx_1
TaminoApache_1 requires sag2utx_1
sag2adi_1 requires BackupMount_1
sag2adi_1 requires DataMount_1
sag2adi_1 requires IndexMount_1
sag2adi_1 requires LogMount_1
sag2adi_1 requires MiscMount_1
sag2arg_1 requires sag2adi_1
sag2argev_1 requires sag2arg_1
sag2argml_1 requires sag2argev_1
sag2utx_1 requires sag2argml_1
If db1 and db2 are supposed to run on the same node (ie: they're not supposed to run on different nodes), then you only need one group.
Add TaminoSrv DB2 resource to the existing Tamino group.
Ensure the TaminoSrv resources are non-critical (Critical = 0) so if they fault they won't trigger failover (in your configuration they were already set as Critical = 0, but just make sure when you re-add the resource).
If both databases rely on sag2utx, ensure you configure this dependency.
So, if configured this way, when the group is brought online, after sag2utx is started db1 and db2 will be started.
If db1 faults, the group will not failover, and unless there is dependency between the databases db2 should still remain up, and vice versa.