"Fossies" - the Fresh Open Source Software Archive

Member "etc/mysql-zrm/mysql-zrm.conf" (26 Aug 2013, 11947 Bytes) of package /linux/privat/MySQL-zrm-3.0-release.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) Generic config files source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 #
    2 # Template for Zmanda Recovery Manager for MySQL configuration file 
    3 #
    4 # Global configuration file is /etc/mysql-zrm/mysql-zrm.conf
    5 # The file should be copied to /etc/mysql-zrm/<backup set name>/mysql-zrm.conf 
    6 # if backup set specific modifications are required. 
    7 #
    8 # MySQL ZRM configuration file describes the backup configuration for
    9 # a backup set. This file is organized into five sections for convenience
   10 # - Backup parameters, 
   11 # - Databases/tables that are part of backup set, 
   12 # - MySQL server parameters 
   13 # - ZRM parameters.
   14 # - ZRM plugin parameters.
   15 #
   16 # For more information about Zmanda Recovery Manager for MySQL, please
   17 # see mysql-zrm(1) and/or Administration manual at Zmanda Network.
   18 # 
   19 #
   20 # Any line starting with '#' are comments and will be ignored
   21 
   22 #
   23 # Backup parameters
   24 #
   25 
   26 # Backup comment. This is a text string which can be retrieved 
   27 # using the mysql-zrm-reporter(1) tool. You can store some notes
   28 # about the backup set.
   29 # This parameter is optional and has no defaults.
   30 #comment=This is a comment
   31 
   32 # Backup level. It can be full or incremental
   33 # Use 0 for full and 1 for incremental backups
   34 # This parameter is optional and default value is full backup.
   35 #
   36 #backup-level=0
   37 
   38 # Backup method
   39 # Values can be "raw" or "logical". Logical backup are backups using 
   40 # mysqldump(1) tool
   41 # This parameter is optional and default value is "raw".
   42 #
   43 #backup-mode=raw
   44 
   45 # Size of LVM snapshot. This parameter is optional and  is required only 
   46 # for "raw" backup-mode and if the MySQL database data are stored in 
   47 # LVM logical volumes. 
   48 # A size suffix of k for kilobyte, m for megabyte, g for gigabyte 
   49 # or t for terabyte
   50 #
   51 #lvm-snapshot=10M
   52 
   53 # specifies the plugin for snapshot operations
   54 #
   55 #snapshot-plugin="/usr/share/mysql-zrm/plugins/lvm-snapshot.pl"
   56 
   57 # Specifies the type of backup
   58 # Values can be "regular" or "quick". 
   59 # Quick backup type uses the snapshot itself as the backup 
   60 # without copying the data from the snapshot volume
   61 #backup-type=quick
   62 
   63 # Directory to which backups are done. All backups are stored under this
   64 # directory.  This parameter is optional and the default 
   65 # value is "/var/lib/mysql-zrm"
   66 #
   67 #destination=/var/lib/mysql-zrm
   68 
   69 # Specifies how long the backup should be retained. The value can be 
   70 # specified in days (suffix D), weeks (suffix: W), months (suffix: M) or 
   71 # years (suffix Y). 30 days in a month and 365 days in a year are assumed
   72 # This parameter is optional and the default is the backups are retained 
   73 # forever.
   74 # 
   75 #retention-policy=10W
   76 
   77 # This parameter should be set to 1 if MySQL ZRM backups are being on done on a
   78 # MySQL replication slave.
   79 #replication=1
   80 
   81 # This parameter should be set to 1 if backups should be compressed. If this
   82 # parameter is set, gzip(1) command is used by default. If different 
   83 # compression algorithm should be used, it must be set in "compress-plugin"
   84 # parameter. Default: There is no data compression.
   85 #compress=1
   86 
   87 # This specifies the program to be used for compression. The "compression"
   88 # parameter must be set for this parameter to be used. The compression 
   89 # command should also support -d option for uncompress backup images. If 
   90 # value is not specified then gzip(1) is used for compression.
   91 #compress-plugin=/usr/bin/gzip
   92 
   93 # This parameter should be set to 1 if backups should be encrypted. 
   94 # The "encrypt-plugin" parameter must be configured. Default: There is no
   95 # data encryption.
   96 #encrypt=1
   97 
   98 # This parameter specifies that the program that should be used for 
   99 # backup data encryption. "decrypt-option" parameter should also be specified.
  100 #encrypt-plugin="/usr/share/mysql-zrm/plugins/encrypt.pl"
  101 
  102 # This specifies the option to be passed to the encryption 
  103 # program specified as "encrypt-plugin" parameter for decryption.
  104 #decrypt-option="-d"
  105 
  106 #
  107 # Databases/Tables in the backup set
  108 #
  109 # One of the "all-databases" or "databases" or "tables"/"database" parameters
  110 # should be specified. If none of the them are specified, "all-databases" 
  111 # is assumed.
  112 #
  113 
  114 # This parameter should be set to 1 if all databases are part of this backup set
  115 #
  116 #all-databases=1
  117 
  118 # List of databases that are part of this backup set. Multiple database
  119 # names are separated by space character. This parameter is ignored if 
  120 # "all-databases" is set 1.
  121 #
  122 #databases=wikidb forums
  123 
  124 # List of specific tables that are part of this backup set. This parameter 
  125 # should not be specified if all tables in the databases in "databases" 
  126 # parameter are part of the backup set. Multiple table names should be 
  127 # separated by space character. The database to which these tables belong 
  128 # to should be specified in "database" parameter.
  129 #
  130 #tables=text user page
  131 #database="wikidb"
  132 
  133 #
  134 # The list of databases or tables that are excluded from the backup if the 
  135 # database name or table name matches the pattern. Wildcard characters *, ?,
  136 # [, ] are supported. See mysql-zrm-backup man page for details
  137 #
  138 # exclude-pattern=<pattern>
  139 
  140 # MySQL server parameters
  141 #
  142 
  143 # MySQL database user used for backup and recovery of the backup set.
  144 # This parameter is optional. If this parameter is not specified, values from
  145 # my.cnf configuration file.
  146 #
  147 #user="wikiuser"
  148 
  149 # MySQL database user password. 
  150 # This parameter is optional. If this parameter is not specified, values from
  151 # my.cnf configuration file or no password is used.
  152 #
  153 #password="userwiki"
  154 
  155 # Fully qualified domain name of the MySQL server. 
  156 # This parameter is optional. If this parameter is not specified, values from
  157 # my.cnf configuration file.
  158 #
  159 #host="localhost.company.com"
  160 
  161 # Port to which the MySQL server is listening to. This parameter is optional 
  162 # and default value is 3306
  163 #
  164 #port=3306
  165 
  166 #Name of Socket file that can be used for connecting to MySQL
  167 #
  168 #socket=/var/lib/mysql/mysql.sock
  169 
  170 # ssl-options are arguments that are passed to MySQL client commands 
  171 # for SSL connection to the MySQL server. This parameter is optional and is
  172 # required only if MySQL server allows SSL connections.
  173 #
  174 #ssl-options="--ssl --ssl-ca=file1 --ssl-cert=file2 --ssl-key=file3"
  175 
  176 # This can be set to specify that mysqldump should dump stored routines also. 
  177 # This paramter is optional and the default is that stored routines are 
  178 # not dumped my mysqldump
  179 #routines=1
  180 
  181 # This can be set to 0 to specify that the --single-transaction
  182 # should not be used for mysqldump
  183 #single-transaction=0
  184 
  185 
  186 # This can be used to specif the character set name that mysqldump should 
  187 # use as default. This parameter is optional. 
  188 # If not specified utf8 is used as the default character set.
  189 #default-character-set=latin1
  190 
  191 # Directory where MySQL commands can be found. The parameter is optional.
  192 #
  193 #mysql-binpath="/opt/lampp/bin"
  194 
  195 # Directory where MySQL binary logs can be found. The parameter is optional.
  196 #
  197 #mysql-binlog-path="/var/log/mysql"
  198 
  199 # Directory to use for temporary storage. This parameter is optional
  200 #
  201 #tmpdir=/tmp
  202 
  203 #
  204 # ZRM parameters
  205 #
  206 
  207 # This parameter controls the verbosity of MySQL ZRM logging. The MySQL ZRM logs
  208 # are available at /var/log/mysql-zrm/mysql-zrm.log. This parameter is optional 
  209 # default value is 0 (less verbose).
  210 # The valid values are 0 and 1
  211 #
  212 #verbose=1
  213 
  214 # After a backup run the backup report is emailed to the mailto address
  215 # This parameter is optional and default behavior is not to send mail
  216 # notifications.
  217 #
  218 #mailto="mysqldba@company.com"
  219 
  220 # Policy on when the mail should be sent
  221 # Values can be "always", "never" or "only-on-error"
  222 #mail-policy=always
  223 
  224 # The list of backup reports that are generated after each backup run if 
  225 # "html-report-directory" parameter is specified.
  226 # If this parameter is not specified, "backup-status-info" report is generated.
  227 # Valid report names are : backup-method-info, backup-status-info,
  228 #                          backup-retention-info, backup-performance-info,
  229 #                          restore-full-info, restore-incr-info,
  230 #                          replication-info, backup-app-performance-info
  231 # See mysql-zrm-reporter(1) for details of backup reports.
  232 # Multiple report names should be separated by ",".
  233 #
  234 #html-reports=backup-status-info
  235 
  236 # Directory in which Text/HTML reports will be created by mysql-zrm-reporter(1)
  237 # tool. If this parameter is specified, the mysql-zrm-reporter(1) creates the
  238 # backup reports in this directory after each successful or unsuccessful 
  239 # backup run.
  240 # Text reports will be created under "Text" sub-directory
  241 # HTML reports will be created under "Html" sub-directory
  242 #
  243 #html-report-directory=/var/www/mysql-zrm/reports/
  244 
  245 # If backup reports are required as RSS feed, "webserver-url" parameter must
  246 # be specified. The value must be set to a valid location on the web server 
  247 # in which HTML reports are located and that URL can be used by
  248 # administrator/user to browse HTML reports and can get to the RSS feeds.
  249 # If this parameter is not specified, backup reports are not generated as 
  250 # RSS feeds. The list of reports that are available as RSS feed is specified
  251 # in "html-reports".
  252 #
  253 #webserver-url=http://www.company.com/reports/html/
  254 
  255 # Location of RSS header file. Administrators can customize RSS channel 
  256 # properties using this file. A template for RSS header is available in
  257 # /usr/share/mysql-zrm/plugins/RSS.header file. Location of RSS header
  258 # must be provided if "webserver-url" is specified.
  259 #
  260 #rss-header-location=/etc/mysql-zrm/
  261 
  262 #
  263 # ZRM plugin parameters. 
  264 # ZRM provides plugin interfaces to allow MySQL administrators to customize 
  265 # the backup to their environment.
  266 #
  267 
  268 # COPY plugin: Only one copy-plugin must be configured for a backup set.
  269 #
  270 # Socket Copy plugin is to used to transfer backup files from MySQL server to
  271 # the machine running ZRM for MySQL with sockets.
  272 #
  273 # Please read the Notes at /usr/share/doc/mysql-zrm/README-plugin-socket-copy
  274 #
  275 #copy-plugin=/usr/share/mysql-zrm/plugins/socket-copy.pl
  276 
  277 # SSH Copy plugin is to used to transfer backup files from MySQL server to
  278 # the machine running ZRM for MySQL with ssh
  279 #
  280 # Please read the Notes at /usr/share/doc/mysql-zrm/README-plugin-ssh-copy
  281 #
  282 #copy-plugin=/usr/share/mysql-zrm/plugins/ssh-copy.pl
  283 
  284 # PRE-BACKUP plugin: Plugin that will be called before a backup run for 
  285 # the backup set.
  286 #pre-backup-plugin="/usr/share/mysql-zrm/plugins/pre-backup.pl"
  287 
  288 # Set of parameters passed to the pre-backup-plugin. These parameters are
  289 # passed to "pre-backup-plugin" before a backup run for the backup set.
  290 # "pre-backup-plugin" parameter must be specified.
  291 #pre-backup-plugin-options="option1 option2"
  292 
  293 # POST-BACKUP plugin: Plugin that will be called after a backup run for 
  294 # the backup set.
  295 #post-backup-plugin="/usr/share/mysql-zrm/plugins/post-backup.pl"
  296 
  297 # Set of parameters passed to the post-backup-plugin. These parameters are
  298 # passed to "post-backup-plugin" after a backup run for the backup set.
  299 # "post-backup-plugin" parameter must be specified.
  300 #post-backup-plugin-options="option1 option2"
  301 
  302 # PRE-SCHEDULER plugin: Plugin that can be used to dynamically determine the 
  303 # start time for a backup run.
  304 #pre-scheduler-plugin="/usr/share/mysql-zrm/plugins/pre-scheduler.pl"
  305 
  306 # ZRM Plugin configuration parameters
  307 
  308 # This parameter is used by the encrypt plugin and 
  309 # specifies the file containing the passphrase.
  310 #passfile="/tmp/a.pass"
  311 
  312 # This parameter is used by ssh-plugin.pl plugin to specify the user to be 
  313 # used to ssh to the  remote host 
  314 #ssh-user="root"
  315 
  316 # This parameter is used by the ssh-copy.pl and socket-copy.pl plugins
  317 # to specify the location of mysql client binaries on the remote host.
  318 #remote-mysql-binpath="/usr/bin"
  319 
  320 # This parameter is used by the socket-copy.pl plugin to specify the port
  321 # to be opened on the remote host.
  322 #socket-remote-port="25300"
  323 
  324 # This parameter is used by the windows-copy.pl plugin to specify the port
  325 # to be opened on the windows machine during backup
  326 #windows-backup-port="10080"
  327 
  328 # This parameter is used by the windows-copy.pl plugin to specify the port
  329 # to be opened on the windows machine during restore
  330 #windows-restore-port="10081"
  331