percona db

MySQL's online table structure is modified because of inefficient and blocking read and write. has been criticized. As for the principle of alter TABLE, see my previous article. MySQL modifies the large table structure online. After reading, found that the problem is still locked, and for the online update of this block is not very good processing, so can only be understood theoretically, applied to the online library or there is a problem. The latest data is not guaranteed.Today we see the same

Backup scheme for MySQL database using the Percona-xtrabackup toolNeed to back up the MySQL host 172.16.155.23Host 172.16.155.22 for backup MySQLPurpose: The MySQL database on the 155.23 host is backed up on a daily basis and synchronized to the remote host1. Install the Backup toolYum localinstall-y percona-xtrabackup-2.2. 9-5067. el6.x86_64.rpm2. Write the BACKUP database script:Vim/data/scripts/backdb.SH

[Email protected] ~]# CD/USR/LOCAL/SRC[Email protected] src]# tar zxvf percona-xtrabackup-2.4.4-linux-x86_64.tar.gz-c/usr/local[Email protected] src]# cd/usr/local[Email protected] local]# MV Percona-xtrabackup-2.4.4-linux-x86_64/xtrabackup[Email protected] local]# chown mysql-r xtrabackup/[Email protected] ~]# Su-mysql[Email protected] ~]$ Vi. bash_profilePath= $PATH:/usr/local/xtrabackup/bin[[email protec

1, installation Xtrabackupcd/usr/local/Tar xvf percona-xtrabackup-2.0.8-587.tar.gzMV percona-xtrabackup-2.0.8 XtrabackupVim/root/.bash_profilePath= $PATH: $HOME/bin:/usr/local/xtrabackup/binSource/root/.bash_profile2. Full backup MySQL 5.1.73 databaseInnobackupex--user=root--password=******--socket=/var/lib/mysql/mysql.sock/root3. Install MySQL 5.6.36Yum install-y autoconf automake imake libxml2-devel expat

Tags: percona-toolkit online add delete MySQL index, field (not locked table)1. Installation ConfigurationYum install perl-dbd-mysql perl-time-hires perl-io-socket-ssl perl-dbi perl-extutils-cbuilder perl-ExtUtils-MakeMaker -y Cd/root/soft tar zxvf percona-toolkit_2.2.11.tar.gz cd percona-toolkit-2.2.11 perl makefile.pl make make Install2.pt-online-schema-change

sudo apt-key adv--keyserver keys.gnupg.net--recv-keys 1c4cbdcdcd2efd2asudo nano/etc/apt/sources.list join:Deb Http://repo.percona.com/apt Trusty MainDEB-SRC http://repo.percona.com/apt Trusty MainOne trusty is the Ubuntu 14.04 code name, 12.04 of the code is precise.sudo apt-get update updates the source for Sources.list to take effect.Apt-cache Search Percona can see all the tools provided by Percona, such

First of all, this article is not a hands-on teaching you to use Percona Xtrabackup, you can refer to my entry level article http://blog.csdn.net/zhu19774279/article/details/41693267, you can also search or read the official manual. I've been trying to use the Percona xtrabackup compression feature and the ability to send it to a remote host today, but it's always "failed" and it's time to get off work and

Although PXC supports adding cluster nodes online, it has not yet addressed the Wsrep_sst_method=xtrabackup or wsrep_sst_method=mysqldump times error. Therefore, try to manually complete the Xtrabackup backup and restore and add the nodes to the cluster.Scene:There are three clean CentOS 6 servers, IP configured as: 192.168.166.169,192.168.166.170,192.168.166.171, ready to build three nodes of Percona XtraDB Cluster, Currently 192.168.166.169,192.168.

Encapsulate your own DB Class (PHP) and db Class php. Encapsulate your own DB Class (PHP). encapsulate db Class php to encapsulate a DB class for special database operations. any operations on the database in the future will be implemented by

Install and use Xtrabackup from Percona to back up MySQL Install and use Xtrabackup from Percona to back up MySQL 1. Install XtraBackup If it is a 32-bit system, just put the content of xtrabackup0.9.zip in the bin directory of mysql. You can also compile the database together. Take 5.0.88 as an example:First download its source code:Note: It must be compiled with the mysql source code. # Tar zxvf mysq

Percona uses TokuDB Percona's "Getting to know TokuDB for MySQL" article is designed to promote TokuDB, but in fact, it also shows the history of MySQL... As mentioned above, even if you do not use the transaction provided by InnoDB, its crash-safe nature is still one of the important factors for many people to choose InnoDB: Even those that don't really need transactions rejoice in the crash resistance strength of InnoDB. When I mention Toku

Use the official binary installation directly.Https://www.percona.com/doc/percona-xtradb-cluster/5.6/installation.html#installationInnobackupex:This is actually a Perl script package for the following three tools, which can be backed up MyISAM, InnoDB, xtradb tables.Xtrabackup:A binary file compiled from C that can only back up InnoDB and xtradb data.Xbcrypt:The data used to encrypt or decrypt the backup.Xbstream:A compressed file used to decompress o

Percona-toolkit usage tutorial-Performance Tools 1. pt-index-usage Function introduction: Read the plug-in statement from the log file and explain how they use the index. After the analysis is completed, a report about the index that has not been used for query is generated. Usage: Pt-index-usage [OPTION...] [FILE...] You can obtain the SQL directly from the slow query. The SQL format in the FILE must be the same as that in the slow query. If it is no