Tag: ProxySQL

Feed: Percona Database Performance Blog. Author: Jervin Real. Jervin Real  | September 19, 2017 |  Posted In: MySQL, ProxySQL, Security, SSL PREVIOUS POST 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 on your total query response time. A customer and colleague recently educated me that although you can improve SSL encryption/decryption performance with the AES-NI ... Read More

Feed: Planet MySQL; Author: René Cannaò; ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license!But not only! In today's release, ProxySQL 1.4.3, the most important feature is surely the support for ClickHouse as a backend!Clients can still connect to ProxySQL using the MySQL Protocol, and ProxySQL will query ClickHouse.Because of this, the above statement needs to be edited: ProxySQL doesn't support only MySQL! Support for ClickHouse is available only in packages for Ubuntu 16, Debian 9, CentOS 7, and Fedora 24, where the package name includes clickhouse.It is possible to download it here.ClickHouse ... Read More

Feed: Percona Database Performance Blog. Author: Yves Trudeau. Yves Trudeau  | September 15, 2017 |  Posted In: High-availability, Maxscale, MySQL, ProxySQL PREVIOUS POST This post is the third of a series focusing on the MySQL high availability solutions available in 2017. The first post looked at the elders, the technologies that have been around for more than ten years. The second post talked about the adults, the more recent and mature technologies. In this post, we will look at the emerging MySQL high availability solutions. The “baby” MySQL high availability solutions I chose for the blog are group replication, proxies and distributed storage ... Read More

Feed: Planet MySQL; Author: René Cannaò; In the two previous blog posts about ProxySQL Cluster we described how to setup a Cluster, how to add users/rules and propagate them across the Cluster, how to provision new nodes, how to re-sync nodes after they have been out of the Cluster, and some features in the roadmap, especially around the concept of core nodes vs satellite nodes.We also mention that there are 4 modules/tables that currently ProxySQL Cluster is able to sync: mysql_query_rules mysql_servers mysql_users proxysql_servers We covered 3 of these, and the last one missing is how to sync mysql_servers, related ... Read More

Feed: Planet MySQL; Author: René Cannaò; In the previous blog post we described what ProxySQL Cluster is, and how creating new users and new query rules in one of the node will result in all the other nodes being immediately aware of it and automatically sync.All looks very straightforward if all the nodes are all up and running when we make a configuration change. But how to handle cases in which nodes are not available, or they will join later? How to handle conclicts? DisclaimerBefore going forward, please remember that those features are EXPERIMENTAL and subject to changes. Automatic node ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; MySQL Team speaking at Percona Live Dublin 2017 – lefred's blog: tribulations of a MySQL Evangelist From September 25th to 27th 2017, the MySQL engineers and community team will be speaking at Percona Live Europe in Dublin. MySQL is also part of the contributing sponsors. For the conference, we tried to bring new faces to the Community. Usually, it’s always the same famous team leaders speaking at the conferences, this time, it’s not. A lot of key developers will present their own work. We have so much talented people in MySQL we want to ... Read More

Feed: Planet MySQL; Author: René Cannaò; ProxySQL enters the club of the software associated with the buzz word "Cluster".This blog post is the first in a series describing how to setup ProxySQL Cluster.For details on the implementation, please refer to the documentation in the wiki DisclaimerFeatures described are EXPERIMENTAL and subject to change. Preface ProxySQL is a decentralized proxy, recommended to be deployed close to the application. This approach scales pretty well even up to hundreds of nodes, as it was designed to be easily reconfigurable at runtime.This allows for simple configure a farm of ProxySQL instances using software like ... Read More

Feed: Planet MySQL; Author: René Cannaò; ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! Today I am excited to announce the release of ProxySQL 1.4.2, the second stable release of series 1.4.x . Binaries are available here . This release introduce several bug fixes and enhancements compared to previous version: introduced experimental native Cluster solution fixes random failure in handling PREPARE #1169 don't use connections from connection pool for fast_forward users #1157 reset SQL_MODE and TIME_ZONE when a connection is reset #1160 added reload command in init script #1154 several improvements to ... Read More

Feed: Percona Database Performance Blog. Author: Manjot Singh. Manjot Singh  | September 1, 2017 |  Posted In: Percona Server, ProxySQL, Solutions Engineering PREVIOUS POST 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 amount and was easily tens of thousands of pings per second. This added a significant amount of latency to real queries. A large ... Read More

Feed: Percona Database Performance Blog. Author: Dave Avery. Dave Avery  | August 31, 2017 |  Posted In: MySQL, Percona Live, ProxySQL PREVIOUS POST Welcome to another post 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 Wix.com His talk is titled Orchestrating ProxySQL with Orchestrator and Consul. The combination of ProxySQL and Orchestrator solves many problems, but still requires some manual ... Read More