MySQL数据库备份和恢复方案ZRM for MySQL手册中文翻译

longkaty

下面的备份选项可以在全局配置文件和备份组配置文件中指定，所有这些选项是可选的，部分选项有默认值
              目录
      备份参数
      备份组中的数据库/表
      MySQL服务参数
      ZRM参数
      ZRM组件参数

备份参数

backup-level
备份级别指完全备份和增量备份，0代表完全备份，1代表增量备份。默认为0

backup-mode
备份模式指逻辑备份和裸备份，裸备份包含真实的数据库文件，而逻辑备份包含SQL语句（CREATE TABLE,INSERT）列表。逻辑备份恢复时需要重新执行备份的SQL语句，备份的数据可以很容易的移植到不同的系统平台和数据库平台(不是MySQL)。默认为raw。

backup-type
备份类型指正常备份和快速备份，快速备份使用文件系统自己的快照备份，而不从快照卷复制数据。快速备份可以转换为正常备份。可以从快速备份和正常备份恢复数据。

destination
指定MySQL备份数据存放的位置，该参数可选，默认是备份服务器上的/var/lib/mysql-zrm目录。该目录应有足够的空间来存储备份文件，否则备份时会报错。备份用户（通常为root用户）应对该目录具有写权限，并具有创建子目录的权限。

retention-policy
指备份数据保留的时间，可以按天（D），周（W），月（M），年（Y）。一般一个月按30天，一年按365天计算。如：retention-policy为10M，指备份数据将会保留300天。该参数可选，默认保留时间为永远。

compress
该参数值为1表示压缩备份数据，默认为0.默认的压缩程序是gzip（GNU zip）。如果要指定其他的压缩程序，必须用compress-plugin参数指定。

compress-plugin
使用绝对路径指定压缩软件，用来压缩已经备份的数据文件。压缩程序必须支持-d选项来解压缩。只有当compress选项为1时，该选项才有作用。该选项是可选的，默认为gzip程序。

encrypt
需要给备份数据文件加密时，需要使该选项置为1.ZRM for MySQL不支持密钥管理。加密程序必须要在encrypt-plugin选项中以绝对路径指定。默认数据文件不会加密，没有指定默认的加密程序。

encrypt-plugin
使用绝对路径指定加密软件所在的位置。如果encrypt选项设置为1，该选项必须指定。decrypt-option选项也必须指定。

decrypt-option
该选项指定要传递给加密程序的参数，指定解密用到的选项。默认是-d选项，如果是其他选项，或包含多个选项，则要指定多个选项组。

replication
当要备份的数据是MySQL复制结构的从服务器是，该选项为1.这样选项备份数据时，不影响生产库。ZRM for MySQL不能自动创建MySQL从服务器，它必须另外单独设置。

snapshot-plugin
指定执行快照备份的插件程序，默认为lvm-snapshot。该选项可选，裸备份时，使用快照备份必须制定指定该选项。可以为lvm-snapshot或zfs-snapshot。如：/usr/share/mysql-zrm/plugins/lvm-snapshot.pl

snapshot-size（本段不是很理解，贴原文吧。）
ZRM for MySQL can use LVM snapshots to create an internally consistent raw backup of the MySQL database. When specified LVM snapshot are used for all the MySQL databases in the backup set of a logical volume. The value of this field should be size of snapshot volume. Ensure that sufficient disk space on the machine hosting LVM databases is available to create the snapshot. Note that during the process of creating the backups the disk space may fall short. LVM stores the snapshot blocks corresponding to the blocks that are modified in the original logical volume in the snapshot volume. If the database is highly active during the backup, many blocks will be modified and snapshot volume may run out of space. Under these circumstances, the backup will not be consistent. The lvm-snapshot option has been deprecated in 2.x releases.
The size of snapshot can have size suffix k for kilobytes, m for megabytes, g for gigabytes or t for terabytes.

comment
MySQL备份的注释，该注释有助于数据库管理员管理备份数据。可以再后续的报表中看到该注释。

