登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
开源项目 > 数据库相关 > 数据库管理/监控 &&
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
21 Star 75 Fork 21

mo-shan / gfdmp

代码 Issues 1 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。
项目仓库所选许可证以仓库主分支所使用许可证为准
克隆/下载
分支 1
标签 0
贡献代码
同步代码
创建 Pull Request
了解更多
对比差异 通过 Pull Request 同步
同步更新到分支
通过 Pull Request 同步
将会在向当前分支创建一个 Pull
Request，合入后将完成同步
取消
提示: 由于 Git 不支持空文件夾，创建文件夹后会生成空的 .keep 文件
bin
components
conf
function
help
log
README.md
demo.md
link.txt
Loading...
README

gfdmp

项目介绍

MySQL备份/恢复，安装卸载，搭建MGR/半同步集群等自动化工具

本工具提供备份恢复mysql实例等功能：

  • 支持全备。
  • 支持增备。
  • 支持全备恢复，且自动化恢复。
  • 支持全备+增备恢复，且自动化恢复。

安装教程

克隆项目

mkdir -p /data/git
cd /data/git
git clone http://gitlab.mljr.com/shan.mo01/gfdmp.git

拷贝配置文件到/etc

cd gfdmp
cp conf/gfdmp.conf /etc/gfdmp.conf        #/etc/gfdmp.conf是默认的配置文件，建议要存在，否则在执行时没有指定配置文件将出错
cp conf/gfdmp.conf /etc/gfdmp.conf.3332   #这步可选，对于多实例的环境有用，如果是单实例，直接使用/etc/gfdmp.conf即可,本文使用/etc/gfdmp.conf.3332作为demo

更新配置文件

vim /etc/gfdmp.conf.3332                       #根据实际情况编辑哪个配置文件

#请按照实际情况更新，且不要更新conf目录下的配置文件，这样在更新代码时不会出错

配置环境变量

echo "export PATH=/data/git/gfdmp/bin:${PATH}" >> /etc/profile
source /etc/profile

注意事项

  • 如果配置文件的密码是实际的密码，执行的时候请使用 -ep=0，否则将会报错
  • 请确保xtrabackup环境正常，有xtrabackup及其他软件的环境变量
  • 请确保mysql环境正常，有mysql的环境变量

使用说明

执行主程序

#第一次运行时间会比较久，会安装一些依赖程序
#如果没有xtrabackup环境则会安装，请耐心等待
[root@yz-mysql-101-68 conf]# gfdmp 
[2019-09-23 16:33:47] [INFO] Missing the necessary tools[rlwrap]. Check the environment for this OS
[2019-09-23 16:33:52] [INFO] Preparing the environment, please wait...

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
       Management platform info for MySQL
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
         Version: V_3.0
         Author : MoShan
         MySQL  : 5.6 or 5.7
         QQ     : 1005155691
         Mail   : mo_shan@yeah.net

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
         MySQL current version : 5.6
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1.  Backup full data for MySQL
2.  Backup increment data for MySQL
3.  Recover data to MySQL
4.  Recover data to MySQL and Create Replication
5.  Initialization profile
6.  Install MySQL
7.  Uninstall MySQL
8.  Install MySQL and Create MySQL Group Replication
9.  Install MySQL and Create Replication
10. EXIT
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Please ENTER your choice [1-10]:

gfdmp /data/git/gfdmp/conf >

配置定时任务

00 01 * * * /data/git/gfdmp/bin/gfdmp --type=backup --backup-plan=1,5 --backstage --defaults-file=/etc/gfdmp.conf.3332 --threads=10 --debug > /data/git/gfdmp/log/3332_backup.log 2>&1

参数的使用可以参考：gfdmp -h

  • --type 操作类型，可选值有full | increment or incre | recover | recover_repl | install | uninstall | install_mysql_mgr | install_mysql_semi | backup
  • --backup-plan 备份计划，按照星期做全备，要求--type=backup，否则不生效。如上表示周一和周五做全备，其余时间增备，不连续的星期逗号隔开，连续的可用-连接，如1-5表示周一到周五都做全备
  • --backstage 是否放到后台，如果对于大数据量的环境建议使用，否则中途断开很闹心
  • --defaults-file 配置文件，如果不指定配置文件会默认读取/etc/gfdmp.conf，多实例环境可指定
  • --threads= 线程数，是否多线程压缩，解压时也是多线程解压(解密)
  • --debug debug模式，会将备份(恢复)等命令打印到日志

