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
/installation.html
Apt-key adv--keyserver keys.gnupg.net--recv-keys 1c4cbdcdcd2efd2a
Join in/etc/apt/sources.list:
Deb Http://repo.percona.com/apt Precise Main
Deb-src http://repo.percona.com/apt Precise Main
Performing Update and installation operations
Apt-get Update
Apt-get Install Percona-xtrabackup
Note: Precise is the Ubuntu-12.04 version code, if it is other system version, need to replace.Xtrab
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
/installation.htmlApt-key adv--keyserver keys.gnupg.net--recv-keys 1c4cbdcdcd2efd2aJoin in/etc/apt/sources.list:Deb Http://repo.percona.com/apt Precise MainDeb-src http://repo.percona.com/apt Precise MainPerforming Update and installation operationsApt-get UpdateApt-get Install Percona-xtrabackupNote: Precise is the Ubuntu-12.04 version code, if it is other system version, need to replace.Xtrabackup Tools IntroductionAfter
Percona xtradb Cluster (PXC) is the choice of many enterprises based on MySQL to implement the cluster scheme. PXC it supports high availability of services, data synchronization replication (concurrent replication), almost no latency, multiple simultaneous read and write nodes, write extensions, and so on. Before finishing a article Pxc 5.6, this article is based on the CentOS 7 PXC 5.7 version of a more standard installation, for everyone to referen
Tags: command line parsing data FSE Error Ofo query log schema EPOPercona Toolkit is a set of advanced command-line toolsets for managing MySQL and system tasks, mainly including:1, master and slave status detection and repair2. Detection of delay from library replication3, slow query, log analysis4. detecting MySQL Server Status5. Detection from logs and tcpdump
1. Installing Perl related modules
Yum Install PERL-DBI
Yum Insta
: Precise is the Ubuntu-12.04 version code, if it is other system version, need to replace.Xtrabackup Tools IntroductionAfter installing Xtrabackup, there will actually be several tools:Innobackupex: This is actually a Perl script package for the following three tools, which can be backed up MyISAM, InnoDB, xtradb tables. However, you need to add a read lock when handling MyISAM.Xtrabackup: A binary file compiled from C that can only back up InnoDB an
Check if MySQL Server is installed:Rpm-qa | grep MySQLRpm-qa | grep mariadbDelete method:RPM-E MySQL #普通删除模式Rpm-e--nodeps MySQL #强行删除模式, if you use the above command to delete, prompted to have other dependent files, then use this command can be forcibly deleted.Yum Remove mariadb-libs-5.5.41-2.el7_0.x86_64Note that mariadb also cannot exist, some words to delete the tune, delete when there are dependencies, direct yum uninstall before installing MySQ
/sources.list:
23
Deb http://repo.percona.com/apt precise maindeb-src http://repo.percona.com/apt precise main
Performing Update and installation operations
23
Updateapt-get install percona-xtrabackup
Note: Precise is the Ubuntu-12.04 version code, if it is other system version, need to replace.Xtrabackup Tools IntroductionAfter installing Xt
In CentOS 6.4 installation deployment Percona Xtrabackup, perform full backup script, backup unsuccessful, view log, error is as follows:11:15:51 innobackupex:connecting to MySQL server with DSN ' Dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_ Default_group=xtrabackup;mysql_socket=/data/lib/mysql/mysql.sock ' as ' dump ' (using Password:yes).Innobackupex:got a fatal error with the following Stacktrace:at/usr/bin/innobackupex line 2999Main:
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
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
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
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.