percona backup

Deploy Percona XtraDB Cluster in CentOS6 Environment Host planning: 192.168.0.221os6—221192.168.0.222os6—222192.168.0.223os6—223192.168.0.224os6—224haproxy192.168.0.225os6—225haproxyInstallation script:#!/bin/bashsed-i"s/SELINUX=enforcing/SELINUX=disabled/g"/etc/selinux/configsetenforce0serviceiptablesstartiptables-Fiptables-AINPUT-ptcp-ieth0--dport3306-mstate--stateNEW,ESTABLISHED-jACCEPTiptables-AINPUT-ptcp-ieth0--dport4444-mstate--stateNEW,ESTABLIS

, u = root, P = xxx -- print Replace into 'pango _ test '. 'test1' ('id', 'user _ name', 'Password', 'name') values ('8', 'admin8', '123', 'administrator8 ') /* percona-Toolkit src_db: pango_test src_tbl: test1 src_dsn: H = 192.168.10.21, P = ..., U = dump dst_db: pango_test dst_tbl: test1 dst_dsn: H = 192.168.10.22, P = ..., U = dump lock: 1 transaction: 1 changing_src: pango_test.checksums replicate: pango_test.checksums bidirectional: 0 PID: 31773

thisPerlregex--group-by=s Group-bymode:disk,sample,orall (Defaultall) --headers=H ifgroupispresent,eachsamplewillbe separatedbya blankline,unlessthesample isonlyoneline (default group,scroll) - -interval=iwhenininteractivemode, waitNsecondsbeforeprinting tothescreen (default1) --iterations=iwhenininteractivemode,stop afternsamples--sample-time=iin-- group-bysamplemode,includensecondsofsamples pergroup (default1) --save-samples=sFile tosavediskstatssamplesin;thesecanbeusedfor lateranalysis--s

To build the Innodb-tools tool, you need to rely on the C compiler, make tool, and so on. 1, download decompression innodb-tools tool Source: wget https://launchpad.net/percona-data-recovery-tool-for-innodb/trunk/release-0.5/+download/ percona-data-recovery-tool-for-innodb-0.5.tar.gz TAR-ZXVF percona-data-recovery-tool-for-innodb-0.5.tar.gz 2, into the decompr

1. Foreword Reference Http://www.oschina.net/p/haproxyHAProxy,HAProxy provides high availability, load balancing. and proxies based on TCP and HTTP applications to support virtual hosts, which is a free, fast, and reliable solution. Haproxy is especially useful for Web sites that are heavily loaded, which typically require session maintenance or seven-tier processing. Haproxy is running on the current hardware and can support tens of thousands of concurrent connections altogether. and its opera

Check if MySQL Server is installed:Rpm-qa | grep MySQLRpm-qa | grep mariadbDelete method:RPM-E MySQL #普通删除模式Rpm-e--nodeps MySQL #强行删除模式, if you use the above command to delete, prompted to have other dependent files, then use this command can be forcibly deleted.Yum Remove mariadb-libs-5.5.41-2.el7_0.x86_64Note that mariadb also cannot exist, some words to delete the tune, delete when there are dependencies, direct yum uninstall before installing MySQL need to install Perl, and need to data:dump

Tags: mysql optimizer 5.5 5.6First, briefis a free open source database server developed by a company founded by the original MySQL author Michael Widenius. MARIADB, the transaction-based Maria Storage engine, replaces the MySQL MyISAM storage engine, which uses the variant of the Percona Xtradb,innodb. This version also includes the PrimeBase XT (PBXT) and Federatedx storage engines. (Excerpt from: http://baike.baidu.com/view/2521908.htm)Simply put:

PXC Installation 1, PXC installation environment: Cluster Name: Pxc-sky node1:192.168.246.18 node2:192.168.246.19 node3:192.168.246.20 2, shut down the firewall and SELinux #chkconfig iptables off #vi/etc/selinux/config Selinux=disabled #reboot 3. Create MySQL users and Groups All 3 nodes to do [Root@localhost ~]# Groupadd MySQL [Root@localhost ~]# useradd–g mysql–s/sbin/nologin MySQL 4, the main software installation All 3 nodes to do The storage location of the software under/opt/mysql/ Firs

http://blog.itpub.net/28916011/viewspace-1971933/Percona Several graphical explanations for monitoring MySQLRecently, I examined the meaning of several diagrams of Percona monitoring MySQL.COM_XXX indicates the number of times each XXX statement executes as follows:Com_select the number of times a select operation is performed, only one query is cumulative plus 1Com_update number of update operations perfor

First, installation Download https://www.percona.com/downloads/XtraBackup/First download the percona-xtrabackup-24-2.4.4-1.el5.x86_64.rpm, installation report libcurl.so.3 and libev.so.4 can't find, libev.so.3 can pass yum install Libev solve, But libcurl.so.3 by making a soft link (cd/usr/lib64 ln-s libcurl.so.4 libcurl.so.3) or copying a copy from another system cannot be resolved, give up Download perc