Load Balancing
ProxySQL provides advanced load balancing and query routing capabilities, which helps in distributing database requests efficiently across multiple MySQL servers, improving performance and fault tolerance.
Query Caching
It offers query caching to reduce the load on the backend servers by caching the results of frequent or similar queries, thus improving response times for repeated requests.
High Availability
ProxySQL supports failover and high availability features, which ensure minimal downtime by automatically rerouting queries to healthy backend servers when one server becomes unavailable.
Query Optimization
The tool allows for real-time query filtering, rewriting, and optimization, enabling administrators to tune database performance without touching the application code.
Security Features
ProxySQL provides multi-layer security controls, including traffic encryption, user authentication, and firewall rules, enhancing the overall security posture of the database environment.
Support for Multiple MySQL Versions
It supports multiple MySQL and MariaDB versions, which makes it versatile and suitable for heterogeneous database environments.
We have collected here some useful links to help you find out if ProxySQL is good.
Check the traffic stats of ProxySQL on SimilarWeb. The key metrics to look for are: monthly visits, average visit duration, pages per visit, and traffic by country. Moreoever, check the traffic sources. For example "Direct" traffic is a good sign.
Check the "Domain Rating" of ProxySQL on Ahrefs. The domain rating is a measure of the strength of a website's backlink profile on a scale from 0 to 100. It shows the strength of ProxySQL's backlink profile compared to the other websites. In most cases a domain rating of 60+ is considered good and 70+ is considered very good.
Check the "Domain Authority" of ProxySQL on MOZ. A website's domain authority (DA) is a search engine ranking score that predicts how well a website will rank on search engine result pages (SERPs). It is based on a 100-point logarithmic scale, with higher scores corresponding to a greater likelihood of ranking. This is another useful metric to check if a website is good.
The latest comments about ProxySQL on Reddit. This can help you find out how popualr the product is and what people think about it.
ProxySQL is an open-source, high-performance MySQL proxy. It sits between Magento and MySQL and maintains a pool of backend connections that it multiplexes across incoming application connections. - Source: dev.to / about 1 month ago
The contention pattern from the previous sections, where 140 connections were blocked on a table-level lock, often starts as a connection management problem. Most relational databases carry overhead per connection: process or thread creation, memory allocation, and authentication. In PostgreSQL, idle connections share most memory pages with the parent process via Copy-on-Write, but actual overhead ranges from... - Source: dev.to / 3 months ago
Also check out ProxySQL [1][2], it's an extremely powerful and battle-tested proxy. Originally it was only for MySQL/MariaDB, where it is very widely used at scale, even despite MySQL already having excellent built-in scalable threaded connection management. But ProxySQL also added Postgres support too in 2024 and that has become a major focus. [1] https://proxysql.com/ [2] https://github.com/sysown/proxysql. - Source: Hacker News / 4 months ago
We use proxysql (https://proxysql.com) which works very well. We have not seen any downtime for years. We wrote our own master promotion code a very long time ago; it has proven to be very robust. - Source: Hacker News / over 1 year ago
Another option could be ProxySQL, where you can cache queries on the ProxySQL server. Source: about 3 years ago
Also, if you're not using it yet, I can recommend looking at ProxySQL to do your read-write/read-only failover controls. Source: over 3 years ago
What are the recommendations here? I took a look into ProxySQL and it looks like since v2, it can do frontend and backend SSL connections. I have it locally working on a docker setup. Source: over 3 years ago
DB: Split you write-read operations. You may scale read as needed. Write operations can be slow if you have too many indices, so make sure to use only the ones you really need. Your DBMS may have some configuration to optimise, for example in MySQL if you do NOT need ACID compliance you can set innodb_flush_log_at_trx_commit = 2 to achieve better write speed. For MySQL you should also look into https://proxysql.com/. Source: over 3 years ago
A Layer-7 Database Load Balancer is optional here. An L7-DBLB can be used for various use cases (eg: ProxySQL). One or more database instances handle queries from the web server. A Client-side DB query/connection load balancing can also be used instead of an L7-DBLB according to the use case of the application. - Source: dev.to / almost 4 years ago
There are also specific proxy implementations for sql, https://proxysql.com/ comes to mind. Source: almost 4 years ago
I'm not sure I fully understand your problem, so my answer maybe totally off ... Anyway : what about an SQL proxy like https://proxysql.com ? Source: about 4 years ago
There are better, modern query output caches these days that do a much better job than the original MySQL query cache. ProxySQL is a great query router/cache/pooler that can do a much better job than the original query cache. Source: over 4 years ago
You could give a try with ProxySQL - https://proxysql.com/. Source: over 4 years ago
If you want a single connection to be able to split out reads, you should look at proxysql since it can be asked to parse the sql and determine that a request is read-only, and perform that request on a node that is less busy and read-only. Source: about 5 years ago
Do you know an article comparing ProxySQL to other products?
Suggest a link to a post with product alternatives.
Is ProxySQL good? This is an informative page that will help you find out. Moreover, you can review and discuss ProxySQL here. The primary details have not been verified within the last quarter, and they might be outdated. If you think we are missing something, please use the means on this page to comment or suggest changes. All reviews and comments are highly encouranged and appreciated as they help everyone in the community to make an informed choice. Please always be kind and objective when evaluating a product and sharing your opinion.
