percona repo

Percona-toolkit-System Tools 1. pt-diskstats Function introduction: Is an interactive monitoring tool for GUN/LINUX. Usage: Pt-diskstats [OPTION...] [FILES] Print disk io statistics for GUN/LINUX, which is a bit like iostat, but this tool is interactive and more detailed than iostat. Data collected from remote machines can be analyzed. Example: Example 1: view the status of all disks on the local machine: Pt-diskstats Example 2: only view the status o

Tags: tin-o tar usr backup SCP copy default RedoKING02 Install only MySQL 5.6 software no need to build library please refer to "MySQL 5.6 source code compilation installation Record"KING02 Install Xtrabackup, please refer to "MYSQL 5.6 Backup transcript-Percona xtrabackup"[Email protected] ~]# mkdir-p/usr/local/mysql/backup[Email protected] ~]# chown-r mysql/usr/local/mysql/backup[Email protected] ~]# scp/etc/my.cnf [email protected]:/etc[Email prote

Tags: record delete table Inno style rest Time Date Description poiuse third-party tools to back up MySQL-----perconaFirst, pre-preparation work:1, install the dependency package: Yum-y Install PERL-DIGEST-MD5 Perl-dbd-mysqlRPM-IVH libev-4.15-1.el6.rf.x86_64.rpm2. Installation Main package: percona-xtrabackup-24-2.4.7-1.el7.x86_64.rpm3. Contains two components:/usr/bin/xtrabackup: Supports InnoDB and XTRADB (incremental backup)/usr/bin/innobackupex: S

a thrilling Percona XTRA Cluster DB data repair process2014.12.27 noon at about 12:30, the telephone rang, is a colleague Yi's phone, told that there is a large number of deadlock in the library, with "service MySQL restart" can not be restarted. Let me explain here: what we're using in the Mobile music project isPercona XTRA Cluster DB, the recommended minimum is 3 nodes in a build environment. But the mobile mobile machine is strained, causing the d

# Restore a database from a dump. sql fileMysql-h mdbec-db1-u Wpadmin-pwpadminpass wpdb # Percona XtraDB Cluster Start commands/etc/init.d/mysql bootstrap-pxcservice MySQL bootstrap----wsrep-cluster-address=" gcomm://"# Start a PXC node with the specified donorService MySQL start--wsrep_sst_donor=nodec# Reset PasswordSudo/etc/Init.d/MySQL Stopsudo mysqld_safe--Skip-grant-tables Mysql-u rootmysql> UpdateMysql.User SetPassword=Password ("New-Password "

Tags: style blog http color io ar for SP divhttps://tools.percona.com/Follow the prompts on the site to set up a total of 7 steps.# Generated by Percona Configuration Wizard (http://tools.percona.com/) version rel5-20120208# Configuration Name server-dev-binary-1009Generated for#**********@163. com at the-Ten- the Geneva: +:Ten[mysql]# CLIENT #port=3306Socket=/usr/local/mysql/data/mysql.sock[mysqld]# General #user=Mysqldefault-storage-engine =Innodbso

zabbix3.0.4 using Percona-monitoring-plugins plug-ins to monitor the detailed implementation of mysql5.6Because Zabbix's own MySQL monitoring does not provide the key that can be used directly, so generally do not use, the industry's classmates use Percona monitoring Plugins to monitor the way of MySQLPercona has improved MySQL database server, with a significant increase in functionality and performance co

First, the smooth installation# Rpm-qa |grep Percona# netstat-ntlp|grep MySQLTCP 0 0::: 3306:::* LISTEN 2685/mysqld# cd/tmp# lsHsperfdata_hadoop ORBIT-GDM Pulse-pqj5sfdwhlewHsperfdata_root percona-toolkit-2.2.19-1.noarch.rpm PULSE-YGSUAXGYKMIW# RPM-IVH percona-toolkit-2.2.19-1.noarch.rpmWarning:percona-toolkit-2.2.19-1.noarch.rpm:header V4 dsa/sha1 Signature, key

Install and use Xtrabackup from Percona to back up MySQL Install and use Xtrabackup from Percona to back up MySQL 1. Install XtraBackup If it is a 32-bit system, just put the content of xtrabackup0.9.zip in the bin directory of mysql. You can also compile the database together. Take 5.0.88 as an example:First download its source code:Note: It must be compiled with the mysql source code. # Tar zxvf mysq

