从用Percona创建的master备份中还原从
在主binlog上,该备份将在14天内过期,并且此备份的使用时间不到24小时。
my.cnf (主)
expire_logs_days = 14
还原脚本(从)
service mysql stop
rm -r /var/lib/mysql/*
# backup is unzipped into /var/lib/mysql
xtrabackup --prepare --target-dir=/var/lib/mysql
chown -R mysql.mysql /var/lib/mysql
service mysql start
这是我的configmap.yaml文件:
apiVersion: v1
kind: ConfigMap
metadata:
name: mysql
labels:
app: mysql
app.kubernetes.io/name: mysql
data:
primary.cnf: |
# Apply this config only on the primary.
[mysqld]
log-bin
replica.cnf: |
# Apply this config only on replicas.
[mys
从用Percona创建的master备份中还原从
在主binlog上,该备份将在14天内过期,并且此备份的使用时间不到24小时。
my.cnf (主)
expire_logs_days = 14
还原脚本(从)
service mysql stop
rm -r /var/lib/mysql/*
# backup is unzipped into /var/lib/mysql
xtrabackup --prepare --target-dir=/var/lib/mysql
chown -R mysql.mysql /var/lib/mysql
service mysql start
加入新的Percona节点失败:
130521 7:15:44 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (7ff38373-c1d1-11e2-0800-d595d1800e6a): 1 (Operation not permitted)
at galera/src/replicator_str.cpp:prepar
我试图使用Percona XtraBackup进行备份,并获得以下错误:
[root@ads-dev1 ~]# innobackupex /root/db
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2,