by Alexander Rubin | May 24, 2016 | MySQL
In this blog, we’ll look at the MySQL 5.7 document store feature, and how it is implemented. Document Store MySQL 5.7.12 is a major new release, as it contains quite a number of new features: Document store and “MongoDB” like NoSQL interface to JSON...
by Przemysław Malkowski | May 24, 2016 | Insight for DBAs, MySQL, Percona Software
In this blog post we’ll discuss pt-online-schema-change, and how to correctly use it. Always use pt-osc? Altering large tables can be still a problematic DBA task, even now after we’ve improved Online DDL features in MySQL 5.6 and 5.7. Some ALTER types are...
by Dave Avery | May 24, 2016 | MySQL
Join Sveta on Thursday, May 26, 2016, at 10 am PDT (UTC-7) for her webinar Troubleshooting MySQL hardware resource usage. MySQL does not just run on its own. It stores data on disk, and stores data and temporarily results in memory. It uses CPU resources to perform...
by Dave Avery | May 23, 2016 | Insight for DBAs
Wondering what high availability (HA) solutions are most popular? Take our high availability poll below! 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...
by David Busby | May 23, 2016 | Percona Events
As of May 31st, 2016, we will be disabling TLSv1.0 support on www.percona.com, repo.percona.com, etc. This is ahead of the PCI changes that will affect the June 30th 2016 deprecation the TLSv1.0 protocol. (PDF) What does this mean for you the user? Based on analysis...
by Hrvoje Matijakovic | May 23, 2016 | MySQL, Percona Events, Percona Software
Percona is glad to announce the GA release of Percona XtraBackup 2.4.3 on May 23rd, 2016. Downloads are available from our download site and from apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for...
by Sveta Smirnova | May 20, 2016 | Insight for DBAs, MySQL, Webinars
In this blog, I will provide answers to the Q & A for the Troubleshooting Slow Queries webinar. First, I want to thank you for attending the April 28 webinar. The recording and slides for the webinar are available here. Below is the list of your questions that I...
by Alexey Zhebel | May 20, 2016 | MySQL
Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on May 20, 2016. Binaries are available from the downloads area or our software repositories. Percona XtraDB Cluster 5.6.29-25.15 is now the current release, based on the following: Percona...
by Vadim Tkachenko | May 19, 2016 | MySQL
In this blog post, we’ll discuss fixing MySQL scalability problems using either ProxySQL or thread pool. In the previous post I showed that even MySQL 5.7 in read-write workloads is not able to maintain throughput. Oracle’s recommendation to play black...
by Dave Avery | May 19, 2016 | Insight for DBAs, MongoDB
Please join David Murphy on Tuesday, May 24 at 10 am PDT (UTC-7) as he presents “Understanding how your MongoDB schema affects scaling, and when to consider sharding for help.” David will discuss the pros and cons of a few MongoDB schema design patterns on a...
by Alexey Zhebel | May 19, 2016 | MongoDB, Percona Events, Percona Software
Percona is pleased to announce the release of Percona Server for MongoDB 3.0.11-1.6 on May 19, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB 3.0.11-1.6 is an enhanced, open source, fully...
by Hrvoje Matijakovic | May 19, 2016 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.5.49-37.9 on May 19, 2016. Based on MySQL 5.5.49, including all the bug fixes in it, Percona Server 5.5.49-37.9 is now the current stable release in the 5.5 series. Percona Server is open-source and free....
by Miguel Angel Nieto | May 18, 2016 | MySQL
In this blog, we’ll discuss how to find the MySQL 5.7 root password. While new MySQL software security features are always welcome, they can impact use and performance. Now by default, MySQL 5.7 creates a password for the root user (among other changes) so the...
by Dave Avery | May 18, 2016 | MongoDB, MySQL
Please join Alexander Rubin, Percona Principal Consultant, for his webinar MongoDB administration for MySQL DBA on Thursday, May 19 at 10 am PDT (UTC-7). If you are a MySQL DBA and want to learn MongoDB quickly – this webinar is for you. MySQL and MongoDB share...
by Vadim Tkachenko | May 17, 2016 | MySQL
In this post, we’ll look at the results from some MySQL 5.7 read-write benchmarks. In my past blogs I’ve posted benchmarks on MySQL 5.5 / 5.6 / 5.7 in OLTP read-only workloads. For example: MySQL 5.7 sysbench OLTP read-only results: is MySQL 5.7 really...
by Muhammad Irfan | May 16, 2016 | MySQL
by Fernando Ipar | May 13, 2016 | Benchmarks, MongoDB
In this blog post, we’ll discuss how to benchmark MongoDB with sysbench. In an earlier post, I mentioned our use of sysbench-mongodb (via this fork) to run benchmarks of MongoDB servers. I now want to share our work extending sysbench to make it work with...
by Vadim Tkachenko | May 12, 2016 | MySQL
In this blog post, we’ll discuss ProxySQL versus MaxScale for OLTP RO workloads. Continuing my series of READ-ONLY benchmarks (you can find the other posts here and here), in this post I want to see how much overhead a proxy adds. At this In my opinion, there...
by Jay Janssen | May 11, 2016 | Cloud, MySQL
In this post, we’ll discuss how you can quick start MySQL testing using Docker, specifically in a Mac environment. Like a lot of people, I’m hearing a lot about Docker and it’s got me curious. The Docker ecosystem seems to be moving quickly, however,...
by Vadim Tkachenko | May 10, 2016 | MySQL
In this blog post, we’ll discuss how the Query Rewrite plugin can harm performance. MySQL 5.7 comes with Query Rewrite plugin, which allows you to modify queries coming to the server. (You can view the details...
