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, Insight for DBAs, Insight for Developers, Percona Live
Today at Percona Live 2017, the afternoon is jam-packed with open source technology lectures filled with community members eager for the latest on the best strategies – including how you should deploy MongoDB on public clouds. Dharshan Rangegowda (CEO of ScaleGrid)...
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 David Bennett | Apr 26, 2017 | MongoDB, Percona Software
Percona no longer develops or supports TokuMX software. The product has been EoL’d. We recommend TokuMX users migrate to Percona Server for MongoDB. This blog post details how to migrate from TokuMX to Percona Server for MongoDB. As part of our ongoing plans to...
by Dave Avery | Apr 25, 2017 | Insight for DBAs, Percona Live
It looks like the first day of the Percona Live Open Source Database Conference 2017 is coming to a close. Before we shut it down for today, we’ll look at a presentation on Real-Time Data Loading from MySQL and Oracle into Analytics/Big Data. In this session,...
by Dave Avery | Apr 25, 2017 | Cloud, MySQL, Percona Live, PostgreSQL
The Percona Live Open Source Data Conference 2017 day one is rolling right along, and we’re already in the afternoon sessions. In this blog, we’ll look at Citus Data’s presentation on how to design your SaaS database to scale with Postgres. If you’re...
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 Krunal Bauskar | Apr 24, 2017 | MySQL, Percona Software
In this blog post, we’ll look at how we’ve improved wsrep-stages and related instrumentation in Percona XtraDB Cluster. Introduction When you execute a workload and need to find out what the given thread is working on, “SHOW PROCESSLIST” comes...
by Kenn Takara | Apr 24, 2017 | Insight for DBAs, Percona Software
In this blog post, I’ll discuss some changes to the behavior of the Percona XtraDB Cluster SST tmpdir option in the latest versions of Percona XtraDB Cluster 5.6.35-26.20-3 and 5.7.17-29.30. Previously, we did not use the path specified by the tmpdir. From...
by Kenn Takara | Apr 23, 2017 | Percona Software, Security
If you’ve tried to use SSL in Percona XtraDB Cluster and saw an error in the logs like SSL3_CHECK_CERT_AND_ALGORITHM:dh key too small, we’ve implemented some changes in Percona XtraDB Cluster 5.6.34 and 5.7.16 that get rid of these errors. Some background dh key too...
by Krunal Bauskar | Apr 23, 2017 | MySQL, Percona Software
In this blog post, we’ll look at a transaction replay anomaly in Percona XtraDB Cluster. Introduction Percona XtraDB Cluster/Galera replays a transaction if the data is non-conflicting but, the transaction happens to have conflicting locks. Anomaly Let’s...
by Krunal Bauskar | Apr 22, 2017 | MySQL, Percona Software
In this blog post, we’ll look at how increasing the fc_limit can affect SELECT latency. Introduction Recent Percona XtraDB Cluster optimizations have exposed fc_limit contention. It was always there, but was never exposed as the Commit Monitor contention was...
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 Alexey Zhebel | Apr 21, 2017 | Insight for DBAs, MariaDB, MongoDB, Monitoring, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona Monitoring and Management 1.1.3 on April 21, 2017. For installation instructions, see the Deployment Guide. This release includes several new graphs in dashboards related to InnoDB and MongoDB operation, as well as smaller...
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...
