SQWareProduction:mysql:etc:sqwmys CreInst Jobs.cfg

Fichier de configuration $gvsqw_MysBin/../etc/sqwmys_CreInst_Jobs.cfg:



Contenu du fichier:

#IndicDba: Gather DBAs indicators
IndicDba:$gvsqw_MysBin/sqwmys_GatherIndicators.ksh -I <MYSQL_SID>

#Dump: backup all databases with mysqlDump
Dump:$gvsqw_MysBin/sqwmys_DumpAllDatabases.ksh -I <MYSQL_SID> -Exec

#Optimize : optimize tables for all databases
Optimize:$gvsqw_MysBin/sqwmys_OptimizeAllDatabases.ksh -I <MYSQL_SID> -Exec

#Analyse : analyze tables for all databases
Analyze:$gvsqw_MysBin/sqwmys_AnalyzeAllDatabases.ksh -I <MYSQL_SID> -Exec

#XtraFull: Backup full with XtraBackup
XtraFull:$gvsqw_MysBin/sqwmys_XtraBackup.ksh -I <MYSQL_SID> -Type full -Exec

#XtraInc: Backup incremental with XtraBackup
XtraInc:$gvsqw_MysBin/sqwmys_XtraBackup.ksh -I <MYSQL_SID> -Type inc -Exec

#SlowQuery: Rotate log slow query
SlowQuery:$gvsqw_MysBin/sqwmys_RotateLogSlowQuery.ksh -I <MYSQL_SID>

#PurgeAlert: Rotate error log
PurgeAlert:$gvsqw_MysBin/sqwmys_PurgeAlert.ksh -I <MYSQL_SID>

#NetBackup: run user backup command
NetBackup:$gvsqw_MysBin/sqwmys_NetBackup.ksh -I <MYSQL_SID> -Policy <Policy> -Schedule  <Schedule> -Exec

#RsyncBackup: run rsync command
RsyncBackup:$gvsqw_MysBin/sqwmys_RsyncBackup.ksh -I <MYSQL_SID> -Exec