Percona uses TokuDB Percona's "Getting to know TokuDB for MySQL" article is designed to promote TokuDB, but in fact, it also shows the history of MySQL... As mentioned above, even if you do not use the transaction provided by InnoDB, its crash-safe nature is still one of the important factors for many people to choose InnoDB: Even those that don't really need transactions rejoice in the crash resistance strength of InnoDB. When I mention Toku

Use the official binary installation directly.Https://www.percona.com/doc/percona-xtradb-cluster/5.6/installation.html#installationInnobackupex:This is actually a Perl script package for the following three tools, which can be backed up MyISAM, InnoDB, xtradb tables.Xtrabackup:A binary file compiled from C that can only back up InnoDB and xtradb data.Xbcrypt:The data used to encrypt or decrypt the backup.Xbstream:A compressed file used to decompress o

Percona-toolkit usage tutorial-Performance Tools 1. pt-index-usage Function introduction: Read the plug-in statement from the log file and explain how they use the index. After the analysis is completed, a report about the index that has not been used for query is generated. Usage: Pt-index-usage [OPTION...] [FILE...] You can obtain the SQL directly from the slow query. The SQL format in the FILE must be the same as that in the slow query. If it is no

Use of monitoring tools in percona-toolkit series 1. pt-deadlock-logger Function introduction: Extract and record mysql deadlock Information Usage: Pt-deadlock-logger [OPTION...] SOURCE_DSN Collect and save the latest deadlock information on mysql. You can directly print the deadlock information and store the deadlock information to the database, the deadlock information includes the server where the deadlock occurred, the time when the deadlock occur

Percona-toolkit tutorial tools 1. pt-archiver Function introduction: Archive the records of tables in the mysql database to another table or file Usage: Pt-archiver [OPTION...] -- source DSN -- where WHERE This tool only archives old data and does not significantly affect OLTP query of online data. You can insert the data into other tables on another server or write it into a file, it is convenient to use the load data infile command to import data. Y

Pt-kill is a good kill MySQL connection tool, is a part of Percona Toolkit, in the due to more idle connections cause more than the maximum number of connections, a problem of SQL causes MySQL load is high, you need to kill some connections, This tool is mainly used for this purpose. Obtain a connection that satisfies the condition from show processlist or read the connection that satisfies the condition from the file containing show processlist and

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) (revision id:97330f7)To create a Chenfeng library on

MySQL Server Version:Server version: 5.7.10-log MySQL Community Server (GPL)Percona xtrabackup Version:Innobackupex version 2.4.2 Linux (x86_64) (revision id:8e86a84)Description[Master]: Represents a statement executed on the master library [slave]: Represents a statement executed on the slave library--Perform a master library full-ready[Master]innobackupex--parallel=4/data/backup/full--no-timestamp--Attach the log to the backup [Master]innobackupex--

#!/bin/bashcd/root/softtarzxvfcmake-2.8.5.tar.gzcdcmake-2.8.5 ./bootstrapmakemakeinstallyum install-ylibaio-develncurses-develgroupaddmysqluseradd-gmysql Mysql-s/sbin/nologinmkdir-p/data/mysqlpchownmysql.mysql/data/mysqlp cd/root/softtarzxvfPercona-Server-5.5.32-rel31.0.tar.gzcd percona-server-5.5.32-rel31.0/usr/local/bin/cmake.-dcmake_install_prefix=/usr/local/mysql_p- Dwith_innobase_storage_engine=1-denabled_local_infile=1-dextra_charsets=all-ddefau

Tags: software mysql server localDownload percona-server-5.6.26-74.0.tar.gzInstall some of the necessary software with Yum:Yum-y install make gcc gcc-c++ cmake bison-devel ncurses-devel gcc \autoconf* automake* zlib* fiex* libxml* libmcrypt* libtool-ltdl-devel* \OpenSSL openssl-devel ncurses compat* MPFR cpp glibc readline-develUnzip Percona Server, and then enter:cmake-dcmake_install_prefix=/usr/local/mysq

After MySQL was acquired by Oracle, more and more people expressed concern about the future of MySQL, the open source of MySQL, more or less of Oracle's own database products, the impact of the open source of free MySQL for Oracle more baggage than assets. For example, Taobao turned from Oracle to MySQL, some large internet companies are also in the implementation of IoE (I:IBM,O:ORACLE,E:EMC), Oracle acquired MySQL, there will be MySQL closed source of potential risks, so the community to use a