Action to restore database from the backup is missing
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Percona Cluster Charm |
Triaged
|
Wishlist
|
Unassigned |
Bug Description
Currently the percona-cluster charm supports a "backup" action which can be used to take a backup of the running databases. However, it is missing an option to restore the databases from the backup which is weird. The databases can be restored manually by running the following commands:
innobackupex --apply-log /var/backups/
systemctl stop mysql
mv /var/lib/
mkdir /var/lib/
innobackupex --copy-back /var/backups/
rsync --ignore-existing /var/lib/
chown -R mysql:mysql /var/lib/
chown root:root /var/lib/
systemctl start mysql
I think the consistent solution should have both "backup" and "restore" actions implemented.
Changed in charm-percona-cluster: | |
status: | New → Triaged |
importance: | Undecided → Wishlist |