Emergency

Latest articles from our experts:

by

Percona now offering 24/7 support for MongoDB and ...

Today Percona announced the immediate availability of 24/7, enterprise-class support for MongoDB and TokuMX. The new support service helps organizations achieve maximum application performance without database bloat. Customers have round-the-clock access (365 days a year) …

Read More
 

by

MySQL QA Episode 7: Reducing Testcases for Beginne...

Welcome to MySQL QA Episode #7 – Reducing Testcases for Beginners: single-threaded reducer.sh! In this episode we’ll learn how to use reducer.sh. Topics discussed; reducer.sh introduction/concepts Basic configurable variables & their default reducer.sh settings INPUTFILE options …

Read More
 

by

Percona Live Amsterdam discounted pricing ends Jul...

The Percona Live Data Performance Conference in Amsterdam is just two months away and it’s going to be an incredible event. With a new expanded focus on MySQL, NoSQL, and Data in the Cloud, this …

Read More
 

by

Fractal Tree library as a Key-Value store

As you may know, Tokutek is now part of Percona and I would like to explain some internals of TokuDB and TokuMX – what performance benefits they bring, along with further optimizations we are working …

Read More
 

by

Bypassing SST in Percona XtraDB Cluster with binar...

In my previous post, I used incremental backups in Percona XtraBackup as a method for rebuilding a Percona XtraDB Cluster (PXC) node without triggering an actual SST. Practically this reproduces the SST steps, but it …

Read More
 

by

Bypassing SST in Percona XtraDB Cluster with incre...

Beware the SST In Percona XtraDB Cluster (PXC) I often run across users who are fearful of SSTs on their clusters. I’ve always maintained that if you can’t cope with a SST, PXC may not …

Read More
 

by

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 like pquery-prep-red.sh, pquery-clean-known.sh & pquery-results.sh 1. Quick re-cap and QA run setup 2. pquery-prep-red.sh 3. …

Read More
 

by

MongoDB benchmark: sysbench-mongodb IO-bound workl...

In this post I’ll share the results of a sysbench-mongodb benchmark I performed on my server. I compared MMAP, WiredTiger, RocksDB and TokuMXse (based on MongoDB 3.0) and TokuMX (based on MongoDB 2.4) in an …

Read More
 

by

MySQL QA Episode 5: Preparing Your QA Run with pqu...

Welcome to MySQL QA Episode #5! In this episode we’ll be setting up and running pquery for the first time… and I’ll also trigger some actual bugs (fun guaranteed)! I’ll also introduce you to mtr_to_sql.sh …

Read More
 

by

How to create a rock-solid MySQL database backup &...

Have you ever wondered what could happen if your MySQL database goes down? Although it’s evident such a crash will cause downtime – and surely some business impact in terms of revenue – can you …

Read More
 


InnoDB Posts

by

Using Cgroups to Limit MySQL and MongoDB memory us...

Quite often, especially for benchmarks, I am trying to limit available memory for a database server (usually for MySQL, but recently for MongoDB also). This is usually needed to test database performance in scenarios with …

Read More
 

by

Update on the InnoDB double-write buffer and EXT4 ...

In a post, written a few months ago, I found that using EXT4 transactions with the “data=journal” mount option, improves the write performance significantly, by 55%, without putting data at risk. Many people commented on …

Read More
 


Insight for DBAs Posts

by

MySQL QA Episode 10: Reproducing and Simplifying: ...

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 …

Read More
 

by

Multi-source replication in MySQL 5.7 vs Tungsten ...

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 …

Read More