by Alexey Zhebel | Sep 27, 2017 | MongoDB, Percona Events, Percona Software
Percona announces the release of Percona Server for MongoDB 3.2.16-3.7 on September 27, 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 Lorraine Pocklington, Community Manager | Sep 27, 2017 | Percona Live
Day one of the Percona Live Europe Conference was a huge hit. The first day of sessions went well. People spoke on many different open source database topics, and talks were well-attended. One such talk I got to sit in was on Spatial Data in MySQL 8.0, given by...
by Lorraine Pocklington, Community Manager | Sep 27, 2017 | MongoDB, MySQL, Percona Live, Storage Engine
Black coffee was flowing this morning for day two Percona Live Europe 2017 Keynotes after many of the delegates had spent a good few hours the night before enjoying Irish hospitality at the Community Dinner. So today Laurie Coffin, Chief Marketing Officer for Percona,...
by Dave Avery | Sep 27, 2017 | MySQL, Percona Events, Percona Services, Percona Software
Pepper.com, the world’s largest community deal platform, has selected Percona to manage its open source database performance. Pepper.com’s around-the-clock community seeks and finds the best offers in fashion, electronics, traveling and much more. With 500 million...
by Lorraine Pocklington, Community Manager | Sep 26, 2017 | MongoDB, MySQL, Open Source, Percona Live, Percona Software
After yesterday’s very successful tutorial day, everyone looked forward to an inspiring first day of the conference and the Percona Live Europe 2017 keynotes. There were some fantastic keynotes delivered, and some excellent sessions scheduled. Laurie Coffin, Chief...
by Borys Belinsky | Sep 26, 2017 | MongoDB, MySQL, Percona Events, Percona Live, Percona Software
Percona announces the release of Percona Monitoring and Management 1.3.0 on September 26, 2017. Percona Monitoring and Management 1.3.0 introduces basic support for the MyRocks storage engine. There is a special dashboard in Metrics Monitor that presents the essential...
by Jervin Real | Sep 25, 2017 | Insight for DBAs, MySQL
In this blog post, we’ll look at how to avoid shared locks from subqueries. I’m pretty sure most of you have seen an UPDATE statement matching rows returned from a SELECT query: MySQL update ibreg set k=1 where id in (select id from ibcmp where id >...
by Lorraine Pocklington, Community Manager | Sep 25, 2017 | Insight for DBAs, Insight for Developers, MongoDB, MySQL, Percona Live
Welcome to the first day of the Percona Live Open Source Database Conference Europe 2017: Tutorials day! 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 source...
by Alexey Zhebel | Sep 22, 2017 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.7.19-29.22 on September 22, 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 Yves Trudeau | Sep 22, 2017 | Insight for DBAs, MySQL
For most people (including me until recently) database XA transactions are a fuzzy concept. In over eight years with Percona, I have never had to deal with XA transactions. Then a few weeks ago I got two customers having issues with XA transactions. That deserves a...
by Colin Charles | Sep 22, 2017 | Insight for DBAs, Insight for Developers, MongoDB, MySQL, Percona Events, Percona Live
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live Europe Dublin Are you affected by the Ryanair flight cancellations? Have you made alternative...
by Tyler Duzan | Sep 21, 2017 | Cloud, MySQL, Percona Services
This blog post will give a brief overview of Amazon RDS capabilities and limitations, and how Percona Support can help you succeed in your Amazon RDS deployments. One of the common questions that we get from customers and prospective customers is about Percona Support...
by Dave Avery | Sep 21, 2017 | Benchmarks, MySQL, Percona Live
Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter....
by Peter Zaitsev | Sep 20, 2017 | Insight for DBAs, Monitoring, MySQL
In this blog post, I will demonstrate how to run and use sysbench histograms. One of the features of sysbench that I often I see overlooked (and rarely used) is its ability to produce detailed query response time histograms in addition to computing percentile numbers....
by Alexey Zhebel | Sep 20, 2017 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.6.37-26.21 on September 20, 2017. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.37-26.21 is now the current release, based on the following: Percona...
by Dave Avery | Sep 19, 2017 | Insight for DBAs, MongoDB, Monitoring, MySQL, Percona Live
Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter....
by Jervin Real | Sep 19, 2017 | Insight for DBAs, ProxySQL, Security
In this blog post, we’ll look at how ProxySQL improves MySQL SSL connection performance. When deploying MySQL with SSL, the main concern is that the initial handshake causes significant overhead if you are not using connection pools (i.e., mysqlnd-mux with PHP,...
by Dave Avery | Sep 18, 2017 | Monitoring, Percona Software, Webinars
Join Percona’s, Principal Support Engineer, Markus Albe as he presents A Percona Support Engineer Walkthrough for pt-stalk on Tuesday, September 19, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). Register Now As a support engineer, I get dozens of pt-stalk captures from...
by Dave Avery | Sep 18, 2017 | Insight for DBAs, MongoDB, Monitoring, MySQL, Percona Live
Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter....
by Colin Charles | Sep 15, 2017 | MongoDB, MySQL
In this blog post, we talk about the results of Percona’s time series database poll “What Database Engine Are You Using to Store Time Series Data?” Time series data is some of the most actionable data available when it comes to analyzing trends and...