percona galera

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

1. Download source percona-xtradb-cluster-5.7.19-29.22.tar.gz-https://www.percona.com/downloads/percona-xtradb-cluster-latest/ Openssl-1.2.j.tar.gz 2. Compile OpenSSL #CFLAGS =-fpic/config--prefix=/opt/openssl-1.0.2j/. #make make Install 3. Compile PXC #mkdir output #./build-ps/build-binary.sh Output--with-ssl/opt/openssl-1.0.2j/ If everything goes well, you can find the compression package for the final

MySQL (Percona Server) 5.6.15 Main Library: 192.168.2.21 from library: 192.168.2.22For example, we synchronize the database as: Test. If you need to synchronize multiple databases, there is a description below.MySQL Master-slave replication principle1. master将改变记录到二进制日志(binary log)中（这些记录叫做二进制日志事件，binary log events，可以通过show binlog events进行查看）；2. slave将master的binary log events拷贝到它的中继日志(relay log)；3. slave重做中继日志中的事件，将改变反映它自己的数据。Main Library (192.16

Download and user Empowerment Reference previous article Percona-toolkit pt-table-checksums detection of MySQL master-slave data consistencyUse Pt-table-checksums to detect data consistency, and then use Pt-table-sync for master-slave consistency repair, noting that the repaired table must have a primary key or a unique indexUnder Main vault bash execution:./pt-table-checksum--nocheck-replication-filters--replicate=test.checksums--host=10.50.12.33--po

Tags: Pat ring partial TMP Import Table Percona Backup call PrepareXtrabackup can also implement partial backups, that is, to back up only one or some of the specified databases or some or some of the tables in a database. However, to use this feature, you must enable the innodb_file_per_table option, which is to save each table as a separate file. It also does not support the--stream option, which means that data is not supported to be piped to other

-query-digest--user=root–password=abc123--review h=localhost,d=test,t=query_history--create-review-table slow.log_20140402(9)throughtcpdumpCrawlMySQLof theTCPprotocol data, and then analyzeTcpdump-s 65535-x-nn-q-tttt-i any-c-Port 3306 > Mysql.tcp.txtPt-query-digest--type tcpdump mysql.tcp.txt> slow_report9.log(Ten)AnalysisBinlogMysqlbinlog mysql-bin.000093 > Mysql-bin000093.sqlPt-query-digest--type=binlog mysql-bin000093.sql > Slow_report10.log(one)AnalysisGeneral LogPt-query-digest--type=genlog

The complete error message is as follows:There is no data for the selected MySQL instance, time range or search query.QAN API Error: "QH. Profile:no query classes for selected instance and time range. Please check whether your MySQL settings match

The first time installs percona5.7.11, encounters the root user to log in the database to need to enter the password question (this is 5.7root account security mechanism)someone on the internet said that there is a default password for the root

Pt-duplicate-key-checkerThe function is to find duplicate indexes and foreign keys from the MySQL table, the tool lists the duplicate indexes and foreign keys, and generates a statement to delete the duplicate index, which is very convenient   find

192.168.31.64:Innobackupex--defaults-file=/data/mysql/3306/etc/my.cnf--user=root--compress--stream=xbstream./| SSH [email protected] "Xbstream-x-c/data/mysql/backup/"192.168.31.65:wget Http://www.quicklz.com/qpress-11-linux-x64.tarTAR-XF

System Class Tools1. Pt-diskstatsFunction Introduction:It's an interactive monitoring tool for Gun/linux.Usage Introduction:Pt-diskstats [OPTION ...] [FILES]Printing disk IO Statistics for gun/linux is a bit like iostat, but the tool is interactive

Pt-fifo-splitFunction: Simulate cutting files and pass them through to the first in, first out queue without actually cutting filesDescriptionPt-fifo-splitread data from large files and print toFIFOeach time you reach the specified number of lines,

When it comes to system tuning for IO-intensive applications, we often need to know the system performance and usage, such as the system CPU memory IO Network, combined with the application's own traffic, and MySQL performance indicators to

This morning, the development environment of the MySQL upgrade to the 5.7.15,5.6 data import, start everything normal, check the. Err log, the following exception was found:2016-10-31t00:29:33.187073z 0 [Warning] System table ' Time_zone_leap_second

Software version:percona-xtrabackup-2.2.10mysql-5.6.23 Xtrabackup Installation 2. full standby and recovery(1) fully preparedView Database[Email protected]]# innobackupex--defaults-file=/etc/my.cnf--user=root--password=123456/bak/mysql/

Replication Class Tools1. Pt-heartbeatFunction Introduction:Monitor MySQL replication latencyUsage Introduction:Pt-heartbeat [OPTION ...] [DSN]--update|--monitor|--check|--stopMeasure how much time is left behind the main MySQL or main PostgreSQL,

How to use Innobackupex1. Full backup parameters a full backup address is fully backed up to the/data/mysql/back_up/all_testdb_20140612 directoryInnobackupex--user=root--password=123456--no-timestamp/data/mysql/back_up/all_testdb_20140612Now the

Configure the normal clone firstTwo servers, one master and one standbyPrimary server:10.10.1.30Slave:10.10.1.200Modify the My.cnf file for each machine, modify the server_id separatelymaster server server_id= 1, slave server_id=2Restart the two

1.pt-archiverFunction Introduction:Archive records from tables in a MySQL database to another table or fileUsage Introduction:Pt-archiver [OPTION ...]--source DSN--where whereThis tool simply archives old data and does not have much impact on OLTP

Backup strategy: Make a full standby every Sunday and make an incremental backup every day. One: Fully-prepared script Cat xtrabackup_full.sh #!/bin/bash Local_ip= "$ (/sbin/ifconfig eth0|grep ' inet addr ' |awk-f: ' {print $} ' |cut-d '-f1)" Email=