mysql5.7的xtrabackup自动备份脚本
#!/usr/bin/python3.6--coding:utf-8--importtimeimportdatetimeimportsubprocessimportrequestsimportjsonimportloggingmy.cnf文件cnf_file="/etc/my.cnf"备份目录backup_dir="/opt/back"dt=time.str
1.规划系统IP地址软件包及安装方式VIPCentOS7.3.161110.3.3.240<master>mysql5.7<rpm>;keepalived-1.3.5-6<yum>10.3.3.99CentOS7.3.161110.3.3.208<slave>mysql5.7<rpm>;keepalived-1.3.5-6<yum&
1.关闭数据:/etc/init.d/mysqlstop2.启动数据库:mysqld_safe--skip-grant-tables&3.登录数据库,插入root用户并设置权限:mysql//无密码登录mysql>usemysqlmysql>insertintousersetuser='root',ssl_cipher='',x509_issue
1.全库备:#!/bin/bash#name:fulllibrarybackup#backupdirectoryback_Dir=date+%Y-%m-%d#createbackupdirectmkdir/opt/$back_Dir#definitionbackuppathback_path=/opt/$back_Dir#definitionbackupcommandcommand=whichmy
##############################################################建备份用户:createuser'backuser'@'localhost'identifiedby'itsecu@890';grantbackup,select,insert,update,delete,createonDCO
mysql备份脚本,且只保留5天的数据
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号