tmpdir
以绝对路径指定备份时临时文件的存储位置，包括备份服务器和MySQL数据库服务器上。在备份时，备份服务器和数据库服务器中该目录应有充足的空间；恢复时，备份服务器该目录也要有充足的空间。如果没有设置，默认为/tmp目录。

备份组中的数据库/表

备份时，可以指定单个或多个数据库/表。如果没有指定，默认为所有的数据库。

all-databases
如果要备份所有的数据库，该选项应设置为1。

databases
用空格隔开列出要备份的多个数据库，

database
该选项仅指定一个要备份的数据库。选项tables列出的数据表应属于该数据库。

tables
用空格隔开列出备份组中要备份的多个数据表，所有的数据表应属于database选项指定的数据库。要使该选项起作用，必须开启database选项。ZRM for MySQL不会验证数据表是否属于database选项指定的数据库，当在数据库中找不到相应的表时，备份将会失败。

MySQL服务参数

user
Mysql用户，用于ZRM for MySQL备份和还原。该用户应具有足够的备份及还原权限。参考MySQL备份用户了解更多的信息。如果该选项没有指定，会从my.cnf配置文件读取。

password
指定MySQL备份用户的登录密码。密码为明文，所有保证该配置文件的安全。如果该选项没有指定，会从my.cnf配置文件读取

host
指定将要备份的MySQL数据库服务器。如果该选项没有指定，会从my.cnf配置文件读取

port
MySQL连接端口，该选项可选，默认为3306。

socket
指定连接MySQL数据库的套接字接口，该选项可选。如：/var/lib/mysql/mysql.sock

ssl-options
连接MySQL服务器的SSL选项。要使用该选项要求MySQL服务器启用了SSL。该选项只有逻辑备份时使用。如：

1. ssl-options="--ssl --ssl-ca=<mysql_conf_dir>/openssl/cacert.pem --ssl-cert=<mysql_conf_dir>/openssl/client-cert.pem --ssl-key=<mysql_conf_dir>/openssl/client-key.pem"

复制代码

routines
逻辑备份时，启用该选项可以备份存储过程。默认不启用。

default-character-set
逻辑备份时，该选项指定备份字符集。默认为utf-8

mysql-binpath
MySQL命令所在目录。该选项为可选的。当MySQL命令不在/usr/bin目录下时，需要指定。默认按以下顺序搜索：/usr/bin:/usr/sbin:/sbin:/bin:/usr/ucb

mysql-binlog-path
MySQL二进制文件所在目录。在增量备份时，需要启用二进制日志。该选项为可选，默认为/var/lib/mysql目录。
ZRM程序参数

verbose
启用冗长的日志输出，可以为0（精简）或1（冗长）。ZRM for MySQL日志文件一般为/var/log/mysql-zrm/mysql-zrm.log

mailto
在执行完备份命令后，会发送邮件到该邮件地址。一般为数据库管理员的邮件。该选项可选。

html-reports
在备份完成后，输出的预定义的备份报表。该选项只有在指定了html-report-directory或webserver-url选项时才起作用。如果该选项没有起用，会产生预定义报表backup-status-info。可以用逗号（，）分隔指定多个预定义报表。

html-report-directory
在备份服务器上指定备份报表的输出目录。指定该目录后，备份报表会在每次备份后自动产生。html格式的报表将创建在html子目录，txt格式的报表将创建在txt子目录中。该参数同样作用于mysql-zrm-report命令的-o选项。如果没有指定该参数，将会在当前工作目录创建报表目录。该参数和邮件通知参数无冲突。

webserver-url
定义访问html报表和RSS feed的URL。要使备份报表的RSS feed起作用，就必须定义rss-header-location参数。若前面启用的html-reports参数，则相应的报表就会产生。同时需要保证html-report-directory目录必须能被web服务器访问。如：http://www.lazysa.com/reports/html

rss-header-location
用于指定rss所用的header文件，用户可以自定义该文件。有个模版头文件：/usr/share/mysql-zrm/plugins/RSS.header

ZRM组件参数

所有的组件都是可选的。

copy-plugin
以绝对路径定义复制组件，该组件用于在备份服务器和MySQL服务器直接互相传输文件。下面的情况需要使用该组件
    1.远程增量备份
    2.从远程服务器复制MySQL从服务器数据文件
    3.执行mysqlhotcopy时，从远程复制数据
    4.恢复数据到远程的MySQL数据库

ssh-user
定义使用SSH登录的用户，该选项只作用于ssh-copy.pl组件。MySQL服务应该也以该用户运行。该选项可选，默认为mysql用户。

remote-mysql-binpath
指定远程MySQL服务器上mysql命令所在目录。如：/opt/lampp/bin。该选项只作用于ssh-copy.pl和socket-copy.pl组件。如果没有指定，默认为/usr/bin

socket-remote-port
socket-copy.pl组件将要使用的服务端口。该选项只作用于socket-copy.pl组件。该选项可选，默认为端口25300.

passfile
GPG加密要用的短语密码。支持GPG加密的组件为：/usr/share/mysql-zrm/plugins/encrypt.pl

pre-backup-plugin
备份前要执行的脚本组件，该组件在每次备份前执行。在/usr/share/mysql-zrm/plugins目录中有一个预执行脚本组件的模版。

pre-backup-plugin-options
要传递到预执行组件的多个参数，用双引号指定。

post-backup-plugin
备份后要执行的脚本组件，该组件在每次备份后执行。在/usr/share/mysql-zrm/plugins目录中有一个后执行脚本组件的模版。

post-backup-plugin-options
要传递到后执行组件的多个参数，用双引号指定。

pre-scheduler-plugin
指定备份命令执行的时间，可以用该组件定义要延迟或跳过的备份命令，或者指定备份命令执行的条件，如服务器/某一程序开启时。

中文项目主页：http://www.lazysa.com/zrm-for-mysql

[ 本帖最后由 longkaty 于 2009-9-20 23:22 编辑 ]

longkaty

MySQL数据库备份和恢复方案ZRM for MySQL手册中文翻译–默认参数值


选项默认值 comment (No default value) backup-level 0 destination /var/lib/mysql-zrm retention-policy Retain for ever backup-mode raw backup-type regular snapshot-plugin "/usr/share/mysql-zrm/plugins/lvm-snapshot.pl" snapshot-size (No Default value) replication 0 compress 0 compress-plugin /usr/bin/gzip compress-mysqldump-onthefly 0 encrypt 0 encrypt-plugin (No default value) decrypt -d synchronous-checksum1 tmpdir /tmp all-databases 1 databases (No default value) database (No default value) tables (No default value) user (No default value) password (No default value) host localhost port 3306 socket /var/lib/mysql/mysql.sock ssl-options (No default value) routines 0 default-character-set utf8 mysql-binpath /usr/bin mysql-binlogpath /var/lib/mysql verbose 0 mailto root@localhost html-reports (No default value) html-report-directory (No default value) webserver-url (No default value) rss-header-location (No default value) copy-plugin (No default value) ssh-user mysql remote-mysql-binpath /usr/bin socket-remote-port 25300 pre-backup-plugin (No default value) pre-backup-plugin-options (No default value) post-backup-plugin (No default value) post-backup-plugin-options (No default value) pre-scheduler-plugin (No default value)


中文项目主页：http://www.lazysa.com/zrm-for-mysql

[ 本帖最后由 longkaty 于 2009-9-20 23:44 编辑 ]

longkaty

MySQL数据库备份和恢复方案ZRM for MySQL手册中文翻译-配置实例

             目录
    服务器配置
    备份要求
    ZRM for MySQL配置
           全局配置文件
           备份组一配置文件
           备份组二配置文件

服务器配置

• 二个MySQL服务器分布运行于host1.company.com 和 host2.company.com
• ZRM for MySQL安装在host1.company.com上
• mysql用户在二台服务器之间做好信任关系。（ssh）

备份要求

• 在服务器host1.company.com上的所有数据库需要裸备份
• 在服务器host2.company.com上的二个数据库（DB1和DB2）需要逻辑备份
• 备份时对北方数据进行压缩
• 用mysql用户进行MySQL数据库备份

