Difference between revisions of "SQWareProduction:cassandra:etc:sqwcas GlobalVar.cfg"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
Line 1: Line 1:
 
Configuration file $gvsqw_CasBin/../etc/sqwcas_GlobalVar.cfg:<br>
 
Configuration file $gvsqw_CasBin/../etc/sqwcas_GlobalVar.cfg:<br>
 
{{SQWareProduction_sqwcas_GlobalVar.cfg_presentation}}
 
{{SQWareProduction_sqwcas_GlobalVar.cfg_presentation}}
<br>
+
{{SQWareProduction_sqwcas_GlobalVar.cfg_content}}
<br>
+
{{SQWareProduction_sqwcas_GlobalVar.cfg_explanation}}
File content:
 
<pre>
 
export gvsqw_SqwVersionDbms=2022.01
 
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
 
export gvsqw_AggressivenessRun=1
 
export gvsqw_AggressivenessCheckEnd=5
 
export gvsqw_TimeOutDef=172800 # default 48h
 
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'
 
export gvsqw_NbThreadBackup=3
 
export gvsqw_RootBackup='/backup/cassandra/${CAS_SID}'
 
export gvsqw_backupNbGeneration=2
 
</pre>
 
<br>
 
<br>
 
Variables explanation:
 
<pre>
 
gvsqw_AggressivenessCheckEnd =>
 
gvsqw_AggressivenessRun =>
 
gvsqw_backupNbGeneration =>
 
gvsqw_CasqlErrorMsg =>
 
gvsqw_CqlshOpt =>
 
gvsqw_DbAlias =>
 
gvsqw_NbThreadBackup =>
 
gvsqw_NodeName
 
gvsqw_RootAdmin =>
 
gvsqw_RootAdminDisable =>
 
gvsqw_RootAdminDist =>
 
gvsqw_RootBackup =>
 
gvsqw_RootCfg =>
 
gvsqw_RootDbf =>
 
gvsqw_SqwVersionDbms =>
 
gvsqw_StartCommand =>
 
gvsqw_StopCommand =>
 
gvsqw_TimeOutCheckStart =>
 
gvsqw_TimeOutDef =>
 
gvsqw_TimeOutStop =>
 
gvsqw_WaitBetweenStopStart =>
 
gvsqw_WaitBetweenTwoNodes =>
 
</pre>
 
 
{{SQWareProductionSurchargeVar|cassandra|Cas|sqwcas_GlobalVar.cfg}}
 
{{SQWareProductionSurchargeVar|cassandra|Cas|sqwcas_GlobalVar.cfg}}
 
<br>
 
<br>

Revision as of 18:09, 30 January 2022

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

File content:

#!/bin/ksh
###################################################################
# 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 2010-2024, dbSQWare (www.dbsqware.com)

#global
export gvsqw_SqwVersionDbms=2024.07
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
Nuvola apps information.png
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.