Monthly Archives - March 2017

Running Percona XtraDB Cluster on Windows … in Docker

wsrep-stages

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 previously were available only for Linux platforms.
We can […]

Read more

The Puzzling Performance of the Samsung 960 Pro

samsung 960 pro small

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 decided to take it for a test spin to see if […]

Read more

Percona Server for MySQL 5.5.54-38.7 is Now Available

Percona Server for MySQL 5.7

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 open-source and free. You can find release details in the 5.5.54-38.7 milestone […]

Read more

Dropping the Foreign Key Constraint Using pt-online-schema-change

pt-online-schema-change

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 on Hijacking Innodb Foreign Keys.
If you are trying to get rid of an unused […]

Read more

Webinar Wednesday March 22, 2017: TokuDB Troubleshooting

TokuDB Troubleshooting

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 is an alternative storage engine, designed for big data applications. It provides great write workload scalability features. While […]

Read more

Running Percona XtraBackup on Windows … in Docker

Pepper.com

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 share a way to run Percona XtraBackup in a Docker container (especially since […]

Read more

Prophet: Forecasting our Metrics (or Predicting the Future)

Prophet

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 how that metric will look in the future.
For example, it could be used to:

Predict […]

Read more

Percona XtraDB Cluster 5.7.17-27.20 is now available

Percona XtraDB Cluster 5.7

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 XtraDB Cluster 5.7.17-27.20 is now the current release, based on the following:

Percona Server 5.7.17-11
Galera Replication library 3.20
wsrep […]

Read more

Column Store Database Benchmarks: MariaDB ColumnStore vs. Clickhouse vs. Apache Spark

Column Store Database

This blog shares some column store database benchmark results, and compares the query performance of MariaDB ColumnStore v. 1.0.7 (based on InfiniDB), Clickhouse and Apache Spark.
I’ve already written about ClickHouse (Column Store database).
The purpose of the benchmark is to see how these three solutions work on a single big server, with many CPU cores and large amounts of RAM. […]

Read more

Percona Server for MongoDB: Dashing New LDAP Authentication Plugin

LDAP Authentication

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 Percona Server for MongoDB. Authentication is an essential […]

Read more