SQWareProduction:mysql:etc:sqwmys GlobalVar.cfg
Révision datée du 30 janvier 2022 à 17:58 par BatchUser (discussion | contributions) (Updated by BatchUser)
Fichier de configuration $gvsqw_MysBin/../etc/sqwmys_GlobalVar.cfg:
Global var for Mysql
Contient les variables operationnelles de SQWareProduction.
Contenu du fichier:
export gvsqw_SqwVersionDbms=2022.01 export gvsqw_MysqlSock='$MYSQL_HOME/tmp/$MYSQL_SID.sock' export gvsqw_MysqlSock='$MYSQL_DATA/tmp/$MYSQL_SID.sock' export gvsqw_MysqlSock='/tmp/$MYSQL_SID.sock' export gvsqw_MysqlSock='/var/lib/mysql/mysql.sock' export gvsqw_MysqlSock='/var/lib/mysqld/mysql.sock' export gvsqw_MysqlSock='/var/lib64/mysql/mysql.sock' export gvsqw_MysqlSock='/var/lib64/mysqld/mysql.sock' export gvsqw_MysqlSock='/tmp/mysql.sock' export gvsqw_MysqlSock='/run/mysqld/mysqld.sock' export gvsqw_DbaUser="$gvsqw_UserExec" export gvsqw_ConnectString='-S $gvsqw_MysqlSock -u $gvsqw_DbaUser' export gvsqw_DistConnectString='-h $gvsqw_MysqlHost -P $gvsqw_MysqlPort -u$gvsqw_DbaUser -p$gvsqw_DbaUserPasswd' export gvsqw_SuppArchSlow=30 export gvsqw_RootAdmin='$HOME/${MYSQL_SID}' export gvsqw_RootAdminDisable='$HOME' export gvsqw_RootAdminDist='$HOME/admin/mysql/${MYSQL_SID}' export gvsqw_RootCfg='$gvsqw_RootAdmin/sqwConfig' export gvsqw_RootDbf='/$(echo ${HOME}|cut -d/ -f2)/data/${MYSQL_SID}' #export gvsqw_GenExcludeDatabasesWhereClause="and SCHEMA_NAME not in ('SQWareProduction','${MYSQL_SID}','tmp','logs') and SCHEMA_NAME not like '%#%' and SCHEMA_NAME not like '% %'" export gvsqw_GenExcludeDatabasesWhereClause="and table_schema not like '%#%' and table_schema not like '% %' and table_schema != 'performance_schema' and table_schema != 'sys'" export gvsqw_DbAlias='$MYSQL_SID' export gvsqw_NbThreadOptimize=2 export gvsqw_NbThreadAnalyze=2 export gvsqw_NbThreadDump=2 export gvsqw_NbThreadCopyDump=2 export gvsqw_NbThreadRestore=2 export gvsqw_NbThreadCheck=2 export gvsqw_NotMysqlErrorMsg="_ERROR |_FAILED |_ERREUR |_ECHEC |'ERROR |'FAILED |'ERREUR |'ECHEC " export gvsqw_NotMysqldumpErrorMsg="mysqldump: Error ToBeCustomize" export gvsqw_SizeMinTableIndicators=10 export gvsqw_GenExcludeDatabasesObjects="and TABLES.TABLE_SCHEMA not in ('performance_schema','mysql','information_schema','sys')" export gvsqw_GenExcludeDatabasesObjectsExtra="" export gvsqw_RootDump='$HOME/mys_dump/$MYSQL_SID' export gvsqw_RootDumpSource='$HOME/mys_dump/$lvsqw_InstanceSource' export gvsqw_ExcludeDatabasesCopy='^mysql$|^information_schema$|^performance_schema$' export gvsqw_DumpNbGeneration=2 export gvsqw_DumpCompressorExt=gz export gvsqw_DefCopyDumpNbGeneration=1 export gvsqw_ConsistentInnoDb="--single-transaction --skip-lock-tables" export gvsqw_ConsistentOthers="--lock-tables" export gvsqw_MysqlDumpOpt='$gvsqw_ConnectString --create-options -f --max_allowed_packet=1000000000 --net_buffer_length=16M ${lfsqw_SqlOpt}${lvsqw_AdditionalOption} -R -q --databases ${lvsqw_DbName}' export gvsqw_RsyncDefaultSourceDir='$HOME/mys_dump/$MYSQL_SID' export gvsqw_DropDb=Enable export gvsqw_CreateDb=Enable export gvsqw_RootXtraBackup='$HOME/XtraBackup/$MYSQL_SID' export gvsqw_RootXtraBackupSource='$HOME/XtraBackup/$lvsqw_InstanceSource' export gvsqw_XtraBackupNbGeneration=2 export gvsqw_XtraBackupWaitTimeOut=900 export gvsqw_RootMariaBackup='$HOME/MariaBackup/$MYSQL_SID' export gvsqw_RootMariaBackupSource='$HOME/MariaBackup/$lvsqw_InstanceSource' export gvsqw_MariaBackupNbGeneration=2 export gvsqw_MariaBackupWaitTimeOut=900 export gvsqw_LocalSlowQuery=no #export gvsqw_ForcedReturnCodeScript_sqwmys_DumpDatabase=0 #export gvsqw_WebDbaDirSlowQuery='Directory to store SlowQuery files'
Explication des variables:
gvsqw_ConnectString => gvsqw_ConsistentInnoDb => gvsqw_ConsistentOthers => gvsqw_CreateDb => gvsqw_DbAlias => gvsqw_DbaUser => gvsqw_DefCopyDumpNbGeneration => gvsqw_DistConnectString => gvsqw_DropDb => gvsqw_DumpCompressorExt => gvsqw_DumpNbGeneration => gvsqw_ExcludeDatabasesCopy => #gvsqw_ForcedReturnCodeScript_sqwmys_DumpDatabase => gvsqw_GenExcludeDatabasesObjects => gvsqw_GenExcludeDatabasesObjectsExtra => #gvsqw_GenExcludeDatabasesWhereClause => gvsqw_GenExcludeDatabasesWhereClause => gvsqw_LocalSlowQuery => gvsqw_MariaBackupNbGeneration => gvsqw_MariaBackupWaitTimeOut => gvsqw_MysqlDumpOpt => gvsqw_MysqlSock => gvsqw_MysqlSock => gvsqw_MysqlSock => gvsqw_MysqlSock => gvsqw_MysqlSock => gvsqw_MysqlSock => gvsqw_MysqlSock => gvsqw_MysqlSock => gvsqw_MysqlSock => gvsqw_NbThreadAnalyze => gvsqw_NbThreadCheck => gvsqw_NbThreadCopyDump => gvsqw_NbThreadDump => gvsqw_NbThreadOptimize => gvsqw_NbThreadRestore => gvsqw_NotMysqldumpErrorMsg => gvsqw_NotMysqlErrorMsg => gvsqw_RootAdmin => gvsqw_RootAdminDisable => gvsqw_RootAdminDist => gvsqw_RootCfg => gvsqw_RootDbf => gvsqw_RootDump => gvsqw_RootDumpSource => gvsqw_RootMariaBackup => gvsqw_RootMariaBackupSource => gvsqw_RootXtraBackup => gvsqw_RootXtraBackupSource => gvsqw_RsyncDefaultSourceDir => gvsqw_SizeMinTableIndicators => gvsqw_SqwVersionDbms => gvsqw_SuppArchSlow => #gvsqw_WebDbaDirSlowQuery => gvsqw_XtraBackupNbGeneration => gvsqw_XtraBackupWaitTimeOut =>