CentOS7 下 MySQL 5.7.23 & XtraBackup 24 做数据备份(1)——安装软件
2024-10-10 10:21:05
在两台机子上同时操作下面的步骤
首先安装MySQL,从官网下载相对应版本的RPM包
- mysql-community-client-5.7.23-1.el7.x86_64.rpm
- mysql-community-common-5.7.23-1.el7.x86_64.rpm
- mysql-community-libs-5.7.23-1.el7.x86_64.rpm
- mysql-community-libs-compat-5.7.23-1.el7.x86_64.rpm (*解决与XtraBackup安装时,my.cnf冲突问题)
- mysql-community-server-5.7.23-1.el7.x86_64.rpm
一口气把他们全都安上,省的报依赖错误
rpm -ivh mysql-community-client-5.7.23-1.el7.x86_64.rpm mysql-community-common-5.7.23-1.el7.x86_64.rpm mysql-community-libs-5.7.23-1.el7.x86_64.rpm mysql-community-libs-compat-5.7.23-1.el7.x86_64.rpm mysql-community-server-5.7.23-1.el7.x86_64.rpm
初始化MySQL
先修改 /var/lib/mysql/ 文件夹的权限,因为是用root权限安装的,需要修改为mysql的权限。
chown -R mysql.mysql /var/lib/mysql/
初始化MySQL
mysqld --initialize
从mysqld.log中获取初始密码,得到红色部分的密码
[root@localhost srv]# cat /var/log/mysqld.log | grep 'y password'
2018-08-23T05:54:39.866279Z 1 [Note] A temporary password is generated for root@localhost: (WRwAWtoj14+
登录mysql,修改密码
[root@localhost srv]# mysql -uroot -p'(WRwAWtoj14+'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.23 Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> alter user root@localhost identified by 'root';
Query OK, 0 rows affected (0.01 sec) mysql> exit
Bye
至此,MySQL安装完毕
安装XtraBackup
按照官网的安装示例安装即可:https://www.percona.com/doc/percona-xtrabackup/2.4/installation/yum_repo.html
1、安装Percona yum 仓库
yum install http://www.percona.com/downloads/percona-release/redhat/0.1-6/percona-release-0.1-6.noarch.rpm
2、安装XtraBackup 24
yum install percona-xtrabackup-24 -y
会以依赖安装(就是因为依赖总是离线安不上,才用的yum):
作为依赖被安装:
libev.x86_64 0:4.15-7.el7 perl-DBD-MySQL.x86_64 0:4.023-6.el7 perl-Digest.noarch 0:1.17-245.el7
perl-Digest-MD5.x86_64 0:2.52-3.el7 rsync.x86_64 0:3.1.2-4.el7
至此,两个软件安装完毕
上面安装中的一些坑(已经帮助跳过去了):
1、MySQL无法启动,cli下报如下错误
[root@localhost srv]# service mysqld start
Redirecting to /bin/systemctl start mysqld.service
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
/var/log/mysqld.log中报如下错误
2018-08-23T06:08:24.018182Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2018-08-23T06:08:24.018188Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2018-08-23T06:08:24.620670Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2018-08-23T06:08:24.620698Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-08-23T06:08:24.620703Z 0 [ERROR] Failed to initialize builtin plugins.
2018-08-23T06:08:24.620706Z 0 [ERROR] Aborting
解决方法看上面的MySQL初始化部分
2、XtraBackup安装冲突
file /etc/my.cnf from install of Percona-Server-shared-56-5.6.41-rel84.1.el7.x86_64 conflicts with file from package mysql-community-server-5.7.23-1.el7.x86_64
先安装 mysql-community-libs-compat-5.7.23-1.el7.x86_64.rpm 即可
最新文章
- vim修改文字编码
- python2.7 学习笔记--列表的使用
- vc6 使用的那些事
- python pip install mysql-connector-python
- #iPhone6与iPhone6Plus适配#如何在Xcode 6中创建 PCH 文件
- 删除对象中的key
- IP address/地址 检查
- select框默认样式去除(ie中隐藏默认下拉图标)
- QT带OpenGL与不带的区别,QT5是一个伟大的框架,短时期内根本不会有替代者
- BootStrap的菜单的快速创建
- js 弹出 隐藏层和cookie
- 以Tomcat+Mysql为例,实现Docker多容器连接
- Liunx find的运用
- S5PV210中断处理
- 常用的Arrays类和二维数组以及二分法的介绍
- Python内置模块之-hashlib
- js 加减乘除以及四舍五入 新写法
- 工厂类,配置文件,静态方法,反射构成编译器解耦;ioc的一个概念 ;通过xml创建容器里面存储对象
- 如何计算UDP/TCP检验和checksum
- 【java多线程】队列系统之PriorityBlockingQueue源码
热门文章
- 牛客编程巅峰赛S1第6场 - 黄金&;钻石&;王者 C.星球游戏 (单源最短路,Dijkstra)
- 一文带你认识Docker
- k8s二进制部署 - flannel安装
- Python-collections模块之defaultdict
- std::invoke_result的实现详解
- C++ new delete malloc free
- five86-1 (OpenNetadmin RCE+cp命令提权+crunch生成密码字典)
- 二分类问题中混淆矩阵、PR以及AP评估指标
- git merge bug
- CustomEvent &; Event