Percona-toolkit installation and introduction, percona-toolkit
MySQL database is one of the best lightweight and open-source databases. Its features, management, and robustness are quite different from those of Oracle. Therefore, there are many powerful third-party derivative products, such as percona-toolkit and XtraBackup.
In this article we will learn about the Percona server, an open-source mysql,mariadb alternative. The InnoDB database engine makes the Percona server very attractive, and if you need high-performance, high-reliability and cost-effective solutions, it will be a good choice.
The installation of the Percona server on CentOS 7, as well as the backup of the current d
Install the Percona server on CentOS 7
In this article, we will learn about the Percona server, an open-source MySQL and MariaDB alternative. The InnoDB database engine makes the Percona server very attractive. If you need a high-performance, high-reliability, and cost-effective solution, it will be a good choice.
The following describes how to install the
template file is: Https://pan.baidu.com/s/1i5j8IJ7 extract password: ab8a). 3) Add parameter support Copy the userparameter_percona_mysql.conf to the zabbix_agent's corresponding configuration directory on the monitored machine #rsync-avpgolr/var/lib/ zabbix/percona/templates/userparameter_percona_mysql.conf/data/zabbix/etc/zabbix_agentd.conf.d/ #sed-i ' s#/ var/lib/zabbix/
Tags: Moni suitable for%s local client interval logon 2.0 causesSystem RequirementsMonitored host and MySQL monitoring account, Zabbix Agent 2.0 or more (preferably the same as the Zabbix-server version), PHP, Php-mysql (PHP version is not limited, tested 5.3 is possible. The best version is not too low), Percona monitoring Plugins for ZabbixInstalling the Zabbix AgentHttps://www.cnblogs.com/fishparadise/p/9067471.htmlInstalling
XtraDB. For a high-level overview of features of its advanced features, including a featurecomparison, please see AboutPercona Xtrabackup.
Whether it is a 24x7 highly loaded server or alow-transaction-volume environment,Percona XtraBackupIsdesigned to make backups a seamless procedure without disrupting theperformance of the server in a production environment. inclucial support contracts areavailable.
, please FQ or go to the official website to find the latest version.Tar XF percona-xtradb-cluster-5.6.24-rel72.2-25.11. Linux.x86_64.tar.gz-c/usr/local/services/cd/usr/local/services/Ln-s percona-xtradb-cluster-5.6.24-rel72.2-25.11. Linux.x86_64/mysqlCD MySQLGroupadd MySQLUseradd-r-G MySQL MySQLChown-r MySQL.Chgrp-r MySQL.CP SUPPORT-FILES/MY-DEFAULT.CNF/ETC/MY.C
Since the Zabbix comes with a MySQL monitoring template that monitors things less, you should use Percona Zabbix mysql-plugin to monitor MySQL as required by your company's DBA.Percona Zabbix Mysql-plugin is a tool released by Percona that uses Zabbix to monitor MySQL database, which is much more powerful than Zabbix's own monitor template, after all, Percona is
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
MySQL, installed before the direct exit[email protected] ~]# cat mysqinstall.sh#!/bin/bashMysql_dir= "/usr/local"Data_dir= "/usr/local/mysql/data"Base_dir= "/usr/local/mysql"echo "-------checking MySQL ENV now! Please wait-------"Username= ' Cat/etc/passwd|grep mysql|cut-c 1-5 'if [[$username = = "MySQL"]];thenecho "User Check,mysql user already have,can not install mysql!!"Elseecho "Please input MySQL version:"Read VERSIONecho "Your MySQL version is percon
Install Percona Server in rpm package
Percona XtraDBIt is an enhanced version of the InnoDB Storage engine and is designed to better use and update the performance of computer hardware systems. It also contains some new features in high-performance environments. The XtraDB storage engine is completely backward compatible, so you can use XtraDB to replace the InnoDB Storage engine.
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
transactional applications.The new features of Galera 2.x are:1.IST (incrementalstate Transfer) incremental state transfer. is particularly useful for WANs.2.RSU (rollingschema Update) rotation update schema. Operations on the table are not prevented.third, the system architecture based on Percona stradb cluster Extensibility Architecture Vertical shards:Multiple Percona XTRADB cluster;->spring Configure
production library, you can use the Percona company's online backup tool for backup.Replicate a copy of the MY1.CNF to another location for backup, preventing the upgrade from failing to recover ins1 quickly.3. Close Ins1Mysqladmin-uroot-p-S $sockdir 4. Ins1 the original data directory via MySQL 5.5.36 boot instance, named Ins21) Modify the my1.cnf to change some parameters that are incompatible with the high version or some obsolete parameters to a
Install Percona Server using a binary tar package
Install Percona Server using a binary tar package
InstallingPercona ServerFrom a Binary Tarball1. Download the binary tar package
Take version 5.6 as an example. Go to the official website https://www.percona.com/downloads/percona-server-5.6/latest/and you can see the following:
# Select a specific
the table structure# Cd percona-data-recovery-tool-for-innodb-0.5/#./create_defs.pl -- host localhost -- port 3306 -- user root -- password 123456 -- db test -- table sbtest> include/table_defs.h
-- Host address
-- Port
-- User Username
-- Password
-- Db database name
-- Table Name
3. Execute the make compilation command again.# D percona-data-recovery-tool-for-innodb-0.5/# make
4. Restore Deleted Dat
, INNODB_SYS_INDEXES, INNODB_SYS_COLUMNS, INNODB_SYS_FIELDS, INNODB_SYS_FOREIGN,INNODB_SYS_FOREIGN_COLS, INNODB_SYS_TABLESTATS (although MySQL 5.6 does not have MYSQL_HANDLES_OPENED,Instead it has REF_COUNT). Following tables haven'tbeen implemented in MySQL 5.6 but information isAvailable in other tables: INNODB_SYS_STATS-use MYSQL. INNODB _ (INDEX | TABLE) _ STATS instead,INNODB_TABLE_STATS-use INNODB_SYS_TABLESTATS or MYSQL. INNODB_TABLE_STATS instead,And INNODB_INDEX_STATS-use MYSQL. INNODB_
Introduction of Percona-toolkit Tools
The Percona-toolkit, "PT Tool", 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 impor
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.