Buy Percona ServicesBuy Now!

ProxySQL Firewalling

 | January 15, 2018 |  Posted In: Database Monitoring, MySQL, ProxySQL, Security

ProxySQL Firewalling

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 came up as a possible tool that could help us in achieving […]

Read More

Generated Columns and ProxySQL Instead of Referenced Tables

 | January 2, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, ProxySQL

Generated Columns

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 why we see tables with more fields than needed, or with incorrect types. The […]

Read More

This Week in Data with Colin Charles 21: Looking Back on 2017 in the Open Source Database Community

 | December 29, 2017 |  Posted In: MariaDB, MySQL, Percona Live, ProxySQL

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. The end of the year is upon us, and this column is being penned a little earlier than usual as I enjoy a quick bout of wrapping up for the year. We’ve had a lot […]

Read More

Webinars on Wednesday November 15, 2017: Proxy Wars and Percona Software Update for Q4

and  | November 14, 2017 |  Posted In: Events and Announcements, Insight for Developers, MariaDB, MongoDB, MySQL, Percona Monitoring and Management, ProxySQL, Technical Webinars

Webinars double bill

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 Chief Evangelist, Colin Charles as he presents “The Proxy Wars […]

Read More

Percona XtraDB Cluster 5.7.19-29.22-3 is now available

 | October 30, 2017 |  Posted In: Events and Announcements, High-availability, MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL

Percona XtraDB Cluster 5.7

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 XtraDB Cluster 5.7.19-29.22-3 is now the current release, based on the following: Percona Server 5.7.19-17 Galera […]

Read More

Percona XtraDB Cluster 5.6.37-26.21-3 is Now Available

 | October 30, 2017 |  Posted In: Events and Announcements, High-availability, MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL

Percona XtraDB Cluster 5.7

Percona announces the release of Percona XtraDB Cluster 5.6.37-26.21-3 on October 27, 2017. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.37-26.21-3 is now the current release, based on the following: Percona Server for MySQL 5.6.37-82.2 Galera Replication library 3.21 wsrep API version 26 All Percona software is open-source and […]

Read More

Percona XtraDB Cluster 5.7.19-29.22 is now available

 | September 22, 2017 |  Posted In: Events and Announcements, High-availability, MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL

Percona XtraDB Cluster 5.7

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 XtraDB Cluster 5.7.19-29.22 is now the current release, based on the following: Percona Server 5.7.19-17 Galera […]

Read More

Percona XtraDB Cluster 5.6.37-26.21 is Now Available

 | September 20, 2017 |  Posted In: Events and Announcements, High-availability, MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL

Percona XtraDB Cluster 5.7

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 Server for MySQL 5.6.37-82.2 Galera Replication library 3.21 wsrep API version 26 All Percona software is open-source and […]

Read More

ProxySQL Improves MySQL SSL Connections

 | September 19, 2017 |  Posted In: ProxySQL, Security, SSL

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, mysql.connector.pooling in Python, etc.). Closing and making new connections over and over can greatly impact […]

Read More