ProxySQL Reviews and details

Social recommendations and mentions

• Save Cost on RDS Data Transfer - Internet - Out

  Another option could be ProxySQL, where you can cache queries on the ProxySQL server. Source: about 1 year ago

• Is replication between v5.1 and v8 possible?

  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 1 year ago

• SSL Termination for SQL

  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 1 year ago

• Business complexity with performance

  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 1 year ago

• Advanced caching mechanisms using distributed locks and async pub/sub systems.

  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 / over 1 year ago

• How to reverse proxy a SQL server?

  There are also specific proxy implementations for sql, https://proxysql.com/ comes to mind. Source: almost 2 years ago

• Accessing a server without direct conmection

  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: almost 2 years ago

• Linux kernel memory leaks Ubuntu 20.04 (5.4 and 5.8 kernels vs 4.4 kernel)

  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 2 years ago

• Software for SQL query management?

  You could give a try with ProxySQL - https://proxysql.com/. Source: over 2 years ago

• RDS writer and reader load balancing

  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 3 years ago