by Dmitriy Kostiuk | Jan 26, 2018 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.7.20-29.24 (PXC) on January 26, 2018. Binaries are available from the downloads section or our software repositories. NOTE: Due to new package dependency, Ubuntu/Debian users should use apt-get dist-upgrade,...
by Dmitriy Kostiuk | Jan 18, 2018 | Percona Software, ProxySQL
ProxySQL 1.4.4, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL...
by Marco Tusa | Jan 15, 2018 | Monitoring, MySQL, ProxySQL, Security
In this blog post, we’ll look at ProxySQL firewalling (how to use ProxySQL as a firewall). Not long ago we had an internal discussion about security, and how to enforce a stricter set of rules to prevent malicious acts and block other undesired queries. ProxySQL...
by David Ducos | Jan 2, 2018 | Insight for DBAs, Insight for Developers, MySQL, ProxySQL
In this post, we’ll look at how to improve queries using generated columns and ProxySQL instead of implementing a referenced table. Developers and architects don’t always have the time or complete information to properly analyze and design a database. That is...
by Dave Avery | Dec 29, 2017 | Benchmarks, MariaDB, MongoDB, MySQL
Let’s look at some of the most popular Percona Database Performance Blog posts in 2017. The closing of a year lends itself to looking back. And making lists. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open...
by Peter Zaitsev | Nov 14, 2017 | Insight for Developers, MariaDB, MongoDB, MySQL, Percona Events, Percona Software, ProxySQL, Webinars
Do you need to get to grips with MySQL proxies? Or maybe you could do with discovering the latest developments and plans for Percona’s software? Well, wait no more because … on Wednesday November 15, 2017, we bring you a webinar double bill. Join Percona’s...
by Colin Charles | Nov 13, 2017 | Cloud, Insight for DBAs, MariaDB, MongoDB, MySQL, Percona Live, PostgreSQL
Announcing the opening of the Percona Live Open Source Database Conference 2018 in Santa Clara, CA, call for papers. It will be open from now until December 22, 2017. Our theme is “Championing Open Source Databases,” with topics of MySQL, MongoDB and other open...
by Alexey Zhebel | Oct 30, 2017 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.7.19-29.22-3 on October 27, 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 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 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 | Aug 31, 2017 | MySQL, Percona Live, ProxySQL
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 Manjot Singh | Jul 20, 2017 | Insight for DBAs, ProxySQL
In this blog post, we’ll look at how to deploy ProxySQL. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. It...
by Alexey Zhebel | Jul 14, 2017 | Insight for DBAs, MariaDB, MongoDB, Monitoring, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona Monitoring and Management 1.2.0 on July 14, 2017. For installation instructions, see the Deployment Guide. Changes in PMM Server PMM Server 1.2.0 introduced the following changes: Updated Components Consul 0.8.5 Grafana 4.3.2...
by Alexey Zhebel | Jun 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.5 on June 21, 2017. For installation instructions, see the Deployment Guide. Changes in PMM Server PMM-667: Fixed the Latency graph in the ProxySQL Overview dashboard to plot microsecond values...
by Peter Zaitsev | Jun 7, 2017 | MySQL
In this blog post, I’ll look at how ProxySQL Admin behaves in some unusual and unexpected ways from a MySQL perspective. ProxySQL allows you to connect to its admin interface using the MySQL protocol and use familiar tools, like the MySQL command line client, to...
by Alexey Zhebel | Jun 2, 2017 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.7.18-29.20 on June 2, 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. NOTE: Due to...
by Alexey Zhebel | Jun 2, 2017 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.6.36-26.20 on June 2, 2017. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.36-26.20 is now the current release, based on the following: Percona Server...
by Ramesh Sivaraman | May 31, 2017 | Insight for DBAs, MySQL, Percona Software, ProxySQL
In this blog post, we’ll look at how Percona XtraDB Cluster maintenance mode uses ProxySQL to take cluster nodes offline without impacting workloads. Percona XtraDB Cluster Maintenance Mode Since Percona XtraDB Cluster offers a high availability solution, it...
by Alexey Zhebel | May 29, 2017 | Cloud, Insight for DBAs, Insight for Developers, MariaDB, MongoDB, Monitoring, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona Monitoring and Management 1.1.4 on May 29, 2017. For installation instructions, see the Deployment Guide. This release includes experimental support for MongoDB in Query Analytics, including updated QAN interface. Query...
by Marco Tusa | May 25, 2017 | Insight for DBAs, MySQL, Percona Software, ProxySQL
In this blog post, we’ll look at how ProxySQL and mirroring go together. Overview Let me be clear: I love ProxySQL, and I think it is a great component for expanding architecture flexibility and high availability. But not all that shines is gold! In this post, I...
