by Kenn Takara | Apr 21, 2017 | MySQL, Percona Software, Security
In this blog post, we’ll look at a feature that recently added to Percona XtraDB Cluster 5.7.16, that makes it easier to configure Percona XtraDB Cluster SSL for all related communications. It uses mode “encrypt=4”, and configures SSL for both IST/Galera...
by Jaime Sicam | Apr 21, 2017 | Insight for DBAs, MySQL, Security
In this blog, we’ll look at how to setup and troubleshoot the Percona PAM authentication plugin. We occasionally get requests from our support clients on how to get Percona Server for MySQL to authenticate with an external authentication service via LDAP or...
by Kenn Takara | Apr 21, 2017 | Percona Software, Security
In this blog post, we’ll look at enabling Percona XtraDB Cluster SST Traffic Encryption, and some of the changes to the SSL-based encryption of SST traffic in Percona XtraDB Cluster 5.7.16. Some background Percona XtraDB Cluster versions prior to 5.7 support...
by Dave Avery | Apr 20, 2017 | Open Source, 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 Krunal Bauskar | Apr 20, 2017 | MySQL, Percona Software
In this blog post, we’ll look at how Percona XtraDB Cluster uses IST. Introduction Percona XtraDB Cluster uses the concept of an Incremental State Transfer (IST). When a node of the cluster leaves the cluster for a short period of time, it can rejoin the cluster...
by Krunal Bauskar | Apr 20, 2017 | MySQL, Percona Software
In this blog post, we’ll discuss trackable flow control in Percona XtraDB Cluster. Introduction Percona XtraDB Cluster has a self-regulating mechanism called Flow Control. This mechanism helps to avoid a situation wherein the weakest/slowest member of the...
by Dave Avery | Apr 20, 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 Krunal Bauskar | Apr 19, 2017 | MySQL, Percona Software
In this blog post, we’ll look at the actions and efforts Percona experts took to scale Percona XtraDB Cluster. Introduction When we first started analyzing Percona XtraDB Cluster performance, it was pretty bad. We would see contention even with 16 threads....
by Alexey Zhebel | Apr 19, 2017 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.6.35-26.20-3 on April 13, 2017. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.35-26.20-3 is now the current release, based on the following: Percona...
by Vadim Tkachenko | Apr 19, 2017 | MySQL, Percona Software
In our latest release of Percona XtraDB Cluster, we’ve introduced major performance improvements to the MySQLwrite-set replication layer. In this post, we want to show what these improvements look like. For the test, we used the sysbench OLTP_RW, UPDATE_KEY and...
by Alexey Zhebel | Apr 19, 2017 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.7.17-29.20 on April 19, 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 Hrvoje Matijakovic | Apr 18, 2017 | MySQL, Percona Software
Percona announces the GA release of Percona XtraBackup 2.4.7 on April 18, 2017. You can download it from our download site and apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large...
by Hrvoje Matijakovic | Apr 18, 2017 | MySQL, Percona Software
Percona announces the release of Percona XtraBackup 2.3.8 on April 18, 2017. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with...
by Peter Zaitsev | Apr 18, 2017 | MariaDB, MySQL, Percona Live
In this blog post, I’ll discuss some of my thoughts about the future of MariaDB after attending the M17 Conference. Let me start with full disclosure: I’m the CEO of Percona, and we compete with the MariaDB Corporation in providing Support for MariaDB and other...
by Vadim Tkachenko | Apr 17, 2017 | MySQL, Percona Software, Storage Engine
We have been working on bringing out a build of MyRocks with Percona Server for MySQL. MyRocks is a RocksDB-based storage engine. You can find more information about MyRocks here. While there is still a lot of work to do, I want to share an experimental build of...
by Pablo Padua | Apr 17, 2017 | Insight for DBAs, MySQL, Percona Software
In this blog, we’ll look at the mysqlpump utility. mysqlpump is a utility that performs logical backups (which means backing up your data as SQL statements instead of a raw copy of data files). It was added in MySQL Server version 5.7.8, and can be used to dump...
by Vadim Tkachenko | Apr 14, 2017 | MySQL
In this post, I’ll explain how to run Percona Server for MySQL and Percona Server for MongoDB on Bash on Windows on Ubuntu. We are getting a good number of questions about whether Percona Server (for both MySQL and MongoDB) is available for Windows for...
by Vlad Lesin | Apr 14, 2017 | MySQL
TokuDB Hotbackup is a solution that allows you to do backups on the fly. It works as a library that intercepts certain system calls that duplicate data written to already copied parts of files, so that at the end of the backup process the copied files contain the same...
by George O. Lorch III | Apr 13, 2017 | MySQL, Webinars
In this blog, we will provide answers to the Q & A for the TokuDB Troubleshooting webinar. First, we want to thank everybody for attending the March 22, 2017 webinar. The recording and slides for the webinar are available here. Below is the list of your questions...
by Dave Avery | Apr 13, 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...