EmergencyEMERGENCY? Get 24/7 Help Now!

ProxySQL Improves MySQL SSL Connections

 | September 19, 2017 |  Posted In: MySQL, 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

How Life360 Used ProxySQL to Lower Its Database Load

 | September 1, 2017 |  Posted In: Percona Server, ProxySQL, Solutions Engineering

ProxySQL

In this blog post, we’ll look at how to use ProxySQL to help the database load by handling PINGs. I’ve blogged before about one of our regular clients, Life360. One of the issues they recently had was the PING command taking about 30%-40% of total queries per second across their database infrastructure. This is a non-trivial […]

Read More

Percona Live Europe Featured Talks: Orchestrating ProxySQL with Orchestrator and Consul with Avraham Apelbaum

 | August 31, 2017 |  Posted In: MySQL, Percona Live, ProxySQL

Colin Charles

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. This blog post is with Avraham Apelbaum, DBA and DevOps at […]

Read More

This Week in Data with Colin Charles #3: More Percona Live Europe!

 | August 25, 2017 |  Posted In: MariaDB, MongoDB, MySQL, MySQL 8.0, open source databases, Percona Live, PostgreSQL, Prometheus, ProxySQL

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. We are five weeks out to the conference! The tutorials and the sessions have been released, and there’s an added bonus – you can now look at all this in a grid view: tutorials, day […]

Read More

Where Do I Put ProxySQL?

 | July 20, 2017 |  Posted In: High-availability, ProxySQL, Replication

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 was created for DBAs by René Cannaò, as a means of solving […]

Read More

ProxySQL-Assisted Percona XtraDB Cluster Maintenance Mode

 | May 31, 2017 |  Posted In: High-availability, MySQL, Percona XtraDB Cluster, ProxySQL

Percona XtraDB Cluster Maintenance Mode

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 must consider a data flow where a cluster node gets taken down for maintenance (through isolation from a cluster […]

Read More

Percona Monitoring and Management 1.1.4 is Now Available

 | May 29, 2017 |  Posted In: Database Monitoring, Docker, Events and Announcements, Insight for Developers, MariaDB, MongoDB, MySQL, Orchestrator, Percona Monitoring and Management, Percona Server, Percona Server for MongoDB, Percona Software, PMM, Prometheus, ProxySQL

Percona Monitoring and Management

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.

Read More

What About ProxySQL and Mirroring?

 | May 25, 2017 |  Posted In: MySQL, Percona Monitoring and Management, Percona XtraDB Cluster, ProxySQL, ProxySQL, Replication

ProxySQL and Mirroring

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 want to correctly set some expectations, and avoid selling […]

Read More

Percona Monitoring and Management 1.1.3 is Now Available

 | April 21, 2017 |  Posted In: Database Monitoring, Events and Announcements, MariaDB, MongoDB, MySQL, Orchestrator, Percona Monitoring and Management, Percona Server, Percona Server for MongoDB, Percona Software, Percona XtraDB Cluster, PMM, Prometheus, ProxySQL, ProxySQL

Percona Monitoring and Management

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 fixes and improvements.

Read More