percona consulting

Tags:. com my.cnf imp kill 6.2 scripts RIP sock 5.71. Install PHPyum install -y php php-mysql2, Installation Percona-zabbixyum install -y https://www.percona.com/downloads/percona-monitoring-plugins/percona-monitoring-plugins-1.1.7/binary/redhat/7/x86_64/percona-zabbix-templates-1.1.7-2.noarch.rpm3, Configuration Zabbi

Tags: poi oca verify sudo link manually load TAC add1. Monitor MySQL with the Percona monitor pluginYum Install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpmHttps://www.percona.com/doc/percona-monitoring-plugins/1.1/zabbix/index.html#installation-instructionsYum Install

Tags: alternative innodb src Pat success test Databases source valuehttp://blog.csdn.net/dbanote/article/details/13295727 http://blog.csdn.net/yangzhawen/article/details/50457922 http://blog.csdn.net/yangzhawen/article/details/28864763 Xtrabackup is an open source software developed by Percona, which is an open source alternative to the InnoDB hot standby tool Ibbackup (paid commercial software). Xtrabackup consists of parts: Xtrabackup and Innobackup

Tags: Zabbix mysql centosMonitor MySQL using Percona monitoring Plugins in Zabbix1. Installing the Zabbix Agent[Email protected] ~]# RPM-IVH http://repo.zabbix.com/zabbix/3.2/rhel/7/x86_64/zabbix-agent-3.2.0-1.el7.x86_64.rpm [email protected] ~]# Yum install zabbix-agent2. Modify the configuration[Email protected] ~]# vim/etc/zabbix/zabbix_agentd.confserver=192.168.137.3serveractive=192.168.137.3hostname=szlinux013. Start the agent[Email protected] ~]

1. Install the dependency pack #yum-y install perl perl-devel libaio libaio-devel perl-time-hires perl-dbd-mysql2. Install Percona-xtrabackup tool # RPM-IVH percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm hint missing dependency: warning: Percona-xtrabackup-24-2.4.7-2.el6.x86_64.rpm:header V4 dsa/sha1 Signature, key ID cd2efd2a:NOKEYerror:Failed dependencies: libe

Tags: mysql, data recovery, deletefirst of all, Please note the scope of this tool:1) The recovery tool for this application is only available with the InnoDB storage engine, MyISAM does not support2) Truncate Tabe cannot be restored3) Drop table, don't even think about it.Recovery principle:For the InnoDB storage engine, the delete operation, instead of actually deleting the rows on the physical file, adds a deleted tag to the deleted row, and we use this tool to find the row that labeled the d

Tags: style http color io os ar for strong filesInstallation Environment: Cluster Name Pxc_lk Node 1: 192.168.1.20 Node 2: 192.168.1.21 Node 3: 192.168.1.22 All node installationswget http://www.percona.com/redir/downloads/XtraBackup/LATEST/binary/redhat/6/x86_64/ percona-xtrabackup-2.2.3-4982.el6.x86_64.rpm wget http://www.percona.com/redir/downloads/

Use Percona XtraBackup in multiple instances Background Percona XtraBackup is a backup tool developed by Percona. It mainly has two tools: XtraBackup and innobackupex. Innobackupex encapsulates XtraBackup and is a perl script. This document is relatively simple. innobackupex is used to back up data of 3306 instances and restore the data to 3307 instances. It also

My source[Email protected]:/tmp/percona-xtrabackup_debian8# cat/etc/apt/sources.listdeb Http://mirrors.ustc.edu.cn/debian Jessie Main contrib non-freedeb-src Http://mirrors.ustc.edu.cn/debian Jessie Main contrib non-freedeb/HTTP/Mirrors.ustc.edu.cn/debian jessie-proposed-updates main contrib non-freedeb-src Http://mirrors.ustc.edu.cn/debianJessie-proposed-updates Main contrib non-freedeb Http://mirrors.ustc.edu.cn/debian jessie-updates main contrib NO

Original: 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.Xtrabackup Advantages:1, no need to stop the databas

Percona XtraDB Cluster how to install two Cluster nodes on one server I think it makes no sense to run two or more Percona XtraDB Cluster (PXC) nodes on a single physical server, except for educational and testing purposes, however, this method is still useful in this case. The most popular implementation method seems to be server virtualization, such as using stray boxes. However, in the same way, you can

Centos 6.5 Percona 5.6.27 Tokudb Configuration# Wget https://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.27-75.0/binary/tarball/Percona-Server-5.6.27-rel75.0-Linux.x86_64.ssl101.tar.gz unzip to/usr/local, Create Symbolic Link/usr/local/percona startup err

The PT (Percona Toolkit) tool is a Perl-written toolset developed by Percona, which contains a number of features, such as changing data table structures online, validating master-slave data, checking database status, analyzing slow queries, and so on, which are more cumbersome to do by hand. , easy to operate.InstallationSince it is a tool set for Perl language development, it is of course to install Perl

First, PMM Introduction Second, PMM architecture analysis Iii. Install and run PMM Server Iv. installation and Operation PMM Client Five, add MySQL monitoring Vi. view monitoring and management platform Seven, add MongoDB monitoring Eight, instrument panel setup Nine, frequently asked questions. First, PMM introduction Percona Monitoring and Management (PMM) is an open source platform for managing and monitoring MySQL and MongoDB performance, with Thi

Tags: zabbix percona mysql linux monitoring Zabbix configurationSoftware version:Redhat6.9zabbix-3.4.7Percona mysql-5.7.20Preparatory work:Shut down the firewall, or add the appropriate port.Turn off SELinux———— (Install the following Zabbix dependency package) ————# # # #这里的包是我网上找的, please reply if necessary. #####RPM-IVH *.rpmfping-3.5-3.el6.x86_64.rpmiksemel-1.4-2_2.el6.x86_64.rpmiksemel-devel-1.4-2_2.el6.x86_64.rpmlibevent-devel-1.4.13-4.el6.x86_6

INSTALLING-PERCONAXTRADB Cluster 5.6In-ubuntu-13-10-wheezyFirst of all, I would recommend login as root so this you don ' t has tosudo every time you hit the command and give the RO OT password.1. $ SU-$ Su-Now you should is logged in as root. Mine now is1. [Email protected]:~#[Email protected]:~#Step 1:First of all lets remove everything, that's related to MySQL.1. apt-get Remove mysql*2. Apt-get purge mysql*3. Apt-get AutoremoveApt-get Remove mysql*Apt-get Purge mysql*Apt-get AutoremeveStep 2: