innodb_fast_checksum not recognized by PS 5.6 but it's in backup-my.cnf
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Invalid
|
Undecided
|
Unassigned |
Bug Description
[root@ip-
uuid = 2d7a6d7f-
name =
tool_name = innobackupex
tool_command = . --no-lock --stream=tar
tool_version = 1.5.1-xtrabackup
ibbackup_version = xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: )
server_version = 5.6.20-68.0-log
start_time = 2014-09-17 13:15:48
end_time = 2014-09-17 13:18:56
lock_time = 0
binlog_pos = filename 'mysqld-
innodb_from_lsn = 0
innodb_to_lsn = 7277989941
partial = N
incremental = N
format = tar
compact = N
compressed = N
encrypted = N
[root@ip-
# This MySQL options file was generated by innobackupex.
# The MySQL server
[mysqld]
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
If we then use the backup-my.cnf settings in the my.cnf on the 'slave', mysql won't start::
2014-09-17 13:39:31 10737 [ERROR] mysqld: unknown variable 'innodb_
2014-09-17 13:39:31 10737 [ERROR] Aborting
Changed in percona-xtrabackup: | |
status: | New → Invalid |
From the docs: http:// www.percona. com/doc/ percona- xtrabackup/ 2.2/xtrabackup- files.html
- backup-my.cnf
This file contains information to start the mini instance of InnoDB during the --apply-log. This is NOT a backup of original my.cnf. The InnoDB configuration is read from the file backup-my.cnf created by innobackupex when the backup was made. innobackupex --apply-log uses InnoDB configuration from backup-my.cnf by default, or from innobackupex --defaults-file, if specified. InnoDB configuration in this context means server variables that affect data format, i.e. innodb_page_size, innodb_ log_block_ size, etc. Location-related variables, like innodb_ log_group_ home_dir or innodb_ data_file_ path are always ignored by innobackupex --apply-log, so preparing a backup always works with data files from the backup directory, rather than any external ones.