Our company provides services to other companies, one of which is critical because it is used by all of our clients and has a high number of visits. We need a quick application response to provide good service to customers, while also having a scalable and secure solution. That's what MariaDB MaxScale provides.
If you have a cluster of nodes with MariaDB MaxScale and you want all the
nodes of the cluster to have a similar load and not to be be
penalized for queries or writes to the database, you can mount the MaxScale product in front of the MariaDB cluster. MaxScale will balance the requests based on what is being sent to each
node to have an equitable load and will cache the queries that it
sends to each one. This optimizes the response time to
database queries and spreads the load out among all nodes in a
similar way.
ProxySLQ allows many simultaneous connections and allows the cache of queries in memory but it does not have high availability or scalability natively, only through external tools. HAProxy is not able to perform load balancing in an optimal way.
Instead, MariaDB MaxScale allows high availability, scalability, and data replication to external systems such as Kafka. In addition, MaxScale has a monitor that allows you to see the status of the set of databases.
MariaDB MaxScale is a powerful tool and easy to use. It has helped us a lot to improve the performance of our database queries. It implements a security layer that acts as a firewall for the databases, masks the data, or limits the results of the queries. It also integrates easily with Kafka.
We have launched several inquiries to MariaDB MaxScale support, and they have always responded very quickly. They also want to hold frequent meetings with the client to get their opinion understand how they can help. I see a very human support that is concerned about the customer.
By paying for the support, you are helping to improve the tool (and it is a way of recognizing that they are doing their job) in addition to ensuring that in the event of a breakdown you will have a great team ready to help you. My experience with support, except once, has always been very good.
We had a performance issue with a MariaDB MaxScale node which was causing the service we provide to clients to be slow. We could not solve the problem and opened a case with them and their support engineers helped us until we managed to detect the problem and optimize the configuration.