percona backup

Backup scheme for MySQL database using the Percona-xtrabackup toolNeed to back up the MySQL host 172.16.155.23Host 172.16.155.22 for backup MySQLPurpose: The MySQL database on the 155.23 host is backed up on a daily basis and synchronized to the remote host1. Install the Backup toolYum localinstall-y

Tags: http io ar os using SP for Java StrongOriginal: http://www.drupal001.com/2014/02/percona-xtrabackup-mysql/Xtrabackup IntroductionPercona Xtrabackup is open source free MySQL database hot backup software, it can be InnoDB and XTRADB storage Engine database non-blocking backup (for MyISAM backup also need to add a

PremiseIt should be determined that a single table space is used, otherwise single table backup and recovery is not supported. In the configuration file inside the mysqld section Plusinnodb_file_per_table = 1Environment Description:Main Library: 192.168.0.1From library 1:192.168.0.2From library 2:192.168.0.3Backup utility: Percona xtrabackup version 2.4.8 based on MySQL server 5.7.13 Linux (x86_64) (revisio

RPM Way to install MySQL 5.6 mysql-server-5.6.27-1.el6.x86_64.rpmmysql-client-5.6.27-1.el6.x86_64.rpmMYSQL-SHARED-COMPAT-5.6.27-1.EL6.X86_64.RPM (Perl-dbd-mysql require)2.my.cnf[Email protected] lib]# VI/ETC/MY.CNF# for advice The change settings# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html[Mysqld]DataDir =/var/lib/mysqlLog_bin =/var/lib/mysql/bin-logSocket =/var/lib/mysql/mysql.sockSql_mode=no_engine_substitution,strict_trans_tables3.source Install

Software version:percona-xtrabackup-2.2.10mysql-5.6.23 Xtrabackup Installation 2. full standby and recovery(1) fully preparedView Database[Email protected]]# innobackupex--defaults-file=/etc/my.cnf--user=root--password=123456/bak/mysql/This statement copies the data file ( specified by the variable datadir in my.cnf ) to the backup directory (/bak/mysql/), note: If you do not specify -- Defaults-file, the default value is /etc/my.cnf. af

Tags: Pat ring partial TMP Import Table Percona Backup call PrepareXtrabackup can also implement partial backups, that is, to back up only one or some of the specified databases or some or some of the tables in a database. However, to use this feature, you must enable the innodb_file_per_table option, which is to save each table as a separate file. It also does not support the--stream option, which means th

192.168.31.64:Innobackupex--defaults-file=/data/mysql/3306/etc/my.cnf--user=root--compress--stream=xbstream./| SSH [email protected] "Xbstream-x-c/data/mysql/backup/"192.168.31.65:wget Http://www.quicklz.com/qpress-11-linux-x64.tarTAR-XF Qpress-11-linux-x64.tarLn-s qpress/bin/qpresscd/data/mysql/backup/For f in ' Find/-iname ' *\.QP '; DO/BIN/QPRESS-DT2 $f $ (dirname $f) rm-f $f; DoneInnobackupex--defaults

Backup strategy: Make a full standby every Sunday and make an incremental backup every day. One: Fully-prepared script Cat xtrabackup_full.sh #!/bin/bash Local_ip= "$ (/sbin/ifconfig eth0|grep ' inet addr ' |awk-f: ' {print $} ' |cut-d '-f1)" Email= ' pingping1990429@163.com ' User= ' Root ' Passwd= ' system@123 ' my_config= '/etc/my.cnf ' log=$ (date +%y%m%d%h%m). log str=$ (date +%y%m%d%h%m). tar.gz Backu

production library, you can use the Percona company's online backup tool for backup.Replicate a copy of the MY1.CNF to another location for backup, preventing the upgrade from failing to recover ins1 quickly.3. Close Ins1Mysqladmin-uroot-p-S $sockdir 4. Ins1 the original data directory via MySQL 5.5.36 boot instance, named Ins21) Modify the my1.cnf to change so

Background percona-xtrabackup is a backup tool developed by percona. It has two main tools: xtrabackup and innobackupex. Innobackupex encapsulates xtrabackup and is a perl script. This document is relatively simple. innobackupex is used to back up data of 3306 instances and restore the data. Background percona-xtraback

Percona-toolkit installation and introduction, percona-toolkit MySQL database is one of the best lightweight and open-source databases. Its features, management, and robustness are quite different from those of Oracle. Therefore, there are many powerful third-party derivative products, such as percona-toolkit and XtraBackup.