Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
July 31, 2015
MySQL QA Episode 10: Reproducing and Simplifying: How to get it Right
Welcome to the 10th episode in the MySQL QA series! Today we’ll talk about reproducing and simplifying: How to get [...]
July 29, 2015
Multi-source replication in MySQL 5.7 vs Tungsten Replicator
MySQL 5.7 comes with a new set of features and multi-source replication is one of them. In few words this [...]
July 28, 2015
MySQL QA Episode 9: Reducing Testcases for Experts: multi-threaded reducer.sh
Welcome to MySQL QA Episode 9. This episode will go more in-depth into reducer.sh: Reducing Testcases for Experts: multi-threaded reducer.sh We [...]
July 23, 2015
The Q&A: Creating best-in-class backup solutions for your MySQL environment
Thank you for attending my July 15 webinar, “Creating Best in Class Backup solutions for your MySQL environment.” Due to [...]
July 21, 2015
MySQL QA Episode 7: Reducing Testcases for Beginners – single-threaded reducer.sh!
Welcome to MySQL QA Episode #7 – Reducing Testcases for Beginners: single-threaded reducer.sh! In this episode we’ll learn how to use [...]
July 15, 2015
MySQL QA Episode 6: Analyzing and Filtering
Welcome to MySQL QA Episode #6! Today we will look into analyzing and filtering our QA run. We’ll use tools [...]
July 13, 2015
MySQL QA Episode 5: Preparing Your QA Run with pquery
Welcome to MySQL QA Episode #5! In this episode we’ll be setting up and running pquery for the first time… [...]
July 10, 2015
How to create a rock-solid MySQL database backup & recovery strategy
Have you ever wondered what could happen if your MySQL database goes down? Although it’s evident such a crash will [...]
July 9, 2015
How to obtain the MySQL version from an FRM file
I recently helped a customer figure out why a minor version MySQL upgrade was indicating that some tables needed to [...]
July 8, 2015
MySQL QA Episode 4: QA Framework Setup Time!
Welcome to MySQL QA Episode 4! In this episode we’ll look into setting up our QA Framework: percona-qa, pquery, reducer & [...]
July 7, 2015
MySQL QA Episode 3: How to use the debugging tool GDB
Welcome to MySQL QA Episode 3: “Debugging: GDB, Backtraces, Frames and Library Dependencies” In this episode you’ll learn how to [...]
June 30, 2015
Playing with Percona XtraDB Cluster in Docker
Like any good, thus lazy, engineer I don’t like to start things manually. Creating directories, configuration files, specify paths, ports [...]
June 18, 2015
Getting EXPLAIN information from already running queries in MySQL 5.7
When a new version of MySQL is about to be released we read a lot of blog posts about the [...]
June 8, 2015
MaxScale: A new tool to solve your MySQL scalability problems
Ever since MySQL replication has existed, people have dreamed of a good solution to automatically split read from write operations, [...]
June 4, 2015
High availability using MySQL in the cloud
Next Wednesday (June 10) I’ll be co-presenting a webinar on using MySQL in the cloud for High Availability (HA). Joining [...]
June 3, 2015
Optimizing Percona XtraDB Cluster for write hotspots
Some applications have a heavy write workload on a few records – for instance when incrementing a global counter: this [...]
June 2, 2015
innodb_buffer_pool_size – Is 80% of RAM the right amount?
It seems these days if anyone knows anything about tuning InnoDB, it’s that you MUST tune your innodb_buffer_pool_size to 80% [...]
June 1, 2015
New PERFORMANCE_SCHEMA defaults in MySQL 5.7.7
I thought it was worth a moment to reiterate on the new Performance Schema related defaults that MySQL 5.7.7 brings [...]
May 15, 2015
MySQL QA Episode 2: Build a MySQL server – Git, Bazaar, Compiling & Build tools
Welcome to MySQL QA Episode 2: Build a MySQL Server – Git, Bazaar (bzr), Compiling, and Build Tools In this [...]
May 8, 2015
MySQL indexing 101: a challenging single-table query
We discussed in an earlier post how to design indexes for many types of queries using a single table. Here [...]