Introducing PQuery by Percona

1 .Introducing PQuery by Percona Open Source enterprise-class solutions Alexey Bychko, Lead Release Manager (Percona) Roel van de Paar, Senior QA Lead (Percona) 

2 .About Percona Percona XtraDB Cluster 150+ staff members Percona 30 countries of the world, 30 US states XtraBackup Perconians work remotely from their homes Percona Server for MySQL HQ in Raleigh, North Carolina, USA Percona Server for MongoDB Founded in 2006, serving 3000 customers for 10 years Percona Toolkit Many customers are well-known brands Percona Monitoring and Management 

3 .Percona Software Users in Russia & CIS * This information is available in the Internet and made public by these companies. 

4 . PQuery for multithreaded stress tests … and much more 

5 .For What and Why? Random Query Generator, pros & cons Why we started it? PQuery to solve RQG speed problems (at start) new opensource and free tool from Percona used in Percona on daily basis first and second generations of PQuery 

6 .First results to CRASH, to KILL and not to TEST speed is important! unexpected and great results don’t share prototypes! you can learn something only from logs PQuery framework has been created 

7 . The success of PQuery … and results in real life 

8 .First Success Stories automatic test case creation near 100% test reproducibility 15 seconds per trial single and multi-threaded tests sequential and random SQL valued tool in Percona QA evolution to powerful tool 

9 .PQuery is supported on *nix •easy to build •easy to use •great flexibility MySQL Server 5.7, RC1 & RC2, were tested with pquery a significant number of bugs were discovered in RocksDB ≈ 270 new bugs were found in 2 months query correctness testing 

10 . PQuery v2.0 … and even more 

11 .PQuery v1.0 -> v2.0 transition can we support PXC? other multi-node setups? produce different load to the different nodes? include / exclude some particular nodes? can we log extended information about queries? client output for comparison? reproduce something - log replaying? 

12 .PQuery v2.x changes => Isolated processes, fork() model => Configuration with rich INI file at start => Separated config for each node => Extended logging 

13 . PQuery to make the systems better … learn and understand that first 

14 .What may be better in your setup? do you need fine-tuning? what to optimize if yes? MySQL optimizations OS optimizations cluster optimizations troubleshooting 

15 .Outcome: do you need High-Load setup? ext4, xfs, zfs, ufs? LVM? virtualization or bare metal? get timings for ALL queries. not only for slow ones. look for dead or slow nodes different nodes -> different queries do the upgrade and run checks cluster behavior at whole 

16 . The future of PQuery … to make it even better 

17 .Possible future of PQuery PostgreSQL support? extended cluster and replication testing? production packages and tarballs comparing engines - timings, output, supported features, errors replay scenarios and mysql logs and much-much more … 

18 .Additional resources https://github.com/Percona-QA/pquery.git main repository https://goo.gl/nPAHVA Free MySQL QA & Bash/Linux Training Series MySQL QA Episodes 1-13. PQuery, Framework, Reducer How to download and use the best tasks to apply how to report the bugs and contribute how to share your success stories 

19 .Percona celebrates its 10th anniversary! Share your Percona success story with us for cross promotion => percona10@percona.com <= Send your CV to join our team! https://www.percona.com/about-percona/careers 

20 .Percona Live: Call for Papers Deadline - November 13 Percona Live Santa Clara to take place April 24-27 in Santa Clara, CA. Submission Guidelines: http://bit.ly/2exss8u Submission Form: http://bit.ly/2e01oT2 

21 .DATABASE PERFORMANCE MATTERS