by Yves Trudeau | Dec 27, 2017 | MySQL, Percona Software, Security
In this blog, we’ll look at how the hidepid options for /proc and Percona XtraDB Cluster can fight with one another. One of the things I like about consulting at Percona is the opportunity to be exposed to unusual problems. I recently worked with a customer...
by Vadim Tkachenko | Nov 28, 2017 | MySQL
In this blog post I’ll look at the performance of Percona XtraDB Cluster on AWS using different service instances, and recommend some best practices for maximizing performance. You can use Percona XtraDB Cluster in AWS environments. We often get questions about...
by Jervin Real | Aug 11, 2017 | MySQL
In this post I’ll answer questions I received in my Wednesday, July 19, 2017, webinar Learning MySQL 5.7! First, thank you all who attended the webinar. The link to the slides and the webinar recording can be found here. I received a number of interesting...
by Dave Avery | Jun 19, 2017 | Insight for DBAs, MySQL, Percona Software, Webinars
Join Percona’s MySQL Practice Manager Kenny Gryp and QA Engineer, Ramesh Sivaraman as they present a high availability webinar around Percona XtraDB Cluster, Galera Cluster, MySQL Group Replication on Wednesday, June 21, 2017 at 10:00 am PDT / 1:00 pm EDT (UTC-7)....
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 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 Marco Tusa | Jan 19, 2017 | Insight for DBAs, MySQL, ProxySQL
In this blog post, we’ll look at how to set up ProxySQL for high availability. During the last few months, we’ve had a lot of opportunities to present and discuss a very powerful tool that will become more and more used in the architectures supporting...
by Krunal Bauskar | Nov 22, 2016 | Insight for DBAs, MySQL, Percona Software
In this blog I will provide answers to the questions and queries that some of you have raised during the webinar on Nov 17th. I would like to say thank you to all of the audience who attended the talk on November 17, 2016. You can also check the recording and slides...
by Dave Avery | Nov 15, 2016 | Insight for DBAs, MySQL, Percona Software, Webinars
Join Percona’s Percona XtraDB Cluster Lead Software Engineer Krunal Bauskar for a webinar on Thursday, November 17, 2016, at 7:30 am PST on MySQL High Availability with Percona XtraDB Cluster 5.7. Percona XtraDB Cluster 5.7 is our brand new MySQL 5.7 compatible...
by Hrvoje Matijakovic | Oct 4, 2016 | MySQL
Percona announces the new release of Percona XtraDB Cluster 5.6.32-25.17 on October 4, 2016. Binaries are available from the downloads area or our software repositories. Percona XtraDB Cluster 5.6.32-25.17 is now the current release, based on the following: Percona...
by Dave Avery | Sep 26, 2016 | Webinars
Please join Percona founder and CEO Peter Zaitsev for a webinar Wednesday, September 28 at 11 am PDT (UTC-7) where he’ll discuss Percona Software News and Roadmap Update – Q3 2016. Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona...
by Hrvoje Matijakovic | Sep 15, 2016 | MySQL, Percona Events, Percona Software, Security
Percona announces the new release of Percona XtraDB Cluster 5.6 on September 15, 2016. Binaries are available from the downloads area or our software repositories. Percona XtraDB Cluster 5.6.30-25.16.2 is now the current release, based on the following: Percona...
by Marco Tusa | May 26, 2016 | MySQL
Some time ago, I published the article on AWS Aurora Benchmarking (AWS Aurora Benchmarking – Blast or Splash?), in which I analyzed the behavior of different solutions using synchronous replication in AWS environment. This blog follows up with some of the...
by Przemysław Malkowski | Dec 21, 2015 | Insight for DBAs, MySQL, Percona Software
High Availability Have you ever wondered if your application should be able to work in read-only mode? How important is that question? MySQL seems to be the most popular database solution for web-based products. Most typical Internet application workloads consist of...
by Jay Janssen | Aug 20, 2015 | MySQL, Percona Software
State Snapshot Transfer (SST) at a glance PXC uses a protocol called State Snapshot Transfer to provision a node joining an existing cluster with all the data it needs to synchronize. This is analogous to cloning a slave in asynchronous replication: you take a full...
by Jay Janssen | Aug 5, 2015 | MySQL, Percona Software
IST Basics State transfers in Galera remain a mystery to most people. Incremental State transfers (as opposed to full State Snapshot transfers) are used under the following conditions: The Joiner node reports Galera a valid Galera GTID to the cluster The Donor node...
by Akshay Suryawanshi | Jul 23, 2015 | Hardware and Storage, Insight for DBAs, MySQL, Webinars
Thank you for attending my July 15 webinar, “Creating Best in Class Backup solutions for your MySQL environment.” Due to the amount of content we discussed and some minor technical difficulties faced near the end of webinar we have decided to cover the...
by Jay Janssen | Jul 16, 2015 | MySQL, Percona Software
In my previous post, I used incremental backups in Percona XtraBackup as a method for rebuilding a Percona XtraDB Cluster (PXC) node without triggering an actual SST. Practically this reproduces the SST steps, but it can be handy if you already had backups available...
by Jay Janssen | Jul 16, 2015 | MySQL, Percona Software
Beware the SST In Percona XtraDB Cluster (PXC) I often run across users who are fearful of SSTs on their clusters. I’ve always maintained that if you can’t cope with a SST, PXC may not be right for you, but that doesn’t change the fact that SSTs with...
