percona upgrade

http://blog.chinaunix.net/uid-16844903-id-4054635.html website Link: http://www.percona.com/doc/ Percona-monitoring-plugins/1.0/cacti/galera-templates.html Galera Writeset Traffic Galera Writeset Count Galera Writeset Size Galera Replication Queues Galera parallelization efficency Galera Writing Conflicts Galera Cluster Size Galera Flow Control Galera Writeset TrafficThis diagram shows: Wsrep Replicat

A good tool for connecting to killMySQL is part of perconatoolkit. when there are many idle connections, the maximum number of connections is exceeded, and a problematic SQL statement causes high mysql load, you need to kill some connections. This tool is mainly used for pt-kill. it is an excellent tool for kill MySQL connections and is part of percona toolkit, when the maximum number of connections is exceeded due to a large number of idle connection

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

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 table lock). Xtrabackup supports all Percona servers, MySQL, mariadb, and drizzle.Xtraback

Tags: copy First name Live Sync ati Storage sha Cal httpPercona XtraDB Cluster (PXC) cluster is a general multi-master synchronous replication plug-in based on Galera and transactional application, which is mainly used to solve the strong consistency problem, so that the data of each node is kept in real-time synchronization and multi-node simultaneous reading and writing is realized. It is one of the well-known cluster optimization schemes in MySQL relational database to improve the reliability

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

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--