ZRM forMySQL配置
要完成上面的备份要求，需要创建二个备份组

• host_1_backup_set
• host_2_backup-set

我们会用一个全局配置文件配置二个备份组共同的参数
     全局配置文件
全局配置文件/etc/mysql-zrm/mysql-zrm.conf包含如下参数：

1. compress=1
   
2. user=mysql
   
3. password=abcd123

复制代码

备份组host_1_backup_set配置文件
备份组host_1_backup_set配置文件/etc/mysql-zrm/host_1_backup_set/mysql-zrm.conf包含如下参数：

1. backup-mode=raw

复制代码

备份组host_2_backup_set配置文件
备份组host_2_backup_set配置文件/etc/mysql-zrm/host_2_backup_set/mysql-zrm.conf 包含如下参数：

1. host=host2.company.com
   
2. backup-mode=logical
   
3. databases="db1 db2"
   
4. copy-plugin="/usr/share/mysql-zrm/plugins/ssh-plugin.pl

复制代码

中文项目主页：http://www.lazysa.com/zrm-for-mysql

[ 本帖最后由 longkaty 于 2009-9-24 20:51 编辑 ]

longkaty

MySQL数据库备份和恢复方案ZRM for MySQL手册中文翻译-mysql-zrm.conf样本

配置文件mysql-zrm.conf可以设置ZRM for MySQL备份的选项。默认的配置文件为：/etc/mysql-zrm/mysql-zrm.conf
配置ZRM for MySQL备份选项包括如下三个步骤：

• 评估当前的备份环境和备份需求，这些将决定需要备份那些数据库/表、是否要压缩/加密备份等。请参考“要备份什么”了解更多信息。
• 在配置文件，取消注释你要使用的备份选项。复制修改后的配置文件作为全局配置文件或者备份组配置文件。如此使用不同的备份选项多次运行备份命令，如完全备份/增量备份，裸备份/逻辑备份，压缩等等。最后形成最优化的适合自己的备份要求的选项。
• 使用备份报表获取各种备份指标，如备份大小、备份时间、读锁时间、写锁时间等。最后确定自己的备份选项。

带注释的配置文件实例：

分段描述不同的备份选项。

1. #
   
2. # Template for Zmanda Recovery Manager for MySQL configuration file
   
3. #
   
4. # Copy Global configuration file to /etc/mysql-zrm/mysql-zrm.conf
   
5. #
   
6. # If backup set specific options are required.
   
7. # The file should be copied to /etc/mysql-zrm/<backup set name>/mysql-zrm.conf
   
8. #
   
9. # MySQL ZRM configuration file describes the backup configuration for
   
10. # a backup set. This file is organized into five sections for convenience
    
11. # - Backup parameters,
    
12. # - Databases/tables that are part of backup set,
    
13. # - MySQL server parameters
    
14. # - ZRM parameters.
    
15. # - ZRM plugin parameters.
    
16. #
    
17. # For more information about Zmanda Recovery Manager for MySQL, please
    
18. # see mysql-zrm(1) and/or Administration manual at
    
19. # http://mysqlbackup.zmanda.com
    
20. #
    
21. # Any line starting with '#' are comments and will be ignored
    
22. #

复制代码

Backup parameters部分决定怎么备份，包括压缩、加密、备份目录、备份保留策略等。

1. # Backup parameters
   
2. #
   
3. # Backup comment. This is a text string which can be retrieved
   
4. # using the mysql-zrm-reporter(1) tool. You can store some notes
   
5. # about the backup set.
   
6. # This parameter is optional and has no defaults.
   
7. # comment=This is a comment
   
8. #
   
9. # Backup Level. It can be full or incremental
   
10. # Use 0 for full and 1 for incremental backups
    
11. # This parameter is optional and default value is full backup.
    
12. # backup-level=0
    
13. #
    
14. # Backup method
    
15. # Values can be "raw" or "logical". Logical backup are backups using
    
16. # mysqldump(1) tool
    
17. # This parameter is optional and default value is "raw".
    
18. # backup-mode=raw
    
19. #
    
20. # Backup type
    
