Tag - ProxySQL

Generated Columns and ProxySQL Instead of Referenced Tables

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

Percona Database Performance Blog Year in Review: Top Blog Posts

Percona Database Performance Blog

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 source community with insights, technical support, predictions and metrics around multiple […]

Read more

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

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 – MySQL […]

Read more

Percona Live Open Source Database Conference 2018 Call for Papers Is Now Open!

Percona Live

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 source databases, including PostgreSQL, time series databases and RocksDB. Sessions tracks include Developers, Operations […]

Read more

Percona XtraDB Cluster 5.7.19-29.22-3 is now available

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 Replication library 3.22
wsrep […]

Read more

Percona XtraDB Cluster 5.7.19-29.22 is now available

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 Replication library 3.22
wsrep […]

Read more

ProxySQL Improves MySQL SSL Connections

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

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

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

Where Do I Put ProxySQL?

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

Percona Monitoring and Management 1.2.0 is Now Available

Percona Monitoring and Management

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
Orchestrator 2.1.5
Prometheus 1.7.1

New Features

PMM-737: New graphs in System Overview dashboard:

Memory Advanced Details
Saturation Metrics

PMM-1090: Added ESXi support for PMM Server virtual appliance.

UI Fixes

PMM-707: Fixed QPS metric in MySQL Overview dashboard to always show queries […]

Read more