Monthly Archives - June 2016

Webinar Thursday, June 9: Troubleshooting MySQL configuration issues

MongoDB Schema Design

Please join us on Thursday June 9, at 10:00 am PDT (UTC-7) for the webinar Troubleshooting MySQL configuration issues.
MySQL Server is highly tunable. It has hundreds of configuration options which provide great tuning abilities and, at the same time, can be the source of various issues.
In this webinar you will learn which types of options MySQL […]

Read more

Percona Server 5.7.12-5 is now available

percona server for MySQL

Percona is glad to announce the GA release of Percona Server 5.7.12-5 on June 6, 2016. Download the latest version from the Percona web site or from the Percona Software Repositories.
Based on MySQL 5.7.12, including all the bug fixes in it, Percona Server 5.7.12-5 is the current GA release in the Percona Server 5.7 series. All of […]

Read more

EL5 and why we’ve had to enable TLSv1.0 again

TLSv1.0

We have had to revert back to TLSv1.0.
If you saw my previous post on TLSv1.0 (https://www.percona.com/blog/2016/05/23/percona-disabling-tlsv1-0-may-31st-2016/), you’ll know I  wanted to deprecate TLSv1.0 well ahead of PCI’s changes. We made the changes May 31st.
Unfortunately, it has become apparent that EL 5, which is in the final phases of End Of Life, does not support TLSv1.1 or […]

Read more

MySQL 5.7 By Default 1/3rd Slower Than 5.6 When Using Binary Logs

binary logs make MySQL 5.7 slower

Researching a performance issue, we came to a startling discovery:
MySQL 5.7 + binlogs is by default 37-45% slower than MySQL 5.6 + binlogs when otherwise using the default MySQL settings.
Test server MySQL versions used:
i7, 8 threads, SSD, Centos 7.2.1511
mysql-5.6.30-linux-glibc2.5-x86_64
mysql-5.7.12-linux-glibc2.5-x86_64
mysqld –options:

–no-defaults –log-bin=mysql-bin –server-id=2
Run details:
Sysbench version 0.5, 4 threads, socket file connection
Sysbench Prepare: 

Shell

sysbench –test=/usr/share/doc/sysbench/tests/db/parallel_prepare.lua –oltp-auto-inc=off –mysql-engine-trx=yes –mysql-table-engine=innodb –oltp_table_size=1000000 […]

Read more

Galera warning “last inactive check”

MySQL high availability

In this post, we’ll discuss the Galera warning “last inactive check” and what it means.
Problem
I’ve been working with Percona XtraDB Cluster quite a bit recently, and have been investigating various warnings. I came across this one today:
[Warning] WSREP: last inactive check more than PT1.5S ago (PT1.51811S), skipping check
This warning is related to the evs.inactive_check_period […]

Read more

Percona Live Europe call for papers is now open!

Percona Live Europe Call for Papers

The Percona Live Europe 2016 call for papers is now officially open! We’re looking forward to seeing you in Amsterdam this October 3-5, and hearing your speak! Ask yourself “Do I have…”:

Fresh ideas?
Enlightening case studies?
Insight on best practices?
In-depth technical knowledge?

If the answer to any of these is “YES,” then you need to submit your proposal for a […]

Read more

Why use provisioned IOPS volumes for AWS databases?

In this blog, we’ll use some test results to look at the rationale for using provisioned IOPS volumes for AWS databases.
One piece of advice you often hear running MySQL, MongoDB or other databases in the AWS EC2 environment is that you should use volumes with provisioned IOPs. This kind of makes sense on the “marketing” […]

Read more

MongoDB Administration Checklist for MySQL DBAs

MongoDB Adminstration Checklist

In this blog, I discuss a MongoDB administration checklist designed to help MySQL DBAs.
If you are MySQL DBA, starting MongoDB administration is not always an easy transition. Although most of the concepts and even implementation are similar, the commands are different. The following table outlines the typical MySQL concepts and DBA tasks (on the […]

Read more

Embracing MongoRocks

This blog post discusses Percona’s future plans for TokuMX, PerconaFT, and MongoRocks for MongoDB 3.2 and later releases.
At Percona, we focus on providing the best solution for our customers, rather than falling into “big ego,” “not invented here” or “sunk cost fallacy” messages. We have limited engineering resources and want to concentrate on the things […]

Read more