Label:1. Install the MySQL monitoring plugin rpm package on the Zabbix client RPM-IVH https:// www.percona.com/downloads/percona-monitoring-plugins/1.1.6/percona-zabbix-templates-1.1.6-1.noarch.rpm Cd/var/lib/zabbix/percona/templatesCP userparameter_percona_mysql.conf/usr/local/zabbix/etc/zabbix_agentd.conf.d/# (the exact path depends on the actual situation) Im
Label:Original address: HTTP://WWW.TUICOOL.COM/ARTICLES/RZRNQ2 Xtrabackup Introduction Percona 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
The previous blog compares the various MySQL cluster scenarios, this blog will explain in the synchronous replication function of the excellent Percona xtradb cluster installation stepsFirst, if the server already has the default MySQL (many Linux installation comes with MySQL) need to first delete, otherwise it will report a conflictRpm-qa | Grep-i Mysql-server | Xargs sudo rpm-e--nodepsInstalling a dependent Packagewget http://download.fedoraproject
Recently found a very useful MySQL slow query log visualization tools, online can also find a lot of information, here combined with their own actual situation to reorganize.1. Experimental environment 1.1 system environment:操作系统:CentOS 6.5 64位主机地址:10.0.0.26主机名:mysql01mysql版本:mysql-5.6.361.2 Visualization Software Environment:http环境:LAMP可视化软件:Anemometer-master.zip, percona-toolkit-3.0.11-1.el6.x86_64.rpm, perl-TermReadKey-2.30-13.el6.x86_64.rpm2. Comp
Percona XtraDB Cluster cluster Environment establishment and validation guidePercona XtraDB Cluster is a clustering scheme for MySQL database. and compatible with the MySQL server Community version, Percona Server, and MariaDB.First, install Percona XtraDB on Ubuntu ClusterLab Environment:Suppose you have 3 computer devices that have an Ubuntu system installed an
Need to use Percona-xtrabackup Backup to install this, it seems now this changed into a CMake installation, a little trouble.Why pick 2.3.4 version, because I heard that 2.3.3 unprepared for a deadlock.Functional requirements, using Innobackupex and xtrabackupInstall the dependency package first:Yum-y Install cmake gcc gcc-c++ libaio libaio-devel automake autoconf BZR bison libtool zlib-devel libgcrypt-devel libc Url-devel crypt* libgcrypt* python-sph
About Percona installation and use of information, online quite a lot, but everyone encountered a different problem, the point of attention is not the same, so I will pay attention to the things I recorded
Percona-toolkit Installation
1. Download Percona-toolkit source package, percona-toolkit_2.2.15-2.tar.gz
Decompre
Label:Mysql Copy Tool1.percona-toolkit IntroductionPercona-toolkit is a collection of advanced command-line tools used to perform a variety of manual execution of very complex and cumbersome MySQL and System tasks, these tasks include:
check Master and slave data consistency
effectively archive records
find duplicate index
Summary of server information
analysis from logs and tcpdump query
S
Percona xtrabackup backup MySQL (full backup and incremental backup)Xtrabackup IntroductionPercona Xtrabackup is an open source, free MySQL database hot backup software that can back up non-blocking databases for InnoDB and XTRADB storage engines (for MyISAMBackup also requires a table lock). Xtrabackup supports all Percona servers, MySQL, mariadb, and drizzle.Xtrabackup Advantages:1, no need to stop the da
Percona xtrabackup ( PXB) is a backup tool developed by Percona Company for the physical hot standby of MySQL database, supporting MySQL (Oracle), Percona Server and MariaDB, and all open source, is the industry's conscience. Tool SetAfter the package is installed, there are 4 executable files, as follows:usr├── bin│ ├── innobackupex│ ├── xbcrypt│ ├── xbstr
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
Percona Xtrabackup for database backup and disaster recovery
Directory1. Tool Introduction2. Tool Installation3. Backup policies and prepare test data4. Full backup of data5. Incremental Backup Data6. Disaster Recovery7. Summary
1. Tool IntroductionPercona-xtrabackup contains two tools: xtrabackup and innobackupex. innobackupex is encapsulated by per. xtraback is automatically called when innodb tables are backed up, therefore, the xtrabackup tool is
Traditional method to modify table structure similar to ALTER TABLE XX Modify, you need to lock the table structure, if the table is large, the operation time will be longer. At present, the vast majority of business requirements 24*7 Non-stop Service, and this process, if a longer time the database can not be updated, it will seriously affect the business. Two possible options have been learned recently: 1. Replace table structure method, 2. Using Percona
In the previous blog to compare the various MySQL cluster scenarios, this blog will explain the replication features in the more excellent Percona xtradb cluster installation steps
first, if the server already has a default MySQL (many Linux installed with MySQL) need to delete first, otherwise it will report conflict
Rpm-qa | Grep-i Mysql-server | Xargs sudo rpm-e--nodeps
To install a dependent packagewget http://download.fedoraproject.org/pub/epel/6
Tag: ATI display art supports ASE stroke float amp PasswordFirst, overview: mysqldump is a tool for MySQL database backup provided by Mysql-commiunity, but can only be used for full-scale backups, if you want to implement incremental backups based on Binlog log implementations. This article describes how to do full backup, incremental backup, and recovery using the commands provided by the third-party software Percona Innobackupex.
Introduction and installation of the tutorial on using the Percona-toolkit ToolkitHttp://blog.chinaunix.net/uid-20639775-id-3206802.htmlThe Percona-toolkit tool Kit uses the development tools classHttp://blog.chinaunix.net/uid-20639775-id-3207926.htmlPerformance class tools for using Percona-toolkit ToolkitHttp://blog.chinaunix.net/uid-20639775-id-3210834.htmlPer
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.