by Hrvoje Matijakovic | May 10, 2017 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server for MySQL 5.5.55-38.8 on May 10, 2017. Based on MySQL 5.5.55, including all the bug fixes in it, Percona Server for MySQL 5.5.55-38.8 is now the current stable release in the 5.5 series. Percona Server for MySQL is...
by Alexander Rubin | May 8, 2017 | Insight for DBAs, MySQL
In this blog post, I’ll review how a hung MySQL transaction can cause the InnoDB history length to grow and negatively affect MySQL performance. Recently I was helping a customer discover why SELECT queries were running slower and slower until the server restarts...
by Michael Coburn | May 4, 2017 | MongoDB, Monitoring, MySQL, Percona Software
I heard a frequent question at last week’s Percona Live conference regarding Percona Monitoring and Management (PMM): How much disk space should I allocate for PMM Server? First, let’s review the three components of Percona Monitoring and Management that...
by Peter Zaitsev | May 2, 2017 | Insight for DBAs, Insight for Developers, MongoDB, MySQL, Percona Events
In 2013 we started Percona University, which consists of technology discussion events held in different cities around the world. The next installments of Percona University in Europe are next week when I fly there for Percona University Berlin (May 9) and Percona...
by Dave Avery | Apr 28, 2017 | Cloud, Insight for DBAs, MariaDB, MongoDB, MySQL, Percona Live, Storage Engine
From everyone at Percona and Percona Live 2017, we’d like to send a big thank you to all our sponsors, exhibitors, and attendees at this year’s conference. This year’s conference was an outstanding success! The event brought the open source database community...
by Dave Avery | Apr 27, 2017 | Insight for DBAs, MariaDB, MongoDB, MySQL, Percona Live, Percona Software, Storage Engine
Welcome to the third (and final) day of the Percona Live Open Source Database Conference 2017, and the third (and final) set of Percona Live keynotes! The enthusiasm hasn’t waned here at Percona Live, and we had a full house on Thursday morning! Day three of the...
by Dave Avery | Apr 26, 2017 | MySQL, Percona Live
Every day at Percona Live 2017 brings something new and unusual – and on this particular day, we found out that MySQL makes toast. A lot of people think that with MySQL and open source software, you can do anything. While many might view this metaphorically,...
by Dave Avery | Apr 26, 2017 | Cloud, MariaDB, MySQL, Percona Live
Percona Live 2017 is done for Wednesday, but there was still time to get in one more talk before tonight’s Community Networking Reception – and the last one of the evening was about Amazon RDS. Darin Briskman, Lead Developer Outreach & Technical Evangelist...
by Dave Avery | Apr 26, 2017 | MariaDB, MySQL, Percona Live, PostgreSQL
The afternoon at Percona Live 2017 is slipping by quickly, and people are still actively looking for sessions to attend – like the session I just sat in on histograms in MySQL and MariaDB. Histograms are a type of column statistic that provides more detailed...
by Dave Avery | Apr 26, 2017 | Cloud, Percona Live
Percona Live 2017 is rolling along, and now that everybody got through lunch we’re all recharged and ready for the afternoon. Let’s start it out with Amazon Aurora. Once of the best-attended sessions was Sailesh Krishnamurthy’s (Senior Engineering...
by Dave Avery | Apr 26, 2017 | Insight for DBAs, Insight for Developers, MySQL, Percona Live
Welcome to the second day of the Percona Live Open Source Database Conference 2017, and the second set of Percona Live keynotes! It’s a bit rainy outside today, but that isn’t bothering the Percona Live attendees (we’re all indoors learning about new...
by Dave Avery | Apr 25, 2017 | MySQL, Percona Live
Breakout sessions are in full swing at the Percona Live Open Source Database Conference 2017. Check out what’s new in MySQL 8.0. We’ve finished with this morning’s sessions, and this morning saw a lot of amazing open source talks. One of the most...
by Dave Avery | Apr 25, 2017 | MongoDB, MySQL, Percona Live
Welcome to the first day of the Percona Live Open Source Database Conference 2017, and the first set of Percona Live keynotes! It’s a beautiful day in Santa Clara, but we don’t know because we’re inside the Hyatt Regency Convention Center listening...
by Dave Avery | Apr 25, 2017 | Benchmarks, Cloud, Insight for DBAs, MariaDB, MongoDB, MySQL, Percona Live, Storage Engine
Welcome to the first day of the Percona Live Open Source Database Conference: Percona Live 2017 tutorials day! While technically the first day of the conference, this day focused on provided hands-on tutorials for people interested in learning directly how to use open...
by Vadim Tkachenko | Apr 22, 2017 | Hardware and Storage, Insight for DBAs, Insight for Developers, MySQL
In this blog, we’ll look at how to achieve better-than-linear scaling. Scalability is the capability of a system, network or process to handle a growing amount of work, or its potential to be enlarged to accommodate that growth. For example, we consider a system...
by Andrew Moore | Apr 21, 2017 | Cloud, MySQL, Security
This quick post demonstrates using Percona Server for MySQL in Docker Swarm with some new authentication provisioning practices. Some small changes to the startup script for the Percona-Server container image allows us to specify a file that contains password values...
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 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 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 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...