Tag: ProxySQL

Feed: Planet MySQL; Author: ProxySQL; This post is the first of a series of blogposts on how to easily use ProxySQL to scale-out your application’s database workload on a Galera cluster. This series will explore the main concepts in configuring ProxySQL for Galera across three articles as follows: – A first introductory post describing the minimal configuration needed for ProxySQL to monitor and manage a Galera Cluster.– A second post describing how to setup a read/write split configuration for our Galera Cluster, using ProxySQL query rules.– A third and final post with examples on specific cluster configuration options and more ... Read More

Feed: Planet MySQL; Author: ProxySQL; ProxySQL participará en la próxima edición del evento open source “ESLIBRE”, que tendrá lugar los días 18th & 19th de Septiembre. La fecha coincidirá con el “Software Freedom Day”, día que celebra el Free Software en el mundo entero. El desarrollador senior de ProxySQL, Javier Jaramago Fernández, expondrá “Introducción a ProxySQL”, haciendo hincapié en la importancia de limitar el downtime tanto como sea posible, además de, exponer que otras herramientas ofrece ProxySQL y cómo podemos hacer uso de ellas para mejorar nuestra infraestructura. La charla se centrará en ProxySQL como proyecto, sus características, y la ... Read More

Feed: Planet MySQL; Author: ProxySQL; ProxySQL will be taking part in the upcoming EsLibre, open source event on the 18th & 19th of September. The date also coincides with ‘Software Freedom Day’ which celebrates Free Software, all over the world. ProxySQL’s Senior Developer, Javier Jaramango Fernandez, will be discussing ‘Introduction to ProxySQL’, focusing on the importance of limiting downtime as much as possible, as well as, the tools ProxySQL offers and how you can use them to improve your infrastructure. The talk will focus on the introduction of ProxySQL as a project, its characteristics, and the basic topology for its ... Read More

Feed: Planet MySQL; Author: ProxySQL; ProxySQL is proud to announce the release of the latest stable version of ProxySQL 2.0.14 on the 8th of September 2020ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded here or alternatively from the ProxySQL Repository, and freely usable and accessible according to the GNU GPL v3.0 license. Release Overview Highlights Before discussing the features and fixes in this release we’d like to mention that we are aware of the delays in new releases. Ideally we would like to release ProxySQL more rapidly however ... Read More

Feed: Planet MySQL; Author: The Pythian Group; After spending four years working with ProxySQL in production, I’ve learned a few interesting lessons about interpreting and processing query rules. I hope to save you some time (and avoid wrong turns) with this summary of ProxySQL query rules. ProxySQL query engine is very powerful and supports the building of complex rule sets. These can be used to route traffic to backend MySQL instances, rewrite queries, and for traffic mirroring, among other use cases. When the rule set is short and simple, you can easily understand what the outcome for a certain query ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; We sometimes receive challenging requests… this is a story about one of those times.The customer has implemented a sharding solution and would like us to review alternatives or improvements. We analyzed the possibility of using ProxySQL as it looked to be a simple implementation. However, as we had 200 shards we had to implement 200 rules — the first shard didn’t have much overload, but the latest one had to go through 200 rules and took longer.My first idea was to use FLAGIN and FLAGOUT creating a B-Tree, but the performance was the ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; ProxySQL brings a lot of value to your MySQL infrastructures such as Caching or Connection Multiplexing but it does not come free — your database needs to go through additional processing traffic which adds some overhead. In this blog post, we’re going to discuss where this overhead comes from and measure such overhead. Types of Overhead and Where it Comes From There are two main types of overhead to consider when it comes to ProxySQL — Network Overhead and Processing Overhead. Network Overhead largely depends on where you locate ProxySQL. For example, in case you deploy ... Read More

Feed: Planet MySQL; Author: ProxySQL; Due to the success and feedback we received from our last training course, we will be running another 2 sessions, both for European, as we well as Pacific Time zones Delivered by our Professional ProxySQL Trainers who have built and actively maintain ProxySQL. ProxySQL was built in order to help build, support and improve MySQL infrastructure. Our public 2x Day Training course highlights the fact that ProxySQL was built with very specific design goals in mind for user. We develop features that help in real-life events situations, and this is what we promise in our ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; In Percona Kubernetes Operator for Percona XtraDB Cluster (PXC) versions prior to 1.5.0, there were two methods for upgrading PXC clusters, and both of these use built-in StatefulSet update strategies. The first one is manual (OnDelete update strategy) and the second one is semi-automatic (RollingUpdate strategy). Since the Kubernetes operator is about automating the database management, and there are use cases to always keep the database up to date, a new smart update strategy was implemented.Smart Update StrategyThe smart update strategy can be used to enable automatic context-aware upgrades of PXC clusters between ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Rewriting a MySQL query for performance is an important process that every DBA should be aware of so they can fix the wrong queries on runtime without code changes on the application end. ProxySQL has great support for rewriting the queries, which Alkin Tezuysal already explored in his excellent blog ProxySQL Query Rewrite Use Case.So far, MySQL community provides two built-in query rewrite plugins to perform this task. Recently they introduced the plugin “ddl_rewriter”.query rewriter plugin : It has support for INSERT / UPDATE / DELETE / REPLACE statements from MySQL 8.0.12. ddl_rewritter plugin: It ... Read More