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
Tags:-o xtraback log Max mysqld img Real-time synchronous parallel presenceIntroduced:PXC belongs to a set of nearly perfect MySQL high-availability cluster solution, compared to the traditional master-slave replication mode-based cluster architecture MHA and mm+keepalived, the most prominent feature is to solve the data replication delay problem, basically can achieve real-time synchronization. The relationship between the nodes is peer, the transaction is either executed on all nodes, or not,
1. IntroductionXtrabackup is the MySQL database backup tool for Percona. An open source tool for hot provisioning of InnoDB and XTRADB.1> its backup process is fast and reliable2> can save disk and traffic based on compression function3> The backup process does not disrupt the transaction being performed4> restore speed, automatically implement backup inspection2, the implementation of backup1> Full BackupInnobackupex--user=dbuser--password=dbuserpass
Xtrabackup Execution Process
Perform operations on the database during full backupHttps://www.cnblogs.com/digdeep/p/4946230.html
We can see that xtrabackup has two threads in total for full backup.
Set session lock_wait_timeout = 31536000:Because if a session uses the lock tables statement to lock a table, a session is executing DDL, or a session is conducting a large transaction, then, flush tables an
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
.el6.rf.x86_64.rpm#rpm-IVH percona-xtrabackup-24-2.4.7-1.el7.x86_64.rpm 2.3 The syntax format of the Innobackupex command?#innobackupex Options?--user User Name--password Password--databases Library Name--no-timestamp a subdirectory name that does not use the system date for the backup directory--apply-log Recovery Log--copy-back Recovering data A, use innobackupex name only to do full and full recovery?
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
Xtrabackup backing up the MySQL database1. Installing dependent Packages650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/78/78/wKiom1Z9E7DhrU7MAAAnW21ULTQ385.png "title=" 9.png " alt= "Wkiom1z9e7dhru7maaanw21ultq385.png"/>#yum-y Install Perl-time-hires-perl-dbd-mysqlPerl-dbd-mysql need mysql-libs-5.1.73 package, if this package and existing mysql-server conflict, need to install this package separately with RPM--force 2. Installing Xtrabacku
[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
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
Reprinted from: http://www.cnblogs.com/cevin/archive/2012/05/12/2496859.html
Http://www.percona.com/
Percona has improved the MySQL database server and significantly improved its functions and performance compared with MySQL.
This version improves the performance of InnoDB under high loads and provides DBA with some useful performance diagnostic tools. In addition, more parameters and commands are available to control server behavior.
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
1.Xtrabackup Tools Introduction:
Xtrabackup is a tool for data backup of InnoDB, which supports online hot backup (without affecting data reading and writing during backup), is a good substitute for the commercial Backup tool InnoDB Hotbackup.
Xtrabackup has two main tools: Xtrabackup and Innobackupex
Percona server is a derived version of MySQL, focusing on improvements to MySQL database server under Linux/bsd, with a significant improvement in functionality and performance compared to MySQL.The use of Percona Server is exactly the same as MySQL, and you can completely use it as MySQL.Installing Percona ServerEdit Percona.repo :# Vi/etc/yum.repos.d/percona.re
Download and install Percona source, use Percona Toolkit or Innobackup later
Wget-n--no-check-certificate RPM-IVH percona-release-0.1-4.noarch.rpm2. Installing the Percona Monitor plugin with YumYum-y Install Percona-zabbix-templatesAfter the installation, most of the f
Mysqldump Xtrabackup is a tool used to back up InnoDB data. It supports online Hot Backup (which does not affect Data Reading and Writing during Backup) and is a commercial backup tool InnoDBHotbac.
Mysqldump Xtrabackup is a tool used to back up InnoDB data. It supports online Hot Backup (which does not affect Data Reading and Writing during Backup) and is a commercial backup tool InnoDB Hotbac.
Mysqld
Percona-toolkit is a collection of advanced command-line tools that perform a variety of manual execution of very complex and cumbersome MySQL and system tasks, including:??? 1. Check the consistency of master and slave data??? 2. Efficient archiving of records??? 3. Finding duplicate Indexes??? 4. Summarize the server information??? 5. Analyze queries from logs and tcpdump??? 6. Collect important System information when the system goes wrongPercona-t
This article tags: Ubuntu MySQL ubuntuserver perconaserver MySQL database server performance optimization Internet GossipWhat is the goods?Percona has improved mysql database server, with a significant increase in functionality and performance compared to MySQL. This version improves the performance of InnoDB under high load conditions, provides some very useful performance diagnostic tools for DBAs, and additional parameters and commands
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.