Difference between revisions of "SQWareProduction:mongodb:etc:sqwmng GlobalVar.cfg"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
Line 1: Line 1:
 
Configuration file $gvsqw_MngBin/../etc/sqwmng_GlobalVar.cfg:<br>
 
Configuration file $gvsqw_MngBin/../etc/sqwmng_GlobalVar.cfg:<br>
 
{{SQWareProduction_sqwmng_GlobalVar.cfg_presentation}}
 
{{SQWareProduction_sqwmng_GlobalVar.cfg_presentation}}
<br>
+
{{SQWareProduction_sqwmng_GlobalVar.cfg_content}}
<br>
+
{{SQWareProduction_sqwmng_GlobalVar.cfg_explanation}}
File content:
 
<pre>
 
export gvsqw_SqwVersionDbms=2023.08
 
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" :'
 
export gvsqw_NbThreadRestore=2
 
export gvsqw_EnvFunctionsFileName='$gvsqw_RootCfg/env.js'
 
export gvsqw_ConnectString='--quiet --nodb --shell $gvsqw_EnvFunctionsFileName'
 
export gvsqw_LocalConnectFunction='js_LocalConnection'
 
#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=""
 
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$'
 
export gvsqw_ExcludeDatabasesCopy='^local$|^admin$'
 
export gvsqw_RsyncDefaultSourceDir='$HOME/mng_dump/${MNG_SID}'
 
export gvsqw_DoNotCompact='^system\.'
 
export gvsqw_NbThreadCompact=2
 
</pre>
 
<br>
 
<br>
 
Variables explanation:
 
<pre>
 
gvsqw_AfterDump =>
 
gvsqw_ConnectString =>
 
gvsqw_DbAlias =>
 
gvsqw_DefCopyDumpNbGeneration =>
 
gvsqw_DoNotCompact =>
 
gvsqw_DumpNbGeneration =>
 
gvsqw_EnvFunctionsFileName =>
 
gvsqw_ExcludeDatabasesCopy =>
 
gvsqw_ExcludeDatabasesDump =>
 
gvsqw_LocalConnectFunction =>
 
gvsqw_MongoErrorMsg =>
 
gvsqw_NbThreadCompact =>
 
gvsqw_NbThreadCopyDump =>
 
gvsqw_NbThreadDump =>
 
gvsqw_NbThreadRestore =>
 
gvsqw_PathListExtra =>
 
gvsqw_PathList =>
 
gvsqw_RootAdmin =>
 
gvsqw_RootAdminDisable =>
 
gvsqw_RootAdminDist =>
 
gvsqw_RootCfg =>
 
gvsqw_RootDbf =>
 
gvsqw_RootDump =>
 
gvsqw_RootDumpSource =>
 
gvsqw_RootDumpTmp =>
 
gvsqw_RsyncDefaultSourceDir =>
 
gvsqw_SizeMinTableIndicators =>
 
gvsqw_SqwVersionDbms =>
 
#put in your local profile "gvsqw_NodeName =>
 
#put in your local profile "gvsqw_PrincipalNode =>
 
</pre>
 
 
{{SQWareProductionSurchargeVar|mongodb|Mng|sqwmng_GlobalVar.cfg}}
 
{{SQWareProductionSurchargeVar|mongodb|Mng|sqwmng_GlobalVar.cfg}}
 
<br>
 
<br>

Revision as of 17:03, 6 November 2023

Configuration file $gvsqw_MngBin/../etc/sqwmng_GlobalVar.cfg:
Global var for MongoDB
It contains the operating variables of SQWareProduction.

File content:

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

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