SQWareProduction:cassandra:etc:sqwcas GlobalVar.cfg

From Wiki_dbSQWare
Revision as of 18:46, 20 July 2020 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Configuration file $gvsqw_CasBin/../etc/sqwcas_GlobalVar.cfg:
Global var for Cassandra
It contains the operating variables of SQWareProduction.

File content:

#!/bin/bash
###################################################################
# SQWareProduction for Cassandra module of dbSQWare
# 
# dbSQWare is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# CGU/CGA for more details.
# 
# You should have received a copy of the CGU/CGA
# along with this program.  If not, see <http://www.dbsqware.com/licenses/>.
# 
# For information : contact@dbsqware.com or www.dbsqware.com
###################################################################
## @Synopsis	Global var for Cassandra
## @Copyright	Copyright 2007-2025, dbSQWare (www.dbsqware.com)

#global
export gvsqw_SqwVersionDbms=2025.11
export gvsqw_RootAdmin='$HOME/${CAS_SID}'
export gvsqw_RootAdminDisable='$HOME'
export gvsqw_RootAdminDist='$HOME/admin/cassandra/${CAS_SID}'
export gvsqw_RootCfg='$gvsqw_RootAdmin/sqwConfig'
export gvsqw_RootDbf='/data/cassandra'
export gvsqw_DbAlias='$CAS_SID'
export gvsqw_CasqlErrorMsg='Exception|Error:'
export gvsqw_CqlshOpt=''
export gvsqw_NodeName

#For all nodes commands
export gvsqw_AggressivenessRun=1
export gvsqw_AggressivenessCheckEnd=5
export gvsqw_TimeOutDef=172800 # default 48h

#For restart
export gvsqw_TimeOutStop=900
export gvsqw_TimeOutCheckStart=900
export gvsqw_WaitBetweenTwoNodes=120
export gvsqw_WaitBetweenStopStart=60
export gvsqw_StartCommand='/opt/cassandra/bin/start-cassandra'
export gvsqw_StopCommand='/opt/cassandra/bin/stop-cassandra'

#for backup scripts
export gvsqw_NbThreadBackup=3
export gvsqw_RootBackup='/backup/cassandra/${CAS_SID}'
export gvsqw_backupNbGeneration=2


Variables explanation:

#General variables
gvsqw_SqwVersionDbms => dbsqware version
gvsqw_RootAdmin => admin directory
gvsqw_RootAdminDisable => XXXXX
gvsqw_RootAdminDist => XXXXX
gvsqw_RootCfg => configuration directory
gvsqw_RootDbf => datafiles directory
gvsqw_DbAlias => Database Alias
gvsqw_CasqlErrorMsg => XXXXX
gvsqw_CqlshOpt => XXXXX
gvsqw_NodeName => XXXXX

#For all nodes commands
gvsqw_AggressivenessRun => XXXXX
gvsqw_AggressivenessCheckEnd => XXXXX
gvsqw_TimeOutDef => XXXXX

#For restart
gvsqw_TimeOutStop => XXXXX
gvsqw_TimeOutCheckStart => XXXXX
gvsqw_WaitBetweenTwoNodes => XXXXX
gvsqw_WaitBetweenStopStart => XXXXX
gvsqw_StartCommand => XXXXX
gvsqw_StopCommand => XXXXX

#for backup scripts
gvsqw_NbThreadBackup => default number of thread for parallelism for backup
gvsqw_RootBackup => default backup directory
evsqw_backupNbGeneration => default number generation of backup to keep online
Note:
You can overload variables contain in $gvsqw_CasBin/../etc/sqwcas_GlobalVar.cfg

by the same variables in $gvsqw_CasBin/../etc_cust/sqwcas_GlobalVar.cfg for all your environnement
or in $HOME/sqwConfig/sqwcas_GlobalVar.cfg specifically for this user.