EmergencyEMERGENCY? Get 24/7 Help Now!

This Week in Data with Colin Charles 28: Percona Live, MongoDB Transactions and Spectre/Meltdown Rumble On

 | February 16, 2018 |  Posted In: Amazon RDS, Events and Announcements, MariaDB, MongoDB, MySQL, open source databases, Percona Server for MySQL, PMM, PostgreSQL, ProxySQL, TokuDB

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. In case you missed last week’s column, don’t forget to read the fairly lengthy FOSDEM MySQL & Friends DevRoom summary. From a Percona Live Santa Clara 2018 standpoint, beyond the tutorials getting picked and […]

Read More

ProxySQL 1.4.5 and Updated proxysql-admin Tool Now in the Percona Repository

 | February 15, 2018 |  Posted In: Percona Server for MySQL, Percona XtraDB Cluster, ProxySQL

ProxySQL 1.4.5

ProxySQL 1.4.5, 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 and MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created […]

Read More

This Week in Data with Colin Charles 27: Percona Live Tutorials Released and a Comprehensive Review of the FOSDEM MySQL DevRoom

 | February 9, 2018 |  Posted In: Events and Announcements, InnoDB, MariaDB, MySQL, Percona Live, Percona Monitoring and Management, Percona Server for MySQL, PMM, ProxySQL, Replication

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live Santa Clara 2018 update: tutorials have been announced. The committee rated over 300+ talks, and easily 70% of the schedule should go live next week as well. In practice, then, you should see […]

Read More

ProxySQL Query Cache: What It Is, How It Works

 | February 7, 2018 |  Posted In: Insight for DBAs, MySQL, ProxySQL

ProxySQL query cache

In this blog post, I’ll present the ProxySQL query cache functionality. This is a query caching mechanism on top of ProxySQL. As there are already many how-tos regarding the ProxySQL prerequisites and installation process, we are going to skip these steps. For those who are already familiar with ProxySQL query cache configuration, let’s go directly […]

Read More

Percona XtraDB Cluster 5.7.20-29.24 Is Now Available

 | January 26, 2018 |  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.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, apt upgrade, or apt-get install percona-xtradb-cluster-57 to upgrade. Percona XtraDB Cluster 5.7.20-29.24 is now the current release, based […]

Read More

This Week in Data with Colin Charles 25: Meltdown/Spectre still dominate, FOSDEM approaches and Timescale gets funding

 | January 26, 2018 |  Posted In: Amazon Aurora, AWS, Events and Announcements, MongoDB, MySQL, MySQL 8.0, Percona Live, PostgreSQL, ProxySQL, XtraDB Cluster

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Still on Meltdown/Spectre, this time MariaDB Corporation has published Meltdown Vulnerability Impact On MariaDB Server – interesting the comparison between glibc/tcmalloc. Worthy Facebook thread about this too, with a bit of chat about MongoDB performance. […]

Read More

Percona XtraDB Cluster 5.6.38-26.23 Is Now Available

 | January 24, 2018 |  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.38-26.23 (PXC) on January 24, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.38-26.23 is now the current release, based on the following: Percona Server for MySQL 5.6.38 Galera/Codership WSREP API Release 5.6.38 Galera Replication library 3.21 All Percona software […]

Read More

This Week in Data with Colin Charles 24: more Meltdown, FOSDEM, Slack and reminiscing

 | January 19, 2018 |  Posted In: Events and Announcements, MongoDB, MySQL, ProxySQL

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. There is still much going on when it comes to Meltdown/Spectre in our world. Percona’s Vadim Tkachenko and Alexey Stroganov recently published Does the Meltdown Fix Affect Performance for MySQL on Bare Metal?. You also […]

Read More

ProxySQL 1.4.4 and Updated proxysql-admin Tool Now in the Percona Repository

 | January 18, 2018 |  Posted In: Percona Server for MySQL, Percona XtraDB Cluster, ProxySQL

ProxySQL 1.4.5

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 and MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created […]

Read More

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