by Stephane Combaudon | Aug 19, 2015 | MySQL
I have heard this question quite often: “At busy times, our replicas start lagging quite frequently. We are using N schemas, so which performance boost could we expect from MySQL 5.6 parallel replication?” Here is a quick way to give you a rough estimate...
by Kortney Runyan | Aug 18, 2015 | Insight for DBAs, Percona Events, Percona Live
In the past years, both MySQL 5.6, MySQL 5.7 and MariaDB 10 have been successful implementing new features. For many DBAs, the “old way” of replicating data is comfortable so taking the action to implement these new features seems like a momentous leap...
by Sveta Smirnova | Aug 17, 2015 | Insight for DBAs, MySQL, Percona Software
In MySQL QA Episode #12, “MySQL is Crashing, now what?,” Roel demonstrated how to collect crash-related information that will help Percona discover what the issue is that you are experiencing, and fix it. As a Support Engineer I (Sveta) am very happy to...
by Tom Diederich | Aug 13, 2015 | MySQL, Percona Events, Percona Live
Storage. Everyone needs it. Whether your data is in MySQL, a NoSQL, or somewhere in the cloud, with ever-growing data volumes – along with the need for SSDs to cut latency and replication to provide insurance – an organization’s storage footprint is an...
by Roel Van de Paar | Aug 13, 2015 | Insight for DBAs, Insight for Developers, MySQL
Welcome to the final – but most important – episode in the MySQL QA Series. In it, I present my vision for all MySQL Quality Assurance – for all distributions – worldwide. Episode 13: A Better Approach to all MySQL Regression, Stress &...
by Kortney Runyan | Aug 12, 2015 | Percona Events, Percona Live
The countdown is on for the annual Percona Live Data Performance Conference and Expo in Europe! This year the conference will be taking place in the great city of Amsterdam September 21-23rd. This three day conference will focus on the latest trends, news and best...
by Muhammad Irfan | Aug 12, 2015 | MySQL
MySQL replication is a process that allows you to easily maintain multiple copies of MySQL data by having them copied automatically from a master to a slave database. It’s essential to make sure the slave servers have the same set of data as the master to ensure...
by Roel Van de Paar | Aug 11, 2015 | Insight for DBAs, Insight for Developers, MySQL
My server is crashing… Now what? This special episode in the MySQL QA Series is for customers or users experiencing a crash. A crash? Cheat sheet: https://goo.gl/rrmB9i Sever install & crash. Note this is as a demonstration: do not action this on a...
by Stephane Combaudon | Aug 7, 2015 | Benchmarks, MySQL
During the last couple of months I have been involved in an unusually high amount of performance audits for e-commerce applications running with Magento. And although the systems were quite different, they also had one thing in common: the MySQL query cache was very...
by Jay Janssen | Aug 5, 2015 | MySQL, Percona Software
IST Basics State transfers in Galera remain a mystery to most people. Incremental State transfers (as opposed to full State Snapshot transfers) are used under the following conditions: The Joiner node reports Galera a valid Galera GTID to the cluster The Donor node...
by Roel Van de Paar | Aug 4, 2015 | Insight for DBAs, Insight for Developers, MySQL
Today’s episode is all about Valgrind – from the pro’s to the con’s, from the why to the how! This episode will be of interest to anyone who is or wants to work with Valgrind on a regular or semi-regular basis. Pro’s/Why Con’s How...
by Hrvoje Matijakovic | Aug 3, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.2.12 on August 3, 2015. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for...
by Vadim Tkachenko | Aug 3, 2015 | MongoDB, MySQL
In my recent benchmarks for MongoDB, we can see that the two engines WiredTiger and TokuMX struggle from periodical drops in throughput, which is clearly related to a checkpoint interval – and therefore I correspond it to a checkpoint activity. The funny thing...
by Roel Van de Paar | Jul 31, 2015 | Insight for DBAs, Insight for Developers, MySQL
Welcome to the 10th episode in the MySQL QA series! Today we’ll talk about reproducing and simplifying: How to get it Right. Note that unless you are a QA engineer stuck on a remote, and additionally difficult-to-reproduce or difficult-to-reduce bug, this...
by Sveta Smirnova | Jul 30, 2015 | MySQL
Lately, I saw many cases when users specified the option --base64-output=DECODE-ROWS to print out a statement representation of row events in MySQL binary logs just to get nothing. Reason for this is obvious: option --base64-output=DECODE-ROWS does not convert row...
by Francisco Bordenave | Jul 29, 2015 | Benchmarks, Insight for DBAs, MySQL
MySQL 5.7 comes with a new set of features and multi-source replication is one of them. In few words this means that one slave can replicate from different masters simultaneously. During the last couple of months I’ve been playing a lot with this trying to...
by Roel Van de Paar | Jul 28, 2015 | Insight for DBAs, Insight for Developers, MySQL
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 will explore how to use reducer.sh to do true multi-threaded testcase reduction – a world’s first. Topics:...
by Vadim Tkachenko | Jul 24, 2015 | Benchmarks, MySQL, Percona Software
Previously I tested Tokutek’s Fractal Trees (TokuMX & TokuMXse) as MongoDB storage engines – today let’s look into the MySQL area. I am going to use modified LinkBench in a heavy IO-load. I compared InnoDB without compression, InnoDB with 8k...
by Akshay Suryawanshi | Jul 23, 2015 | Hardware and Storage, Insight for DBAs, MySQL, Webinars
Thank you for attending my July 15 webinar, “Creating Best in Class Backup solutions for your MySQL environment.” Due to the amount of content we discussed and some minor technical difficulties faced near the end of webinar we have decided to cover the...
by Roel Van de Paar | Jul 23, 2015 | Insight for DBAs, Insight for Developers, MySQL
Welcome to MySQL QA Episode 8: Reducing Testcases for Engineers: tuning reducer.sh Advanced configurable variables & their default/vanilla reducer.sh settings FORCE_SKIPV FORCE_SPORADIC TIMEOUT_COMMAND & TIMEOUT_CHECK MULTI_THREADS MULTI_THREADS_INCREASE...
