ProxySQL VS MariaDB MaxScale

ProxySQL

ProxySQL: high-performance, GPL licensed MySQL proxy. It supports hundreds of thousands of concurrent connections and can be multiplexed to hundreds of servers.

MariaDB MaxScale

We are the company behind #MariaDB, the fastest growing #opensource #database. Download MariaDB at https://t.co/DtYwuH0FOl.

Landing page //
2023-05-23

Landing page //
2021-10-03

#ProxySQL Use Case Scenarios - #ProxySQL #Database Tutorial - René Cannaò - #Percona Live 2017

MariaDB MaxScale videos

+ Add

MariaDB MaxScale Filters

Category Popularity

0-100% (relative to ProxySQL and MariaDB MaxScale)

MariaDB MaxScale

MySQL Tools

66 66%

MySQL Tools

34% 34

Databases

64 64%

Databases

36% 36

Data Integration

55 55%

Data Integration

45% 45

Database Management

100 100%

Database Management

0% 0

User comments

Share your experience with using ProxySQL and MariaDB MaxScale. For example, how are they different and which one is better?

Social recommendations and mentions

Based on our record, ProxySQL seems to be more popular. It has been mentiond 10 times since March 2021. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.

ProxySQL mentions (10)

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