Difference between revisions of "SQWareProduction:mysql:etc:sqwmys CreInst Jobs.cfg"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 18: | Line 18: | ||
Analyze:$gvsqw_MysBin/sqwmys_AnalyzeAllDatabases.ksh -I <MYSQL_SID> -Exec | 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 | ||
| + | |||
| + | #MariaFull: Backup full with MariaBackup | ||
| + | MariaFull:$gvsqw_MysBin/sqwmys_MariaBackup.ksh -I <MYSQL_SID> -Type full -Exec | ||
| + | |||
| + | #MariaInc: Backup incremental with MariaBackup | ||
| + | MariaInc:$gvsqw_MysBin/sqwmys_MariaBackup.ksh -I <MYSQL_SID> -Type inc -Exec | ||
#PurgeAlert: Rotate error log | #PurgeAlert: Rotate error log | ||
PurgeAlert:$gvsqw_MysBin/sqwmys_PurgeAlert.ksh -I <MYSQL_SID> | 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 | ||
</pre> | </pre> | ||
<br> | <br> | ||
Latest revision as of 21:20, 15 December 2020
Configuration file $gvsqw_MysBin/../etc/sqwmys_CreInst_Jobs.cfg:
File content:
#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 #MariaFull: Backup full with MariaBackup MariaFull:$gvsqw_MysBin/sqwmys_MariaBackup.ksh -I <MYSQL_SID> -Type full -Exec #MariaInc: Backup incremental with MariaBackup MariaInc:$gvsqw_MysBin/sqwmys_MariaBackup.ksh -I <MYSQL_SID> -Type inc -Exec #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
