NOTE: If you have comments or correction, please send to our mailing list
GET PROXYSQL
  ProxySQL
1.3.2
MariaDB MaxScale
2.0.3
HAProxy
1.7
NGINX
1.11.8
MySQL Router
2.0
License
Open Source
(GPL)

(Proprietary)

(GPL)

(BSD-2-Clause)

(GPL)
Load balancing
Application Layer balancer
(transport layer only)

(transport layer only)

(transport layer only)
Weighted Balance
Topologies
MySQL Master/Slave Replication
(external script)

(external script)

(very limited)
MySQL Group Replication
(external script)

(not GA)
MySQL NDB Cluster
(external script)
Galera Replication
(external script)

(external sript)

(external sript)
Custom membership
(external script)

(HTTP request)

(yes commercial)
Protocols
MySQL native protocol
MySQL compression
(end to end)

(end to end)

(end to end)
Backend SSL encryption
(end to end)

(end to end)
Frontend SSL encryption
(end to end)

(end to end)
Binlog Server
Configuration
Local config file
Local reconfiguration
Remote reconfiguration
(yes commercial)
Zero downtime reconfiguration
Online upgrade (SO_REUSEPORT)
Connection Management
Connection Pooling
Backend connections limit
Frontend connections limit
Per user connections limit
Connection Multiplexing
Timeout in millisecond
(seconds only)

(seconds only)
Persistent Connection
Transaction tracking
User tracking
Schema tracking
Charset tracking
Session variables tracking
Routing
Queries read/write split
(regex)

(query classifier)
Port based routing
Query based routing
(regex)
Hint based routing
Sharding
Schema based sharding
User based sharding
Query based sharding
(regex)
Hint based sharding
Queries management
Rewrite
Recursive rewrite
Timeout
Retry on failure
Throttling
Query Throttling
Security
Firewall
Data Masking
Mirroring
Query mirroring
Query rewrite
Mirror statistics
Query Caching
Caching by query
Caching by user
Caching by schema
Caching by hint
Prepared statements
General PS support
PS metadata caching
PS reuse
Logging
All queries logging
JSON format
Streaming to Kafka
Export metrics
Locally
(limited)

(Network related)

(Network related)
Remotely
(Network related)

(Network related)
Queryable
(Using SQL)
Export to monitoring/trending tools
(graphite/prometheus/others)
Queries response time
(Top queries)
Queries digests
GET PROXYSQL