EmergencyEMERGENCY? Get 24/7 Help Now!

Don’t Let a Leap Second Leap on Your Database!

 | December 27, 2016 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB, MySQL

Leap Second

This blog discusses how to prepare your database for the new leap second coming in the new year. At the end of this year, on December 31, 2016, a new leap second gets added. Many of us remember the huge problems this caused back in 2012. Some of our customers asked how they should prepare for this year’s event […]

Read More

MongoDB PIT Backups In Depth

 | December 16, 2016 |  Posted In: Cloud and NoSQL, High-availability, Insight for DBAs, Insight for Developers, MongoDB, open source databases, Percona Server for MySQL, Solutions Engineering

MongoDB PIT Backups

In this blog is an in-depth discussion of MongoDB PIT backups. Note: INTIMIDATION FREE ZONE!! This post is meant to give the reader most of the knowledge that is needed to understand the material. This includes basic MongoDB knowledge and other core concepts. I have tried to include links for further research where I can. […]

Read More

High Availability Poll Results

 | August 2, 2016 |  Posted In: High-availability, Insight for Developers

high availability poll

This blog reports the results of Percona’s high availability poll. High availability (HA) is always a hot topic. The reality is that if your data is not available, your customers cannot do business with you. In fact, estimates show the average cost of downtime is about $5K per minute. With an average outage taking 40 […]

Read More

MySQL Quality Assurance: A Vision for the Future by Roel Van de Paar (Final Episode 13)

 | August 13, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

MySQL Quality Assurance

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 & Feature Testing: Random Coverage Testing & SQL Interleaving 1. pquery Review 2. Random […]

Read More

MySQL QA Episode 12: My server is crashing… Now what? For customers or users experiencing a crash

 | August 11, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

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 production server! sudo yum install -y http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm sudo yum install -y Percona-Server-client-56 Percona-Server-server-56 sudo service […]

Read More

MySQL QA Episode 11: Valgrind Testing: Pro’s, Con’s, Why and How

 | August 4, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

MySQL QA Episode 11

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 Using the latest version sudo [yum/apt-get] install valgrind #OR# sudo [yum/apt-get] remove […]

Read More

MySQL QA Episode 10: Reproducing and Simplifying: How to get it Right

 | July 31, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

MySQL QA Episode 10

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 episode will largely be non-interesting for you. However, what you may like to see […]

Read More

MySQL QA Episode 9: Reducing Testcases for Experts: multi-threaded reducer.sh

 | July 28, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

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: Expert configurable variables & their default reducer.sh settings PQUERY_MULTI PQUERY_MULTI_THREADS PQUERY_MULTI_CLIENT_THREADS PQUERY_MULTI_QUERIES PQUERY_REVERSE_NOSHUFFLE_OPT Full-screen viewing @ 720p resolution […]

Read More