21. # Specifies the type of backup. Values can be "regular" or "quick".
    
22. # Quick backup type uses the snapshot itself as the backup
    
23. # without copying the data from the snapshot volume
    
24. # backup-type=quick
    
25. #
    
26. # Size of LVM snapshot.
    
27. # This parameter is optional and is required only
    
28. # for "raw" backup-mode and if the MySQL database data are stored in
    
29. # LVM logical volumes.
    
30. # A size suffix of k for kilobyte, m for megabyte, g for gigabyte
    
31. # or t for terabyte
    
32. # snapshot-size=10M
    
33. #
    
34. # snapshot-plugin="/usr/share/mysql-zrm/plugins/lvm-snapshot.pl"
    
35. #
    
36. # Directory to which backups are done. All backups are stored under this
    
37. # directory. This parameter is optional and the default
    
38. # value is "/var/lib/mysql-zrm"
    
39. # destination=/var/lib/mysql-zrm
    
40. #
    
41. # Directory to use for temporary storage. This parameter is optional
    
42. #tmpdir=/tmp
    
43. #
    
44. # Retention:
    
45. # Specifies how long the backup should be retained. The value can be
    
46. # specified in days (suffix D), weeks (suffix: W), months (suffix: M) or
    
47. # years (suffix Y). 30 days in a month and 365 days in a year are assumed
    
48. # This parameter is optional and the default is the backups are retained
    
49. # forever.
    
50. # retention-policy=10W
    
51. #
    
52. # Replication
    
53. # This parameter should be set to 1 if MySQL ZRM backups are being on done on a
    
54. # MySQL replication slave.
    
55. # replication=1
    
56. #
    
57. # Compress
    
58. # This parameter should be set to 1 if backups should be compressed. If this
    
59. # parameter is set, gzip(1) command is used by default. If different
    
60. # compression algorithm should be used, it must be set in "compress-plugin"
    
61. # parameter. Default: There is no data compression.
    
62. # compress=1
    
63. #
    
64. # Compression Utility
    
65. # This specifies the program to be used for compression. The "compression"
    
66. # parameter must be set for this parameter to be used. The compression
    
67. # command should also support -d option for uncompress backup images. If
    
68. # value is not specified then gzip(1) is used for compression.
    
69. # compress-plugin=/usr/bin/gzip
    
70. #
    
71. # Encrypt
    
72. # This parameter should be set to 1 if backups should be encrypted.
    
73. # The "encrypt-plugin" parameter must be configured. Default: There is no
    
74. # data encryption.
    
75. # encrypt=1
    
76. #
    
77. # Encryption Utility
    
78. # This parameter specifies that the program that should be used for
    
79. # backup data encryption. "decrypt-option" parameter should also be specified.
    
80. # encrypt-plugin="/usr/share/mysql-zrm/plugins/encrypt.pl"
    
81. #
    
82. # Decryption Options
    
83. # This specifies the option to be passed to the encryption
    
84. # program specified as "encrypt-plugin" parameter for decryption.
    
85. # decrypt-option="-d"

复制代码

Databases/Tables部分指定要备份的数据库/表

1. # Databases/Tables in the backup set
   
2. # One of the "all-databases" or "databases" or "tables"/"database" parameters
   
3. # should be specified. If none of the them are specified, "all-databases"
   
4. # is assumed.
   
5. #
   
6. # This parameter should be set to 1 if all databases are part of this backup set
   
7. #all-databases=1
   
8. #
   
9. #
   
10. # List of databases that are part of this backup set. Multiple database
    
11. # names are separated by space character. This parameter is ignored if
    
12. # "all-databases" is set 1.
    
13. #databases=wikidb forums
    
14. #
    
15. #
    
16. # List of specific tables that are part of this backup set. This parameter
    
17. # should not be specified if all tables in the databases in "databases"
    
18. # parameter are part of the backup set. Multiple table names should be
    
19. # separated by space character. The database to which these tables belong
    
20. # to should be specified in "database" parameter.
    
21. #tables=text user page
    
22. #
    
23. #database="wikidb"

复制代码

