Introduction to Configuring and Using MariaDB MaxScale: Database Proxy Made Simple

[@adriandeveraaa]

Why would anyone want to go with MaxScale when you can achieve just about everything with HAProxy advanced cluster configurations?

[@alejandro_mariadb]

I like HAProxy. It's pretty cool. However, MaxScale has many features not present in HAProxy. Just to mention some of them: Automated failover for MariaDB Replication, query-based load balancing with ReadWriteSplit Router, connection-based load balancing with ReadConnRoute Router, data Import from Kafka and export to Kafka, cache filter for improved SELECT performance, security and traffic controls with auditing and SQL injection protection, web-based GUI for configuration (with REST service available too)

[@BriceCapelle]

We are switching to MaxScale because HAProxy can't do things like MaxScale does. HAProxy is basic and used mainly for HTTP. A database proxy is better with a database. HAProxy is better for HTTP.