percona repo

Tags: mysql optimizer 5.5 5.6MySQL official 5.6. The 10 version came out, claiming that compared to the previous version of the performance improved a lot, the actual test, indeed improved, but compared to the Percona 5.6.6 in terms of performance has no advantage.1. TPCC Test Results650) this.width=650; "title=" MySQL 5.6.10 vs Percona 5.6.6 TPCCC Performance test Result "src=" Http://dp.imysql.com:8080/fi

In CentOS 6.4 installation deployment Percona Xtrabackup, perform full backup script, backup unsuccessful, view log, error is as follows:11:15:51 innobackupex:connecting to MySQL server with DSN ' Dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_ Default_group=xtrabackup;mysql_socket=/data/lib/mysql/mysql.sock ' as ' dump ' (using Password:yes).Innobackupex:got a fatal error with the following Stacktrace:at/usr/bin/innobackupex line 2999Main:

Turn from old leaves, original: http://imysql.com/2012/10/08/mysql-vs-mariadb-vs-percona-tpcc-testing.html I. Brief IntroductionIt is a free open-source database server developed by a company founded by Michael widenius, a MySQL author. Mariadb is a transaction-based Maria storage engine that replaces MySQL's MyISAM storage engine. It uses the xtradb and InnoDB variants of percona. This version also includ

Percona XtraDB Cluster (hereinafter referred to as PXC) is an open source MySQL high-availability solution. It integrates Percona server and Percona xtrabackup with the Galera library to enable synchronous multi-master replication. The topology of each node is as follows:　　　　, PXC each node's status is equal, each node in the cluster can be used for reading and w

This was done before Percona XtraDB Cluster (Configuration See linkhttp://hans925.blog.51cto.com/542170/1607157)Now with Haproxy to Percona XtraDB cluster do load balancing, machine or those two machines, (originally do load balancing three machines, but personal notebook run two virtual machine on a bit card, so it used two). The haproxy was installed on the first Percona.HaproxyOs:ubuntu 14.04 Server ip:1

If you encounter mysql-libs-5.1.73-3.el6_5.x86_64 conflicts with file from the package Percona-server-server error, there are two situations that cause this problem:1) Uninstall the Mysql-libs package preinstalled by the operating systemRpm-qa | Grep-i Libs | Grep-i MySQLRpm-e Mysql-libs2) Install PERCONA-SERVER-SHARED-COMPAT-5.5.33-REL31.1.566.RHEL6.X86_64.RPM package (version to see the situation)http://w

Generally, it is not recommended to upgrade the database version. This script is dedicated to version control. To prevent compatibility issues between major versions, scripts by default only support upgrades between the same major version, such as MySQL-5.6.25 upgrade to MySQL-5.6.26, MySQL-5.5.44 upgrade to MySQL-5.5.45, MariaDB-10.0.20 upgrade to MariaDB-10.0.21; not across Branch versions and not across major versions, such as upgrading from MySQL-5.5.44 to PerconaL-5.5.44-37.3, MySQL-5.5.44

First, the environment: 10.1.16.65 CentOS7.2 (PMM Server) 10.1.16.52 CentOS7.2 MySQL 5.7.16-master (PMM Client) 10.1.16.53 CentOS7.2 MySQL 5.7.16-slave (PMM Client) Ii. preparatory work Check the iptables of the three servers to see if SELinux is closed or in permissive Third, installation 1. Install PMM Server on 10.1.16.65: At present official PMM only Docker mirror, so need to deploy first Docker Yum Install Docker Considering that late monitoring data collection may occupy a certain dis

Tags: move 16px my.cnf--tar requires Efault SQL baseDownload (example: CENTOS7 2.4.4 version, select the appropriate version with https://www.percona.com/downloads/XtraBackup/LATEST/ )wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.4/ binary/redhat/7/x86_64/ percona-xtrabackup-24-2.4.4-1.el7.x86_64.rpminstallationYum Localinstall percona-

In the near future, the company requires an audit of the operation on the MySQL database; the Audit_log Audit plugin is integrated in the MySQL official Enterprise Edition (paid edition).However, this plugin is not included in the community open source version and is not available for download.Learn more about MariaDB has an audit plugin called server_audit.so, which is rumored to have been independently downloaded previously.But I did not find the download link on the official website, simply d

Tags: mysql monitor pmmPMM is a monitoring and management platform provided by Percona company for MySQL and MongoDB. PMM has two components PMM client and PMM ServerPMM Client: Installed in each database host that needs to be monitored, including the following tools . PMM-ADMIN:PMM client Tools for adding or removing database instances that need to be monitored. Percona-qan-agent: Used to collect databas

Label:First, 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. Xtrabackup Advantages:1, no need to stop the database for InnoDB hot standby2. Incremental backup MySQL3. Stream compression to other servers4, it can be easier t

Tags: percona xtradb cluster 5.5First, the installation of PXC requirements1, strongly recommend more than 3 nodes and hardware configuration, one node performance is affected, the overall affected, following the barrel effect2. If a DDL statement has a problem, it will break the cluster3. Create the database table engine must be innodb, or the composite SQL statement cannot be synchronized4. Create a database table must have a primary key index, or a

Introduction of Percona-toolkitPercona-toolkit is a collection of advanced command-line tools for performing various MySQL and system tasks that are complex and cumbersome to perform by hand, including: Check the consistency of master and slave data Effectively archive records Look for Duplicate indexes Summarizing Server information Analyze queries from logs and tcpdump Collect important system information when something goes wr

1, automatic installation of Percona Yum Warehouse (the following are x86_64 and i386 platform respectively) #rpm-IVH http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm#rpm-IVH http://www.percona.com/redir/downloads/percona-release/percona-rel

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