MySQL日常工具的安装
2024-09-08 18:30:33
安装PT工具
#安装依赖
yum -y install perl-DBI perl-DBD-MySQL perl-Time-HiRes perl-IO-Socket-SSL perl-Digest-MD5
#检查依赖
yum list installed|grep -E "perl-DBI|perl-DBD-MySQL|perl-Time-HiRes|perl-IO-Socket-SSL|perl-Digest-MD5"
#获取toolkit工具包
wget https://downloads.percona.com/downloads/percona-toolkit/3.2.1/binary/redhat/7/x86_64/percona-toolkit-3.2.1-1.el7.x86_64.rpm
#安装toolkit包
rpm -ivh percona-toolkit-3.2.1-1.el7.x86_64.rpm
安装xtrabackup
##安装xtrabackup,percona-xtrabackup 2.4可以兼容MySQL5.6及MySQL5.7,但不兼容mysql8.0,
##percona-xtrabackup 8.0不能兼容MySQL5.6及mysql5.7,但可以兼容mysql8.0
#安装依赖
[root]# wget ftp://fr2.rpmfind.net/linux/dag/redhat/el6/en/x86_64/dag/RPMS/libev-4.15-1.el6.rf.x86_64.rpm && rpm -ivh libev-4.15-1.el6.rf.x86_64.rpm
[root]# yum install perl-DBI perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL perl-Digest-MD5 -y
##所有percona software的各个版本都可以在 ‘ https://www.percona.com/downloads/ ’得到下载,下载并安装xtrabackup
[root]# wget https://downloads.percona.com/downloads/Percona-XtraBackup-2.4/Percona-XtraBackup-2.4.20/binary/redhat/7/x86_64/percona-xtrabackup-24-2.4.20-1.el7.x86_64.rpm \
&& rpm -ivh percona-xtrabackup-24-2.4.20-1.el7.x86_64.rpm
二进制安装xtrabackup
# tar -zxvf percona-xtrabackup-2.4.24-Linux-x86_64.glibc2.12.tar.gz
# mv percona-xtrabackup-2.4.24-Linux-x86_64.glibc2.12 percona-xtrabackup-2.4.24
# ln -s /data/software/percona-xtrabackup-2.4.24/bin/* /usr/bin/
# xtrabackup --version #查看版本,是否安装成功
=======================================================
# cd /usr/bin #进入该目录,删除软链接,相当于卸载
unlink xbcloud
unlink xbcloud_osenv
unlink xbcrypt
unlink xbstream
unlink xtrabackup
安装gocron
# tar -zxvf gocron-node-v1.5.3-linux-amd64.tar.gz
# mv gocron-node-linux-amd64 gocron-node
# nohup /opt/gocron-node/gocron-node --allow-root &
# vi gocron-node.service
[Unit]
Description=gocron-node
Documentation=https://github.com/ouqiang/gocron [Service]
ExecStart=/opt/gocron-node/gocron-node -allow-root
Restart=always
StartLimitInterval=0
RestartSec=10 [Install]
WantedBy=multi-user.target # systemctl daemon-reload
# systemctl enable gocron-node.service
# systemctl list-unit-files | grep -ie gocron-node
最新文章
- ubuntu 解决中文zip乱码问题
- Node黑客开发的10个好习惯(2016)
- PureLayout和Masonry比较
- mysql 的 infobright 数据库的 mediumblob 显示不了数据
- easyui 表单和自定义验证扩展和js自定义返回值
- (转)《深入理解java虚拟机》学习笔记10——并发编程(二)
- (step4.3.5)hdu 1501(Zipper——DFS)
- #Leet Code# Convert Sorted Array to Binary Search Tree
- linux笔记2.21
- php 四种基础算法 ---- 选择排序法
- Vulkan Tutorial 02 编写Vulkan应用程序框架原型
- [C++][OpenGL]自己写GUI(0)——介绍
- Linux(CentOS6.5)下修改Nginx初始化配置
- Vue+Webpack构建移动端京东金融(一、开发前准备)
- openshift pod对外访问网络解析
- Spring Security使用报错 No bean named 'springSecurityFilterChain' is defined
- 洛谷P1823 音乐会的等待
- androidstudio在创建new project时,窗口太大,看不到下面确定按钮的解决方法
- Unity读取Android SDcard文件
- compile——生成ast
热门文章
- C6657子卡模块设计资料:268-基于FMC接口的DSP TMS320C6657子卡模块
- Windows Service调试方法小结
- oracle system 账户被锁或者忘记密码
- Nginx基础篇(一)
- python + unittest + request + parameterized 参数化遇到中文名称testcase不显示的问题
- Win10安装离线.NET3.5流程
- css悬浮动画
- cython并行性能-计算滚动求和 rolling function
- Task :app:lintVitalRelease FAILED
- Ubuntu之root密码重置