其他使用

单纯备份MySQL

#配置好程序的配置文件后，执行程序，输入 1 即可备份
root ~ >> gfdmp 

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
       Management platform info for MySQL
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
         Version: V_3.0
         Author : MoShan
         MySQL  : 5.6 or 5.7
         QQ     : 1005155691
         Mail   : mo_shan@yeah.net

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
         MySQL current version : 5.7
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1.  Backup full data for MySQL
2.  Backup increment data for MySQL
3.  Recover data to MySQL
4.  Recover data to MySQL and Create Replication
5.  Initialization profile
6.  Install MySQL
7.  Uninstall MySQL
8.  Install MySQL and Create MySQL Group Replication
9.  Install MySQL and Create Replication
10. EXIT
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Please ENTER your choice [1-10]:

gfdmp /root > 1

恢复MySQL

#仅支持用本工具备份
#配置好程序的配置文件后，执行程序，输入 3/4 即可恢复
#如果没有指定--recover-dir= 或者 -rdir=，程序会根据配置文件配置的备份目录，读取最新的一份备份文件进行恢复。
#恢复的实例是根据配置文件配置的mysql_recover_port，MySQL配置文件也是根据配置文件中定义的配置文件（会将端口改成对应需要恢复的端口）
root ~ >> gfdmp 

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
       Management platform info for MySQL
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
         Version: V_3.0
         Author : MoShan
         MySQL  : 5.6 or 5.7
         QQ     : 1005155691
         Mail   : mo_shan@yeah.net

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
         MySQL current version : 5.7
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1.  Backup full data for MySQL
2.  Backup increment data for MySQL
3.  Recover data to MySQL
4.  Recover data to MySQL and Create Replication
5.  Initialization profile
6.  Install MySQL
7.  Uninstall MySQL
8.  Install MySQL and Create MySQL Group Replication
9.  Install MySQL and Create Replication
10. EXIT
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Please ENTER your choice [1-10]:

gfdmp /root > 3

安装MySQL

root /data/mysql/20190904 >> gfdmp -idir=/data/test/mysql -V=5.7 -P=9000 -p=123456789 -t=install

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
      Install info for MySQL on 172.28.85.43
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
      MySQL Version     : 5.7
      MySQL port        : 9000
      MySQL password    : 123456789
      MySQL install dir : /data/test/mysql
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

[2019-09-04 11:57:58] [INFO] [172.28.85.43] Starting install MySQL...
[2019-09-04 11:57:58] [INFO] [172.28.85.43] Decompressing MySQL installation package...
[2019-09-04 11:58:18] [INFO] [172.28.85.43] Decompression successful...
[2019-09-04 11:58:18] [INFO] [172.28.85.43] Initializing for MySQL...
[2019-09-04 11:58:29] [INFO] [172.28.85.43] Initialization successful for MySQL...
[2019-09-04 11:58:29] [INFO] [172.28.85.43] Starting MySQL...
[2019-09-04 11:58:30] [INFO] [172.28.85.43] Successful startup for MySQL
[2019-09-04 11:58:30] [INFO] [172.28.85.43] This old password root@localhost:J7+jeP&KSCdB
[2019-09-04 11:58:30] [INFO] [172.28.85.43] Changing password root@localhost...
[2019-09-04 11:58:40] [INFO] [172.28.85.43] Change password successfully for root@localhost
[2019-09-04 11:58:40] [INFO] [172.28.85.43] The installation is complete for MySQL 5.7!
[2019-09-04 11:58:40] [INFO] [172.28.85.43] This new password root@localhost:123456789


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
172.28.85.43:Operation command information...
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Connect to MySQL : /data/test/mysql/base/bin/mysql -uroot -p"123456789" -S /data/test/mysql/data/9000/mysqld.sock

Shutdown to MySQL: /data/test/mysql/base/bin/mysqladmin -uroot -p"123456789" -S /data/test/mysql/data/9000/mysqld.sock shutdown

Start to MySQL   : bash /data/test/mysql/mysqld_9000

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


root /data/mysql/20190904 >> 



+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
       Management platform info for MySQL
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
         Version: V_3.0
         Author : MoShan
         MySQL  : 5.6 or 5.7
         QQ     : 1005155691
         Mail   : mo_shan@yeah.net

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
         MySQL current version : 5.7
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1.  Backup full data for MySQL
2.  Backup increment data for MySQL
3.  Recover data to MySQL
4.  Recover data to MySQL and Create Replication
5.  Initialization profile
6.  Install MySQL
7.  Uninstall MySQL
8.  Install MySQL and Create MySQL Group Replication
9.  Install MySQL and Create Replication
10. EXIT
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Please ENTER your choice [1-10]:

gfdmp /root > 6

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
      Install info for MySQL on 172.28.85.43
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
      MySQL Version     : 5.7
      MySQL port        : 9298
      MySQL password    : 8697186051567568910
      MySQL install dir : /data/mysql/20190904
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

[2019-09-04 11:48:34] [INFO] [172.28.85.43] Starting install MySQL...
[2019-09-04 11:48:34] [INFO] [172.28.85.43] Decompressing MySQL installation package...
[2019-09-04 11:48:57] [INFO] [172.28.85.43] Decompression successful...
[2019-09-04 11:48:57] [INFO] [172.28.85.43] Initializing for MySQL...
[2019-09-04 11:49:09] [INFO] [172.28.85.43] Initialization successful for MySQL...
[2019-09-04 11:49:09] [INFO] [172.28.85.43] Starting MySQL...
[2019-09-04 11:49:10] [INFO] [172.28.85.43] Successful startup for MySQL
[2019-09-04 11:49:10] [INFO] [172.28.85.43] This old password root@localhost:)fa2_aORAukx
[2019-09-04 11:49:10] [INFO] [172.28.85.43] Changing password root@localhost...
[2019-09-04 11:49:20] [INFO] [172.28.85.43] Change password successfully for root@localhost
[2019-09-04 11:49:20] [INFO] [172.28.85.43] The installation is complete for MySQL 5.7!
[2019-09-04 11:49:20] [INFO] [172.28.85.43] This new password root@localhost:8697186051567568910


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
172.28.85.43:Operation command information...
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Connect to MySQL : /data/mysql/20190904/base/bin/mysql -uroot -p"8697186051567568910" -S /data/mysql/20190904/data/9298/mysqld.sock

Shutdown to MySQL: /data/mysql/20190904/base/bin/mysqladmin -uroot -p"8697186051567568910" -S /data/mysql/20190904/data/9298/mysqld.sock shutdown

Start to MySQL   : bash /data/mysql/20190904/mysqld_9298

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

gfdmp /data/mysql/20190904/base >

卸载MySQL

root /data/mysql/20190904 >> gfdmp -idir=/data/test/mysql -V=5.7 -P=9000 -p=123456789 -t=uninstall

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
      Uninstall info for MySQL on 172.28.85.43
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
      MySQL Version     : 5.7
      MySQL port        : 9000
      MySQL password    : 123456789
      MySQL install dir : /data/test/mysql
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

[2019-09-04 12:03:56] [INFO] [172.28.85.43] Uninstalling for MySQL...
[2019-09-04 12:03:56] [INFO] [172.28.85.43] Uninstallation completed for MySQL 5.7!

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

root /data/mysql/20190904 >>

空文件

Starred
75
Star
75
Fork
21

简介

MySQL备份/恢复，安装卸载，搭建MGR/半同步集群等自动化工具 展开 收起
MySQL
Bash
暂无标签
Shell 等 2 种语言
Shell
97.1%
Roff
2.9%
取消

发行版

暂无发行版

开源评估指数源自 OSS-Compass 评估体系，评估体系围绕以下三个维度对项目展开评估：

1. 开源生态

  • 生产力：来评估开源项目输出软件制品和开源价值的能力。
  • 创新力：用于评估开源软件及其生态系统的多样化程度。
  • 稳健性：用于评估开源项目面对多变的发展环境，抵御内外干扰并自我恢复的能力。

2. 协作、人、软件

  • 协作：代表了开源开发行为中协作的程度和深度。
  • 人：观察开源项目核心人员在开源项目中的影响力，并通过第三方视角考察用户和开发者对开源项目的评价。
  • 软件：从开源项目对外输出的制品评估其价值最终落脚点。也是开源评估最“古老”的主流方向之一“开源软件” 的具体表现。

3. 评估模型

    基于“开源生态”与“协作、人、软件”的维度，找到与该目标直接或间接相关的可量化指标，对开源项目健康与生态进行量化评估，最终形成开源评估指数。

贡献者

全部

近期动态

加载更多
不能加载更多了
Shell
1
https://gitee.com/mo-shan/gfdmp.git
git@gitee.com:mo-shan/gfdmp.git
mo-shan
gfdmp
gfdmp
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部