percona backup

# Restore a database from a dump. sql fileMysql-h mdbec-db1-u Wpadmin-pwpadminpass wpdb # Percona XtraDB Cluster Start commands/etc/init.d/mysql bootstrap-pxcservice MySQL bootstrap----wsrep-cluster-address=" gcomm://"# Start a PXC node with the specified donorService MySQL start--wsrep_sst_donor=nodec# Reset PasswordSudo/etc/Init.d/MySQL Stopsudo mysqld_safe--Skip-grant-tables Mysql-u rootmysql> UpdateMysql.User SetPassword=Password ("New-Password "

Percona has improved the MySQL database server and has a significant improvement in functionality and performance over MySQL. This release improves the performance of InnoDB in high load situations, provides some very useful performance diagnostic tools for DBAs, and additional parameters and commands to control server behavior. The Percona server contains only the MySQL server version and does not provide

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

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

Use of monitoring tools in percona-toolkit series 1. pt-deadlock-logger Function introduction: Extract and record mysql deadlock Information Usage: Pt-deadlock-logger [OPTION...] SOURCE_DSN Collect and save the latest deadlock information on mysql. You can directly print the deadlock information and store the deadlock information to the database, the deadlock information includes the server where the deadlock occurred, the time when the deadlock occur

Percona-toolkit tutorial tools 1. pt-archiver Function introduction: Archive the records of tables in the mysql database to another table or file Usage: Pt-archiver [OPTION...] -- source DSN -- where WHERE This tool only archives old data and does not significantly affect OLTP query of online data. You can insert the data into other tables on another server or write it into a file, it is convenient to use the load data infile command to import data. Y

Pt-kill is a good kill MySQL connection tool, is a part of Percona Toolkit, in the due to more idle connections cause more than the maximum number of connections, a problem of SQL causes MySQL load is high, you need to kill some connections, This tool is mainly used for this purpose. Obtain a connection that satisfies the condition from show processlist or read the connection that satisfies the condition from the file containing show processlist and

#!/bin/bashcd/root/softtarzxvfcmake-2.8.5.tar.gzcdcmake-2.8.5 ./bootstrapmakemakeinstallyum install-ylibaio-develncurses-develgroupaddmysqluseradd-gmysql Mysql-s/sbin/nologinmkdir-p/data/mysqlpchownmysql.mysql/data/mysqlp cd/root/softtarzxvfPercona-Server-5.5.32-rel31.0.tar.gzcd percona-server-5.5.32-rel31.0/usr/local/bin/cmake.-dcmake_install_prefix=/usr/local/mysql_p- Dwith_innobase_storage_engine=1-denabled_local_infile=1-dextra_charsets=all-ddefau

Tags: software mysql server localDownload percona-server-5.6.26-74.0.tar.gzInstall some of the necessary software with Yum:Yum-y install make gcc gcc-c++ cmake bison-devel ncurses-devel gcc \autoconf* automake* zlib* fiex* libxml* libmcrypt* libtool-ltdl-devel* \OpenSSL openssl-devel ncurses compat* MPFR cpp glibc readline-develUnzip Percona Server, and then enter:cmake-dcmake_install_prefix=/usr/local/mysq

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

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

-visual-explain-c MYSQL-E "explain select * from Mysql.user" | Pt-visual-explainFor example:# mysql-uroot-proot-e ' Explain select * from B2b.ecs_goods ' > A.sql # pt-visual-explain/root/a.sqlOr one-step process through the pipeline:# mysql-uroot-proot-e ' Explain select * from B2b.ecs_goods ' |pt-visual-explainPt-config-diffDescriptionCompare the differences between MySQL node configuration files.Pt-config-diff diffs MySQL configuration files and server variables. CONFIG canbe a filename or a D

server IP user name password, you can analyze the entire master-slave architecture of each server information, including but not limited to MySQL version, IP address, server Id,mysql service startup time, role (main/from), Slave Status (lag behind the master server for how many seconds, there is no error, Slave is not running). Pt-Slave-Find--host=localhost--user=rhce6--password=rhce6MySQL Deadlock monitoring pt-Deadlock-Logger h='127.0.0.1' --User=root--password=123456PRIMARY key conflict Chec

Pt-kill is a very simple tool to kill MySQL threads and queries. The main purpose is to prevent some long queries from consuming system resources for long periods of time, while affecting the online business. Main function: Get the connection that satisfies the condition from show processlist or read the connection that satisfies the condition from the file containing show processlist and print or kill or perform other actions.Our main use here is to prevent some select operations from being t

data conflict, then the way is to take the inconsistent node kicked out of the cluster environment.Limitations of 4.PXC Only the InnoDB engine is supported. Because an XA transaction is likely to occur when a commit occurs rollback XA transactions are not supported, A table delete operation without a primary key is not supported, and a SELECT ... limit also returns a different value. Because of optimistic concurrency control, transaction conflicts, failed nodes are exited f

--ssl-cert PATH X509 cert in PEM format--ssl-key PATH X509 key in PEM format--ssl-cipher TEXT SSL cipher to use--ssl-verify-server-cert Verify server ' s "Common Name" in its certagainst hostname used when connecting. Thisoption is disabled by default-V,--version version of MYCLI.-D,--database TEXT database to use.-R,--prompt TEXT prompt format (Default: "\ t \[email protected]\h:\d>")-L,--logfile FILENAME Log every query and its results to a file.--defaults-group-suffix TEXT Read Config group w

Tags: percona xtradb cluster 5.5Server Preparation: Server Memory Cpu Ssds Ip OS DB1 32GB 4 cores 300GB 10.0.10.10/32 centos6.5 x64 DB2 32GB 4 cores 300GB 10.0.10.11/32 centos6.5 x64 DB3 32GB 4 cores 300GB 10.0.10.12/32 centos6.5 x64 First, the CPU parameter adjustmentMaximum performance o

Tags: action start nal first open amp from Percona font1 Overview1.1 IntroductionXtrabackup is a MySQL database backup tool provided by Percona, officially described, which is the world's only one by one open source tools that enable hot provisioning of InnoDB and XTRADB databases.PXB (Percona xtrabackup) is a physical

1. tpcc test results Click to view the chart 2. Test Environment 3. Key configuration options of InnoDB Note:1. ring replication: it refers to the creation of ring replication on three nodes, each of which is master/slave. During the test, we also tried to simulate master downtime, and slave switched the master randomly to verify the data reliability in GTID mode. In the test mode, the data reliability was indeed guaranteed.2. bp8_facts: Set innodb_buffer_pool_instances = 8 and metadata_locks_

-pointers make install Echo "/usr/local/lib">/etc/ld. so. conf. d/usr_local_lib.conf/Sbin/ldconfig Part 3: Compile and install PerconaCC = icc \CXX = icpc \LD = mongod \AR = xiar \CFLAGS = "-O3-unroll2-ip-mp-restrict-fno-tions-fno-rtti-no-prec-p-fno-implicit-templates-static-intel-static- libgcc-xSSE2-axSSE2 ″\CXXFLAGS = "$ {CFLAGS }"\CPPFLAGS = "-I/usr/alibaba/icc/include "\LDFLAGS = "-L/usr/alibaba/icc/lib-lrt "\./Configure-prefix =/usr/alibaba/install/pe