percona upgrade

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

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: index create UPS ONS path reference repo support OfoXtrabackup 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. S

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

Install Percona Toolkit repo to support the installation of binary packages directly with Yum Yum Install-y https://www.percona.com/redir/downloads/percona-release/redhat/latest/percona-release-0.1-3.noarch.rpmYum Install-y Percona-toolkit Change MySQL table structure DDL pt-online-schema-change Pt-online-schema-cha

Tags: get install nbsp span back ini serve not tinthe existing environment already has Zabbix server and agent side installed1 Download percona Monitor pluginhttps://www.percona.com/downloads/percona-monitoring-plugins/LATEST/after download the name is as follows percona-zabbix-templates-1.1.8-1.noarch.rpm2 upload the plugin to the serverRz3 Installing pluginsRPM

1. Install Agent client FirstTar zxvf zabbix-3.2.6. TAR.GZCD Zabbix-3.2.6. /configure--prefix=/data/zabbix--enable-java --enable-agent--with-net-snmp--with-libcurl--with-openiomi-- With-unixodbc--with-ldap--with-ssh2--with-openipmi--with-jabbermakemake Install2. Download the percona-zabbix-templates templatewget https://www.percona.com/downloads/percona-monitoring-plugins/

1, install the monitoring plug-inwget https://www.percona.com/downloads/percona-monitoring-plugins/percona-monitoring-plugins-1.1.7/binary/ redhat/6/x86_64/percona-zabbix-templates-1.1.7-2.noarch.rpmRPM-IVH percona-zabbix-templates-1.1.7-2.noarch.rpmYum Install percona-zabbi

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