percona support

1, installation Xtrabackupcd/usr/local/Tar xvf percona-xtrabackup-2.0.8-587.tar.gzMV percona-xtrabackup-2.0.8 XtrabackupVim/root/.bash_profilePath= $PATH: $HOME/bin:/usr/local/xtrabackup/binSource/root/.bash_profile2. Full backup MySQL 5.1.73 databaseInnobackupex--user=root--password=******--socket=/var/lib/mysql/mysql.sock/root3. Install MySQL 5.6.36Yum install-y autoconf automake imake libxml2-devel expat

Percona server is a derived version of MySQL, focusing on improvements to MySQL database server under Linux/bsd, with a significant improvement in functionality and performance compared to MySQL.The use of Percona Server is exactly the same as MySQL, and you can completely use it as MySQL.Installing Percona ServerEdit Percona.repo :# Vi/etc/yum.repos.d/percona.re

Download and install Percona source, use Percona Toolkit or Innobackup later Wget-n--no-check-certificate RPM-IVH percona-release-0.1-4.noarch.rpm2. Installing the Percona Monitor plugin with YumYum-y Install Percona-zabbix-templatesAfter the installation, most of the f

Installation and configuration of Percona XtraDB Cluster Percona XtraDB Cluster is a high availability and scalability solution for MySQL users based on Percona Server. It includes the Write Set REPlication patch and uses the Galera 2.0 library, which is a synchronization multi-host REPlication plug-in for transactional applications.

Preparation: OS is centos6.7, pre-download and upload percona-xtrabackup installation package, download URL: https://www.percona.com/downloads/XtraBackup/LATEST/1. Installing dependent Packages[Email protected] xtrabackup]# yum-y install perl perl-devel libaio libaio-devel perl-time-hires perl-dbd-mysqlDependency installed:Perl-dbi.x86_64 0:1.609-4.el6complete!2. Installing the Percona-xtrabackup tool2.1--M

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

Percona-toolkit is a collection of advanced command-line tools that perform a variety of manual execution of very complex and cumbersome MySQL and system tasks, including:??? 1. Check the consistency of master and slave data??? 2. Efficient archiving of records??? 3. Finding duplicate Indexes??? 4. Summarize the server information??? 5. Analyze queries from logs and tcpdump??? 6. Collect important System information when the system goes wrongPercona-t

This article tags: Ubuntu MySQL ubuntuserver perconaserver MySQL database server performance optimization Internet GossipWhat is the goods?Percona has improved mysql database server, with a significant increase in functionality and performance compared to MySQL. This version improves the performance of InnoDB under high load conditions, provides some very useful performance diagnostic tools for DBAs, and additional parameters and commands

[Email protected] export]# TAR-XVF percona-toolkit_2.2.15-2.tar.gz[Email protected] export]# CD Percona-toolkit[Email protected] percona-toolkit]# Perl makefile.plCan ' t locate extutils/makemaker.pm in @INC (@INC contains:/usr/local/lib64/perl5/usr/local/share/perl5/usr/lib64/ Perl5/vendor_perl/usr/share/perl5/vendor_perl/usr/lib64/perl5/usr/share/perl5.) At mak

Percona has improved the MySQL database server and has a significant improvement in functionality and performance over MySQL. This release improves the performance of InnoDB in high load situations, provides some very useful performance diagnostic tools for DBAs, and additional parameters and commands to control server behavior. The Percona server contains only the MySQL server version and does not provide

Release of percona server for MySQL 5.6.10-60.2 Author: chszs, reprinted with note. Blog homepage: http://blog.csdn.net/chszs Percona released percona server for MySQL 5.6.10-March 14, 2013 in 60.2. See: http://www.percona.com/downloads/Percona-Server-5.6/Percona-Server

Configure the Percona Yum repository under centos5.6 and install the Xtrabackup toolFirst, install the dependencies:Yum Install PERL-DBIYum Install Perl-dbd-mysqlYum Install Perl-time-hiresYum Install Perl-io-socket-sslSecond, configure the Yum source,Method 1, automatically install Percona's Yum warehouse (the following are x86_64 and i386 platforms respectively)#rpm-IVH http://www.percona.com/downloads/percona