by Vadim Tkachenko | Mar 27, 2017 | MySQL
In this blog, I’ll go over my thoughts on what we can expect in the world of SQL databases. After reading Baron’s prediction on databases, here: https://www.xaprb.com/blog/defining-moments-in-database-history/ I want to provide my own view on what’s...
by Alexey Zhebel | Mar 27, 2017 | MySQL, Percona Events, Percona Software
Percona announces the availability of Percona Toolkit 3.0.2 on March 27, 2017. Percona Toolkit is a collection of advanced command-line tools that perform a variety of MySQL and MongoDB server and system tasks too difficult or complex for DBAs to perform manually....
by Dave Avery | Mar 24, 2017 | MongoDB, MySQL, Percona Live
The Percona Live Open Source Database Conference 2017 in Santa Clara, California is just around the corner: April 24-27, 2017. We’re busy getting things ready to make sure everybody gets the most out of their time there. As part of that, we have some news and a couple...
by Hrvoje Matijakovic | Mar 24, 2017 | MySQL, Percona Events, Percona Software
Percona announces the GA release of Percona Server for MySQL 5.7.17-12 on March 24, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based...
by Hrvoje Matijakovic | Mar 24, 2017 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server 5.6.35-81.0 on March 24, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based on MySQL...
by Dave Avery | Mar 23, 2017 | MySQL, Percona Live
Welcome to another post in the series of Percona Live featured session blogs! In these blogs, we’ll highlight some of the session speakers that will be at this year’s Percona Live conference. We’ll also discuss how these sessions can help you improve your database...
by Vadim Tkachenko | Mar 23, 2017 | Cloud, MySQL, Percona Software
In this blog post, we’ll look at how to run Percona XtraDB Cluster on Windows using Docker. This is a follow-up to my previous post on Percona XtraBackup on Windows. The fact is that with Docker you can now run a variety of software applications on Windows that...
by Peter Zaitsev | Mar 22, 2017 | Benchmarks, Hardware and Storage, MySQL
In this blog post, I’ll take a look at the performance of the Samsung 960 Pro SSD NVME. First, I know the Samsung 960 Pro is a consumer SSD NVME drive, not intended for sustained data center workloads. But the AnandTech review looked good enough that I...
by Hrvoje Matijakovic | Mar 22, 2017 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server for MySQL 5.5.54-38.7 on March 22, 2017. Based on MySQL 5.5.54, including all the bug fixes in it, Percona Server for MySQL 5.5.54-38.7 is now the current stable release in the 5.5 series. Percona Server for MySQL is...
by Siddhant Sawant | Mar 21, 2017 | Insight for DBAs, MySQL
In this blog post, we’ll look at how to get rid of the unused Foreign Key (FK) constraint and/or related columns/keys with the help of pt-online-schema-change and the power of its plugins. Before we proceed, here is a useful blog post written by Peter Zaitsev...
by Dave Avery | Mar 21, 2017 | Webinars
Please join Percona’s Principal Technical Services Engineer, Sveta Smirnova, Senior Software Engineer, George Lorch and Software Engineer, Vlad Lesin as they present TokuDB Troubleshooting on March 22, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register Now TokuDB...
by Vadim Tkachenko | Mar 20, 2017 | MySQL, Percona Software
In this blog, we’ll look at running Percona XtraBackup on Windows via a Docker container. The question whether Percona XtraBackup is available for Windows comes up every so often. While we are not planning to provide regular releases for Windows, I decided to...
by Miguel Angel Nieto | Mar 20, 2017 | Insight for DBAs, MySQL
In this blog post, we’ll look at how Prophet can forecast metrics. Facebook recently released a forecasting tool called Prophet. Prophet can forecast a particular metric in which we have an interest. It works by fitting time-series data to get a prediction of...
by Alexey Zhebel | Mar 17, 2017 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.7.17-27.20 on March 16, 2017. Binaries are available from the downloads section or our software repositories. NOTE: You can also run Docker containers from the images in the Docker Hub repository. Percona...
by Alexander Rubin | Mar 17, 2017 | Insight for DBAs, MySQL
MariaDB no longer meeting your needs? Migrate to Percona software for MySQL – an open source,production-ready, and enterprise-grade MySQL alternative. Learn More This blog shares some column store database benchmark results, and compares the query performance...
by Dimitri Vanoverbeke | Mar 16, 2017 | MongoDB, Security
This blog post is another in the series on the Percona Server for MongoDB 3.4 bundle release. In this blog, we’ll look at the new LDAP authentication plugin. Hear ye, hear ye, hear ye… With the arrival of version 3.4, Percona has included an LDAP plugin in...
by Manjot Singh | Mar 16, 2017 | MariaDB, Monitoring, MySQL, Percona Software
In this blog post, I will discuss the solutions for monitoring databases (which includes alerting) I have worked with and recommended in the past to my clients. This survey will mostly focus on MySQL solutions. One of the most common issues I come across when working...
by Dave Avery | Mar 15, 2017 | MySQL
Welcome to another post in the series of Percona Live featured session blogs! In these blogs, we’ll highlight some of the session speakers that will be at this year’s Percona Live conference. We’ll also discuss how these sessions can help you improve your database...
by Adamo Tonete | Mar 15, 2017 | Insight for DBAs, Insight for Developers, MongoDB
by Shahriyar Rzayev | Mar 15, 2017 | Insight for DBAs
In this blog post, we’ll look at how to restore a single InnoDB table from a full backup after dropping the table. You can also see an earlier blog post about restoring a single table from a full backup here: How to recover a single InnoDB table from a full...