Hi Forums,
I’'m trying to setup the master-slave replication by using xtrabackup method. However, when trying to run hot backups and Percona is complaining missing something. Here is complete output.
innobackupex --apply-log /apps/perconabackup/
161220 14:26:27 innobackupex: Starting the apply-log operation
IMPORTANT: Please check that the apply-log run completes successfully.
At the end of a successful apply-log run innobackupex
prints “completed OK!”.
innobackupex version 2.4.5 based on MySQL server 5.7.13 Linux (x86_64) (revision id: e41c0be)
xtrabackup: cd to /apps/perconabackup/
xtrabackup: Error: cannot open ./xtrabackup_checkpoints
xtrabackup: Error: failed to read metadata from ‘./xtrabackup_checkpoints’
here is environment setup:
RHEL 7.0
xtrabackup --version
xtrabackup version 2.4.5 based on MySQL server 5.7.13 Linux (x86_64) (revision id: e41c0be)
mysql -V
mysql Ver 14.14 Distrib 5.7.14-8, for Linux (x86_64) using 6.2
Here are my.cnf options file on the master.
cat /etc/my.cnf
Template my.cnf for PXC
Edit to your requirements.
[client]
socket=/var/lib/mysql/mysql.sock
[mysqld]
server-id=1
datadir=/apps/mysql/datafile
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log_slave_updates
Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
Path to Galera library
wsrep_provider=/usr/lib64/galera3/libgalera_smm.so
Cluster connection URL contains IPs of nodes
#If no IP is found, this implies that a new cluster needs to be created,
#in order to do that you need to bootstrap this node
wsrep_cluster_address=gcomm://
###InnoDB
default_storage_engine=InnoDB
innodb_log_file_size=128M
innodb_flush_method = O_DIRECT
innodb_file_per_table=1
innodb_data_home_dir=/apps/mysql/datafile/
innodb_log_group_home_dir =/apps/mysql/datafile/
Replication and binlogs
binlog_format=ROW
binlog_cache_size = 1M
max_binlog_files=300
max_binlog_size=128M
log_bin=/apps/mysql/logfile/percona1-binary-log
expire_logs_days=3
What is exactly am I missing here?
Your help or instruction is really appreciated.
Thanks,
Silaphet