SQWareProduction:mongodb:etc:sqwmng GlobalVar.cfg

From Wiki_dbSQWare
Revision as of 20:14, 29 November 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_MngBin/../etc/sqwmng_GlobalVar.cfg:
Global var for MongoDB
It contains the operating variables of SQWareProduction.

File content:

#!/bin/bash
###################################################################
# SQWareProduction for MongoDB 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 MongoDB
## @Copyright	Copyright 2007-2025, dbSQWare (www.dbsqware.com)

#global
export gvsqw_SqwVersionDbms=2025.11
export gvsqw_RootAdmin='$HOME/${MNG_SID}'
export gvsqw_RootAdminDisable='$HOME'
export gvsqw_RootAdminDist='$HOME/admin/mongodb/${MNG_SID}'
export gvsqw_RootCfg='$gvsqw_RootAdmin/sqwConfig'
export gvsqw_RootDbf='/$(echo ${HOME}|cut -d/ -f2)/data/${MNG_SID}'
export gvsqw_DbAlias='$MNG_SID'
export gvsqw_MongoErrorMsg='Error: |error: |"ok" : 0, "errmsg" :|ok : 0, errmsg :|MongoServerError'
export gvsqw_NbThreadRestore=2

##For manage connection
# export gvsqw_EnvFunctionsFileName='$gvsqw_RootCfg/env.js'
# export gvsqw_ConnectString='--quiet --nodb --shell $gvsqw_EnvFunctionsFileName'
export gvsqw_ConnectString='--quiet --nodb --shell $gvsqw_RootCfg/env.js'
#Name of the local connect function
export gvsqw_LocalConnectFunction='js_LocalConnection'

##For indicators 
#put in your local profile "export gvsqw_NodeName='xyz'" to unique identification of node
#put in your local profile "export gvsqw_PrincipalNode=true" when node is 'primary'
export gvsqw_SizeMinTableIndicators=1
export gvsqw_PathList="HOME;gvsqw_RootAdmin;gvsqw_RootCfg;gvsqw_RootDump;gvsqw_RootDumpTmp"
export gvsqw_PathListExtra=""

##For mongodump scripts
export gvsqw_NbThreadDump=2
export gvsqw_NbThreadCopyDump=2
export gvsqw_DumpNbGeneration=2
export gvsqw_DefCopyDumpNbGeneration=1
export gvsqw_AfterDump='Tar'
export gvsqw_RootDump='$HOME/mng_dump/${MNG_SID}'
export gvsqw_RootDumpTmp='$HOME/mng_dump/${MNG_SID}/tmp'
export gvsqw_RootDumpSource='$HOME/mng_dump/$lvsqw_InstanceSource'
export gvsqw_ExcludeDatabasesDump='^local$|^config$'
export gvsqw_ExcludeDatabasesCopy='^local$|^config$|^admin$'
export gvsqw_RsyncDefaultSourceDir='$HOME/mng_dump/${MNG_SID}'

## For compact scripts
export gvsqw_DoNotCompact='^system\.'
export gvsqw_NbThreadCompact=2


Variables explanation:

#General variables
export gvsqw_RootAdmin => admin directory
export gvsqw_RootAdminDisable => XXXXX
export gvsqw_RootAdminDist => XXXXX
export gvsqw_RootCfg => configuration directory
export gvsqw_RootDbf => datafiles directory
export gvsqw_DbAlias => Database Alias
export gvsqw_MongoErrorMsg => XXXXX
export gvsqw_NbThreadRestore => default number of thread for parallelism for restore

##For manage connection
export gvsqw_EnvFunctionsFileName => XXXXX
export gvsqw_ConnectString => XXXXX

#Name of the local connect function
export gvsqw_LocalConnectFunction => XXXXX

##For mongodump scripts
export gvsqw_NbThreadDump => default number of thread for parallelism for mysqlDump
export gvsqw_NbThreadCopyDump => XXXXX
export gvsqw_DumpNbGeneration => default number generation of export full to keep online
export gvsqw_DefCopyDumpNbGeneration => default number generation of mng_Dump to keep online
export gvsqw_RootDump => default mongodump directory
export gvsqw_RootDumpTmp => XXXXX
export gvsqw_RootDumpSource => default Dump directory of source dataserver
export gvsqw_ExcludeDatabasesCopy => XXXXX

## For compact scripts
export gvsqw_DoNotCompact => XXXXX
export gvsqw_NbThreadCompact =>  XXXXX
Note:
You can overload variables contain in $gvsqw_MngBin/../etc/sqwmng_GlobalVar.cfg

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