percona db

1. Install Xtrabackup Installation method of Yum: Automatic $ RPM-UHV http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm Then you'll see: Retrieving http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm preparing ... ###########

1. percona-toolkit Introduction Percona-toolkit is a set of advanced command line tools used to execute various complicated and troublesome mysql and system tasks by hand, including: Check master and slave Data Consistency Effectively archive records Searching duplicate Indexes Summarize Server Information Analyze queries from logs and tcpdump Collect important system information when a system problem occur

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

. ' Mysql_config--include '-i/usr/local/mysql/include/-C ordstat.cCc-w-o2-g-I. ' Mysql_config--include '-i/usr/local/mysql/include/-C delivery.cCc-w-o2-g-I. ' Mysql_config--include '-i/usr/local/mysql/include/-C slev.cCC MAIN.O SPT_PROC.O driver.o support.o sequence.o rthist.o neword.o payment.o ordstat.o delivery.o slev.o ' Mysql_config- -libs_r '-lrt-l/usr/local/mysql/lib/-O. /tpcc_start/usr/bin/ld:warning:libssl.so.6, needed by/usr/local/mysql/lib//libperconaserverclient.so, may conflict with

Original: 79656771Brief introductionBefore primarily using Nagios to monitor MySQL, this article mainly introduces the use of percona-monitoring-plugins monitoring Mysql,percona monitoring plug-in is PHP development, so to install PHP environment in the agent.Configure the installationI. zabbix-agent-side operation1. Install software dependenciesyum install php php-mysql -y 1 2. Installing the

Why percona-xtrabackup We have discussed MySQL Cold Standby, Hot Standby, mysqldump, and hot copy to ensure data consistency. Because mysql cold backup, mysqldump, and mysql hot copy cannot achieve Incremental backup, Incremental backup is used in a large number of actual environments, and percona-xtrabackup is generated for Incremental backup, therefore, we need to use

Tags: style blog http io ar color OS using SPAt the 2014Oracle database carnival, the author was fortunate enough to hear about the Web-based PXC high-availability architecture design theme for MySQL database.MySQL and Oracle are two different kinds of databases, Oracle is more than management, and MySQL is more important than architecture design. The author of MySQL and new technology is full of curiosity, simply come back to build a test environment.Operating system: CentOS 6.6Software version

Tags: res ges share plugin mys Percona Stat official website pre1, add Percona warehouse.# yum install -y http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm2, install the plug-in.# yum -y install percona-zabbix-templates# rpm -ql

Tags: water client awk 40 cal success Title init milZabbix with plugin Percona monitor MySQL dataIn the sense of Zabbix the MySQL plugin to monitor the MySQL database, but you will find that the MySQL monitoring items are very few, can not meet the needs of the company.Because its own template is too simple, so need to do more detailed monitoring, and Percona provides this detailed monitoring template and s

Tags: zabbix percona mysql Yum Install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm Yum Install percona-zabbix-templates PHP php-mysql 3.[Email protected] ~]# rpm-ql percona-zabbix-templates /var/lib/zabbix/

://www.percona.com/doc/percona-toolkit/2.1/pt-kill.html#cmdoption-pt-kill--interval Parameters -Busy-time Running time -Idle-time Idle Time -Victims All matched connections should have the longest connection -Interval Interval. The default value is 30 s. It is a bit long and can be adjusted according to the actual situation. -Print Print the kill connection. -Match-command Match the current connection command QuerySleepBinlog DumpConnectDelayed insert

MySQL High-availability PXC (Percona XtraDB Cluster)ReferenceHttp://www.cnblogs.com/xiaoboluo768/p/5135619.htmlThe server environment information is as follows:Node1 192.168.0.100Node2 192.168.0.101Node3 192.168.0.1021. Install the Software dependency package (add Repl source, install dependencies, and 3 server operations. ）[Email protected] ~]# RPM-IVH http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm[email protected] ~]# Yum

Since the mysql5.6 Community Edition does not have an Enterprise Edition-specific audit audit plugin, the recent need to increase the audit function of the production MySQL database, in consideration of Percona, MARIDB and macfee3 versions of audit, finally chose the more familiar Percona version.Note here, it is best to adopt the same child version of the PXC audit_log.so file, that is, download the PXC bi

If the data in the MySQL production database on the line is mistakenly deleted, and the DBA goes to recover the data, it is discovered that the database is not backed up, Binlog, or open. Is there any other means to try to recover the data? Percona Company provides an unconventional repair tool that can be used to repair table data. Of course, this tool is limited:1, only for the InnoDB engine table 2, the table Row_format must be redundant or compact

you need to pay attention to configuring libmysqlclient18, otherwise it will cause the manual installation of the Percona-xtrabackup run times error, saying that some running files could not be found.Refer to:# Set MySQL library ln-s/usr/local/mysql/lib/libmysqlclient.so.18.0.0/usr/lib64/libmysqlclient.so.18.0.0 ln-s/usr/local/mysql/lib/libmysqlclient.so.18.0.0/usr/lib64/libmysqlclient.so.18 ln-s/usr/local/mysql/lib/libmysqlclient.so.18.0.0/usr/l

[MySQL tool] use percona-toolkit (1) source code to install bitsCN.com [MySQL tool] percona-toolkit (1) source code installation 1. percona-toolkit introduction Percona-toolkit is a set of advanced command line tools used to execute various complicated and troublesome mysql and system tasks by hand, including: L chec