view counter

MySQL Feed

Oracle MySQL resources, news, and support articles.

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 the amount of content we discussed and some minor technical difficulties faced near the end of webinar we have decided to cover the fina

MySQL QA Episode 8: Reducing Testcases for Engineers: tuning

Welcome to MySQL QA Episode 8: Reducing Testcases for Engineers: tuning

  1. Advanced configurable variables & their default/vanilla settings
  2. Some examples

Full-screen viewing @ 720p resolution recommended.

SELinux and the MySQL init script

I recently worked with a customer who had a weird issue: when their MySQL server was started (Percona Server 5.5), if they try to run service mysql start a second time, the init script was not able to detect that an instance was already running. As a result, it tried to start a second instance with the same settings as the first one. Of course this fails and this creates a mess. What was the issue? A missing rule in SELinux. At least it looks like

Percona now offering 24/7 support for MongoDB and TokuMX

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) to the most trusted team of database experts in the open source community.

MySQL QA Episode 7: Reducing Testcases for Beginners – single-threaded!

Welcome to MySQL QA Episode #7 – Reducing Testcases for Beginners: single-threaded!In this episode we’ll learn how to use Topics discussed;

Percona Live Amsterdam discounted pricing ends July 26!

The Percona Live Data Performance Conference in Amsterdam is just two months away and it’s going to be an incredible event.

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 on.However, before going into deep details, I feel it is needed to explain the fundamentals of Key-Value store, and how Fractal Tree handles it.

MYSQL Sandbox 3.0.55 and new Github replication scripts


Both MySQL and MariaDB have been busy, each introducing new features, sometimes creating the same feature, often with different syntax.

Bypassing SST in Percona XtraDB Cluster with binary logs

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 can be handy if you already had backups available to use.

Bypassing SST in Percona XtraDB Cluster with incremental backups

Beware the SSTIn 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 be right for you, but that doesn’t change the fact that SSTs with multiple Terabytes of data can be quite costly.

view counter