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...
by Pablo Padua | Apr 17, 2017 | Insight for DBAs, MySQL, Percona Software
In this blog, we’ll look at the mysqlpump utility. mysqlpump is a utility that performs logical backups (which means backing up your data as SQL statements instead of a raw copy of data files). It was added in MySQL Server version 5.7.8, and can be used to dump...
by Dave Avery | Apr 13, 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 Tibor Korocz | Apr 12, 2017 | Insight for DBAs, MySQL
In this post, I am going to show you how you can minimize the performance impact of ProxySQL rules by using some finesse. Apply Test In my previous post, we could see the effect of the rules on ProxySQL performance. As we could also see, the “apply” option...
by marcos.albe | Apr 11, 2017 | Insight for DBAs, MySQL
As part of our support services, we do a lot of query optimization. This is where most performance gains come from. Here’s an example of the work we do. Some days ago a customer arrived with the following table: CREATE TABLE `infamous_table` ( `id` int(11) NOT...
by Tibor Korocz | Apr 10, 2017 | Benchmarks, MySQL, ProxySQL
In this blog post we are going to take a closer look at ProxySQL rules. How do they work, and how big is the performance impact of having many rules? I would like to say thank you to Renè, who was willing to answer all my questions during my tests. Overview ProxySQL...
by Alexander Rubin | Apr 7, 2017 | Insight for DBAs, MySQL
In this blog, we’ll look at how queries in systems with parallel processing can return rows in a non-deterministic order (and how to fix it). Short story: Do not rely on the order of your rows if your query does not use ORDER BY. Even with ORDER BY, rows with...
by marcos.albe | Apr 6, 2017 | Insight for DBAs, Insight for Developers, MySQL
Updated 7-05-2019 In this blog, we’ll look at how to resolve MySQL error code 1215: “Cannot add foreign key constraint”. Our Support customers often come to us with things like “My database deployment fails with error 1215”, “Am...
by Alexey Stroganov | Apr 5, 2017 | Benchmarks, MySQL, Percona Software
In this blog post, we’ll look at some of the available PMP profiling tools. While debugging or analyzing issues with Percona Server for MySQL, we often need a quick understanding of what’s happening on the server. Percona experts frequently use the pt-pmp...
by Hrvoje Matijakovic | Apr 5, 2017 | MySQL, Percona Events, Percona Software
Percona announces the GA release of Percona Server for MySQL 5.7.17-13 on April 5, 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 Dave Avery | Apr 4, 2017 | MariaDB, MongoDB, MySQL, Open Source, Percona Live, Webinars
Please join Percona’s CEO and Founder, Peter Zaitsev on April 6th, 2017 at 8:00 am PDT / 11:00 am EDT (UTC-7) as he presents Best Practices Migrating to Open Source Databases. Register Now This is a high-level webinar that covers the history of enterprise open source...
by Manjot Singh | Apr 4, 2017 | MongoDB, 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...
