percona consulting

MySQL Server Version:Server version: 5.7.10-log MySQL Community Server (GPL)Percona xtrabackup Version:Innobackupex version 2.4.2 Linux (x86_64) (revision id:8e86a84)Description[Master]: Represents a statement executed on the master library [slave]: Represents a statement executed on the slave library--Perform a master library full-ready[Master]innobackupex--parallel=4/data/backup/full--no-timestamp--Attach the log to the backup [Master]innobackupex--

#!/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

Tags: TPC Tools ups strong MYSQ project BSP AMP ExportPercona Top-level projects (for databases) Address: Https://github.com/Percona-Lab 1, Mongodb_consistent_backupTool for getting consistent backups from MongoDB Clusters and Replicaset 2, Pmm-server-packaging Pmm-update Pmm-manage 3, Query-playbackQuery Playback 4, Pacemaker-replication-agentsRepository of the Percona Pacemaker resource agents 5, Sysbe

-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

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

Tags: password mysqlMethod one configuration Apt source1, wget https://repo.percona.com/apt/percona-release_0.1-3.$ (LSB_RELEASE-SC) _all.deb2, Dpkg-i percona-release_0.1-3.$ (LSB_RELEASE-SC) _all.deb3, $ sudo apt-get update4, $ sudo apt-get install percona-server-server-5.6Later use is consistent with MySQLmysqladmin-u root Password "XXXX"Method two, using the D

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