MySQL server parameters指定MySQL数据库服务器的选项

1. 
   
2. # MySQL server parameters
   
3. # MySQL database user used for backup and recovery of the backup set.
   
4. # This parameter is optional. If this parameter is not specified, values from
   
5. # my.cnf configuration file.
   
6. #user="wikiuser"
   
7. #
   
8. # MySQL database user password.
   
9. # This parameter is optional. If this parameter is not specified, values from
   
10. # my.cnf configuration file or no password is used.
    
11. #password="userwiki"
    
12. #
    
13. # Fully qualified domain name of the MySQL server.
    
14. # This parameter is optional. If this parameter is not specified, values from
    
15. # my.cnf configuration file.
    
16. #host="localhost.company.com"
    
17. #
    
18. # Port to which the MySQL server is listening to. This parameter is optional
    
19. # and default value is 3306
    
20. #port=3306
    
21. #
    
22. #Name of Socket file that can be used for connecting to MySQL
    
23. #socket=/var/lib/mysql/mysql.sock
    
24. #
    
25. # ssl-options are arguments that are passed to MySQL client commands
    
26. # for SSL connection to the MySQL server. This parameter is optional and is
    
27. # required only if MySQL server allows SSL connections.
    
28. #ssl-options="--ssl --ssl-ca=file1 --ssl-cert=file2 --ssl-key=file3"
    
29. #
    
30. # This can be set to specify that mysqldump should dump stored routines also. This paramter is optional and
    
31. # the default is that stored routines are not dumped mysqldump
    
32. #routines=1
    
33. #
    
34. # This can be used to specif the character set name that mysqldump should use as default. This parameter
    
35. # is optional. If not specified utf8 is used as the default character set.
    
36. #default-character-set=utf8
    
37. #
    
38. # Directory where MySQL commands can be found. The parameter is optional.
    
39. #mysql-binpath="/opt/lampp/bin"
    
40. #
    
41. # Directory where MySQL binary logs can be found. The parameter is optional.
    
42. #mysql-binlog-path="/var/log/mysql"
    
43. #

复制代码

ZRM parameters指定备份输出信息、备份管理员邮件和备份报表和RSS信息等。

1. 
   
2. #
   
3. # ZRM parameters
   
4. #
   
5. # This parameter controls the verbosity of MySQL ZRM logging. The MySQL ZRM logs
   
6. # are available at /var/log/mysql-zrm/mysql-zrm.log. This parameter is optional
   
7. # default value is 0 (less verbose).
   
8. # The valid values are 0 and 1
   
9. #verbose=1
   
10. #
    
11. # Mailto Address
    
12. # After a backup run the backup report is emailed to the mailto address
    
13. # This parameter is optional and default behavior is not to send mail
    
14. # notifications.
    
15. #mailto="root@localhost"
    
16. #
    
17. # The list of backup reports that are generated after each backup run if
    
18. # "html-report-directory" parameter is specified.
    
19. # If this parameter is not specified, "backup-status-info" report is generated.
    
20. # Valid report names are : backup-method-info, backup-status-info,
    
21. # backup-retention-info, backup-performance-info,
    
22. # restore-full-info, restore-incr-info,
    
23. # replication-info, backup-app-performance-info
    
24. # See mysql-zrm-reporter(1) for details of backup reports.
    
25. # Multiple report names should be separated by ",".
    
26. #html-reports=backup-status-info
    
27. #
    
28. # Directory in which Text/HTML reports will be created by mysql-zrm-reporter(1)
    
29. # tool. If this parameter is specified, the mysql-zrm-reporter(1) creates the
    
30. # backup reports in this directory after each successful or unsuccessful
    
31. # backup run.
    
32. # Text reports will be created under "text" sub-directory
    
33. # HTML reports will be created under "html" sub-directory
    
34. #html-report-directory=/var/www/mysql-zrm/reports/
    
35. #
    
36. #
    
37. # If backup reports are required as RSS feed, "webserver-url" parameter must
    
38. # be specified. The value must be set to a valid location on the web server
    
39. # in which HTML reports are located and that URL can be used by
    
