by Adamo Tonete | May 17, 2017 | Insight for DBAs, MongoDB, Security
In this blog post, we’ll walk through the native MongoDB authentication and roles, and learn how to create personalized roles. It is a continuation of Securing MongoDB instances. As said before, MongoDB features a few authentication methods and built-in roles that...
by Dave Avery | May 16, 2017 | Cloud, Insight for DBAs, MariaDB, MongoDB, Monitoring, MySQL, Percona Live, Storage Engine
The slides and videos from the Percona Live Open Source Database Conference 2017 are available for viewing and download. The videos and slides cover the keynotes, breakout sessions and MySQL and MongoDB 101 sessions. To view slides, go to the Percona Live agenda, and...
by Alexey Zhebel | May 15, 2017 | MongoDB, Percona Events, Percona Software
Percona announces the release of Percona Server for MongoDB 3.2.13-3.3 on May 15, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open-source, fully compatible, highly...
by Hrvoje Matijakovic | May 12, 2017 | MySQL, Percona Software, Storage Engine
Percona announces the GA release of Percona Server for MySQL 5.7.18-14 on May 12, 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 | May 12, 2017 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server for MySQL 5.6.36-82.0 on May 12, 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...
by Sveta Smirnova | May 11, 2017 | MySQL, Storage Engine, Webinars
In this blog post, we’ll look at MyRocks and the LOCK IN SHARE MODE. Those who attended the March 30th webinar “MyRocks Troubleshooting” might remember our discussion with Yoshinori on LOCK IN SHARE MODE. I did more tests, and I can confirm that his...
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 Tim Vaillancourt | May 10, 2017 | Insight for DBAs, Insight for Developers, MongoDB
In this blog post, I will cover the Percona-Lab/mongodb_consistent_backup tool and the improvements in the 1.0.1 release of the tool. Percona-Lab/mongodb_consistent_backup mongodb_consistent_backup is a tool for performing cluster consistent backups on MongoDB...
by Agustín | May 9, 2017 | Insight for DBAs, MySQL
In this post we’ll see how MariaDB’s Handler_icp_% counters status counters (Handler_icp_attempts and Handler_icp_matches) measure ICP-related work done by the server and storage engine layers, and how to see if our queries are getting any gains by using...
by Alexey Zhebel | May 9, 2017 | MongoDB, Percona Events, Percona Software
Percona announces the release of Percona Server for MongoDB 3.4.4-1.4 on May 9, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open source, fully compatible, highly-scalable,...
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 David Ducos | May 3, 2017 | Benchmarks, Insight for DBAs, MySQL
A lot of things have been said about UUID, and storing UUID in an optimized way. Now that we have generated columns, we can store the decomposed information inside the UUID and merge it again with generated columns. This blog post demonstrates this process. First, I...
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 | May 1, 2017 | MongoDB, MySQL, Open Source, Percona Services, Percona Software, Webinars
Come and listen to Percona CEO Peter Zaitsev on Thursday, May 4, 2017 at 11:00 am (PST) / 2:00 pm (EST) discuss Percona’s software news and roadmap, including Percona Server for MySQL and MongoDB, Percona XtraBackup, Percona Toolkit, Percona XtraDB Cluster and...
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, Percona Live
So that is just about a wrap here at Percona Live 2017 – except for the closing comments and prize giveaway. Before we leave, I have one more session to highlight: Facebook’s Beringei. Beringei is Facebook’s open source, in-memory time series database....
by Dave Avery | Apr 27, 2017 | Insight for DBAs, MySQL, Percona Live
The place is still frantic here at Percona Live 2017 as everybody tries to squeeze in a few more talks before the end of the day. One such talk was given by Red Hat’s Stefan Negrea on Hawkular Metrics. Hawkular Metrics is a scalable, long-term, high-performance...
by Dave Avery | Apr 27, 2017 | Cloud, MySQL, Percona Live
The last day of Percona Live 2017 is still going strong, with talks all the way until 4:00 pm (and closing remarks and a prize giveaway on the main stage then). I’m going to a few more sessions today, including one from Stephane Combaudon from Slice...
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...
