File mysql-backup.sysconfig of Package mysql-backupscript

Overview Repositories Revisions Requests Users Attributes Meta

File mysql-backup.sysconfig of Package mysql-backupscript (Revision 6326d784af6f7b96277bc79527fe6ac5)

Currently displaying revision 6326d784af6f7b96277bc79527fe6ac5 , Show latest

## Path:    System/Backup
## Description:
## Type:    yesno
## Default: yes
#
# Start backup script.
#
START_BACKUP="yes"

## Type:    string
## Default: /root/backup/db
#
# Place where the database backup files should be 
# stored. The path will be created if it doesn't 
# exist. 
#
BACKUPDIR="/root/backup/mysql"

## Type:    string
## Default: root@localhost
#
# Email address to send errors.
#
EMAIL="root@localhost"

## Type:    string
## Default: /var/log/mysql-backup.log
#
# Logfile
#
LOGFILE="/var/log/mysql-backup.log"

## Type:	integer
## Default: 14
#
# Retention period for storing old backup files.
# Files older than this value in $BACKUPDIR will
# be deleted.
# Set to '0' if you want to store all backups.
#
RETENTION=14

## Type:    yesno
## Default: no
#
# The script can try to repair and optimize the databases/tables
# automatically after a successful backup. It uses mysqlcheck for 
# all databases to do this.
#
OPTIMIZE_DB="no"

## Type:    list(yes,no,skip)
## Default: yes
#
# Should the BACKUPDIR created if it does not exist?
#  yes  : the script will create the backup directory
#  no   : the script will abort and create an Email alert if the
#         backup directory does not exist
#  skip : the script will silently abort - useful if you run a 
#         HA setup for the database
#
CREATE_BACKUPDIR="yes"

## Type:     string
## Default:  /usr/bin/xz
# 
# Which executable should be used to compress the SQL dump files?
# The executable should accept a filename as option on the command
# line - like /usr/bin/bzip2 or /usr/bin/xz
#
# Please check that the executable exists before changing anything
# here. If the file is not executable, the script will still run, 
# but not compress the SQL dump files at all.
#
COMPRESS_EXE='/usr/bin/xz'

## Type:    yesno
## Default: no
#
# Should the compresssion run only after the post dump scripts
# have run. Defaults to "no" to match previous behaviour.
# Please note that this means all database dumps exist uncompressed
# in parallel before compression while the dumps and the post
# dump scripts, usually unlocking the database, are run.
COMPRESS_AFTER_UNLOCK="no"

## Type:    string
## Default: --defaults-extra-file=/root/.my.cnf
#
# Additional options added to each mysql* call. 
# Please note the following binaries are extended with the given options:
# + mysqlcheck
# + mysqladmin
# + mysqldump
# + mysql
# Options given here should be recognized by all the above binaries.
#
MYSQL_OPTS='--defaults-extra-file=/root/.my.cnf'

## Type:    string
## Default: ''
#
# If you need to run extra commands before the real mysqldump starts, 
# please add the full path to your script here.
#
# There are two example scripts in 
#  /usr/share/doc/packages/mysql-backupscript/examples/
# which can be used to stop a classical slave during a backup 
# or allow a Galera node to get temporary out of sync with the 
# rest of the cluster - so the backup can be faster and consistent.
#
MYSQL_SCRIPT_BEFORE_DUMP=''

## Type:    string
## Default: ''
#
# If you need to run extra commands after the real mysqldump finished,
# please add the full path to your script here.
#
# There are two example scripts in
#  /usr/share/doc/packages/mysql-backupscript/examples/
# which can be used to start a classical slave during a backup
# or allow a Galera node to get synced again with the rest of the 
# cluster.
#
MYSQL_SCRIPT_AFTER_DUMP=''

## Type:    yesno
## Default: no
#
# Use NSCA to send messages from the backup to your monitoring.
# Please check/configure the other NSCA values here as well in 
# case you want to use it.
# 
USE_NSCA='no'

## Type:    string
## Default: '/etc/send_nsca.cfg'
#
# The path to the nsca configuration file.
#
SEND_NSCA_CONFIG='/etc/send_nsca.cfg'

## Type:    string
## Default: '/usr/bin/send_nsca'
#
# The path to the nsca binary.
#
SEND_NSCA_BIN='/usr/bin/send_nsca'

## Type:    string
## Default: ''
#
# The hostname used in the NSCA messages. 
# This name needs to be the same as configured in your 
# monitoring server for this machine.
# Fallback is the output of the: 'hostname -s' command.
#
SEND_NSCA_HOSTNAME=''

## Type:    string
## Default: 'localhost'
#
# The hostname of your monitoring server. 
# You can use any resolvable name or IP address here.
# NSCA will try to send messages to this address.
#
NAGIOSHOST='localhost'

## Type:    string
## Default: 'MySQL backup'
# 
# The name of the service, configured on your monitoring server.
# Please make sure that the server name configured here is the same 
# as the one your monitoring server shows in the WebUI. 
# If any of 'SEND_NSCA_HOSTNAME' or 'NAGIOS_SERVICE_NAME' are not 
# identical on both systems, the messages from NSCA will be ignored.
#
NAGIOS_SERVICE_NAME='MySQL backup'

## Type:    yesno
## Default: yes
#
# Use Email to send messages from the backup script. 
# This is enabled by default.
#
USE_EMAIL='yes'

## Type:    string
## Default: 'root@localhost'
#
# The Email address to send notification Emails to.
# Default is 'root@localhost', which in turn normally is aliased
# to your real address via /etc/aliases
#
EMAIL='root@localhost'

## Type:    string
## Default: "--add-drop-database --add-drop-table --add-drop-trigger --apply-slave-statements --default-character-set=utf8mb4 --dump-date --events --extended-insert --flush-logs --flush-privileges --include-master-host-port --master-data --opt --quick --quote-names --routines --single-transaction"
#
# The default options used for mysqldump.
# Please note that these options are optimized for large InnoDB tables.
# For better readability, below are the default options separated by lines:
#     --add-drop-database \
#     --add-drop-table \
#     --add-drop-trigger \
#     --apply-slave-statements \
#     --default-character-set=utf8mb4 \
#     --dump-date \
#     --events \
#     --extended-insert \
#     --flush-logs \
#     --flush-privileges \
#     --include-master-host-port \
#     --master-data \
#     --opt \
#     --quick \
#     --quote-names \
#     --routines \
#     --single-transaction"
#
DUMP_OPTIONS="--add-drop-database --add-drop-table --add-drop-trigger --apply-slave-statements --default-character-set=utf8mb4 --dump-date --events --extended-insert --flush-logs --flush-privileges --include-master-host-port --master-data=2 --opt --quick --quote-names --routines --single-transaction"

Places

File mysql-backup.sysconfig of Package mysql-backupscript (Revision 6326d784af6f7b96277bc79527fe6ac5)

Places