使用XtraBackup创建mysql slave

franket

发布于 2022-05-04 22:28:42

1K0

发布于 2022-05-04 22:28:42

文章被收录于专栏：技术杂记技术杂记

前言

XtraBackup 是 percona 出的一款mysql备份工具，可以使用它对mysql进行高效备份

下面分享一下使用 XtraBackup 创建mysql slave的基础操作，详细可以参阅官方文档

Tip: 当前版本 Percona XtraBackup 2.2

概要

准备slave软件环境

下载安装percona repo

[root@slave-test src]# wget  http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm 
--2015-10-12 14:03:35--  http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
Resolving www.percona.com... 74.121.199.234
Connecting to www.percona.com|74.121.199.234|:80... connected.
HTTP request sent, awaiting response... 301 Moved Permanently
Location: https://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm [following]
--2015-10-12 14:03:36--  https://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
Connecting to www.percona.com|74.121.199.234|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 6566 (6.4K) [application/x-redhat-package-manager]
Saving to: “percona-release-0.1-3.noarch.rpm”

100%[===================================================================================================================>] 6,566    

2015-10-12 14:03:37 (115 MB/s) - “percona-release-0.1-3.noarch.rpm” saved [6566/6566]

[root@slave-test src]# ls
percona-release-0.1-3.noarch.rpm
[root@slave-test src]# rpm -ivh percona-release-0.1-3.noarch.rpm 
warning: percona-release-0.1-3.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Preparing...                ########################################### [100%]
   1:percona-release        ########################################### [100%]
[root@slave-test src]#

可以在系统中进行一下检查

[root@slave-test src]# rpm -qlp percona-release-0.1-3.noarch.rpm 
warning: percona-release-0.1-3.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
/etc/pki/rpm-gpg/RPM-GPG-KEY-Percona
/etc/yum.repos.d/percona-release.repo
/usr/share/doc/percona-release-0.1
/usr/share/doc/percona-release-0.1/RPM-GPG-KEY-Percona
[root@slave-test src]# ll /etc/yum.repos.d/percona-release.repo 
-rw-r--r-- 1 root root 2501 Sep 22  2014 /etc/yum.repos.d/percona-release.repo
[root@slave-test src]#

本文系转载，前往查看

如有侵权，请联系 cloudcommunity@tencent.com 删除。

数据库