40. # administrator/user to browse HTML reports and can get to the RSS feeds.
    
41. # If this parameter is not specified, backup reports are not generated as
    
42. # RSS feeds. The list of reports that are available as RSS feed is specified
    
43. # in "html-reports".
    
44. #webserver-url=http://www.company.com/reports/html/
    
45. #
    
46. # Location of RSS header file. Administrators can customize RSS channel
    
47. # properties using this file. A template for RSS header is available in
    
48. # /usr/share/mysql-zrm/plugins/RSS.header file. Location of RSS header
    
49. # must be provided if "webserver-url" is specified.
    
50. #rss-header-location=/etc/mysql-zrm/
    
51. #

复制代码

ZRM plugin parameters部分指定与备份相关插件的选项。

1. 
   
2. #
   
3. # ZRM plugin parameters.
   
4. # ZRM provides plugin interfaces to allow MySQL administrators to customize
   
5. # the backup to their environment.
   
6. #
   
7. # COPY plugin: Only one copy-plugin must be configured for a backup set.
   
8. #
   
9. # Socket Copy plugin is to used to transfer backup files from MySQL server to
   
10. # the machine running ZRM for MySQL with sockets.
    
11. #
    
12. # Please read the Notes at /usr/share/doc/mysql-zrm/README-plugin-socket-copy
    
13. #
    
14. #copy-plugin=/usr/share/mysql-zrm/plugins/socket-copy.pl
    
15. #
    
16. # SSH Copy plugin is to used to transfer backup files from MySQL server to
    
17. # the machine running ZRM for MySQL with ssh
    
18. #
    
19. # Please read the Notes at /usr/share/doc/mysql-zrm/README-plugin-ssh-copy
    
20. #
    
21. #copy-plugin=/usr/share/mysql-zrm/plugins/ssh-copy.pl
    
22. #
    
23. # PRE-BACKUP plugin: Plugin that will be called before a backup run for
    
24. # the backup set.
    
25. #pre-backup-plugin="/usr/share/mysql-zrm/plugins/pre-backup.pl"
    
26. #
    
27. # Set of parameters passed to the pre-backup-plugin. These parameters are
    
28. # passed to "pre-backup-plugin" before a backup run for the backup set.
    
29. # "pre-backup-plugin" parameter must be specified.
    
30. #pre-backup-plugin-options="option1 option2"
    
31. #
    
32. # POST-BACKUP plugin: Plugin that will be called after a backup run for
    
33. # the backup set.
    
34. #post-backup-plugin="/usr/share/mysql-zrm/plugins/post-backup.pl"
    
35. #
    
36. # Set of parameters passed to the post-backup-plugin. These parameters are
    
37. # passed to "post-backup-plugin" after a backup run for the backup set.
    
38. # "post-backup-plugin" parameter must be specified.
    
39. #post-backup-plugin-options="option1 option2"
    
40. #
    
41. # PRE-SCHEDULER plugin: Plugin that can be used to dynamically determine the
    
42. # start time for a backup run.
    
43. #pre-scheduler-plugin="/usr/share/mysql-zrm/plugins/pre-scheduler.pl"
    
44. #
    
45. # ZRM Plugin configuration parameters
    
46. #
    
47. # This parameter is used by the encrypt plugin and
    
48. # specifies the file containing the passphrase.
    
49. #passfile="/tmp/a.pass"
    
50. #
    
51. # This parameter is used by ssh-plugin.pl plugin to specify the user to be
    
52. # used to ssh to the remote host
    
53. #ssh-user="root"
    
54. #
    
55. # This parameter is used by the ssh-copy.pl and socket-copy.pl plugins
    
56. # to specify the location of mysql client binaries on the remote host.
    
57. #remote-mysql-binpath="/usr/bin"
    
58. #
    
59. # This parameter is used by the socket-copy.pl plugin to specify the port
    
60. # to be opened on the remote host.
    
61. #socket-remote-port="25300"

复制代码

中文项目主页：http://www.lazysa.com/zrm-for-mysql

[ 本帖最后由 longkaty 于 2009-9-24 20:51 编辑 ]