A great database proxy with great support
Use Cases and Deployment Scope
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.
Pros
- Open source proxy server
- Great performance
- Offers load balancing
- Modular architecture
Cons
- Improve balancing based on SQL queries
- Improve swap memory consumption
- It has a slight delay
Likelihood to Recommend
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.
