MariaDB MaxScale is not just restricted to a database proxy as it comprises of a MaxScale, which is a multi-threaded and an event-driven engine, which is not confined only to routing, like sending write statements to the Master and share read statements between the Slaves. In addition to it, MaxScale also entices advanced filtering, enhanced security and authentication.
Image Source: mariadb.com
You can handle the scalability and availability of your database cluster, and also secure it and manage the maintenance downtime with MaxScale plugins.
It’s easy to extend it with custom plugin to allow it to handle new tasks, which is possible due to the plugin architecture of MaxScale.
As per MariaDB, MaxScale’s unque features are-
Data Streaming
- Change Data Capture (CDC) allows you to replicate binlog events from MariaDB to Kafka in real time. This allows you to now leverage real-time data for machine learning or data analytics.
- A beta release supports binlog-to-Avro conversion and distribution modules. These modules allow MaxScale to connect to a MariaDB 10.0 Master server and convert the binary log events to Avro format change records.
High Availability
- The readwritesplit routing module supports a high availability read mode where read queries are allowed, even if the Master server goes down.
- The MariaDB monitor module, mysqlmon, supports stale states for both the Master and Slave servers. Even if the Master goes down, a Slave server will retain its Slave state and continue to be used as long as it is running.
Security
- End-to-end SSL secures data in motion.
- MaxAdmin can be configured to only accept local authorization based on the UNIX identity. This is a good security enhancement when you do not want admins accessing the system remotely.
- A new connection rate limitation reduces the impact of attacks before they are officially identified. You can specify the maximum number of connections for a service that when reached, further connection attempts will be rejected with an error.
The query classifier component has been changed, that MaxScale uses, when deciding what to do with a particular query. The first MariaDB to adopt the Business Source License (BSL) is MariaDB MaxScale 2.0. Instead of resorting to use a more closed license like Open Core, it is adopting the BSL. Thanks to its Open Source software by which anyone can modify, extend and compile the code, test the software and most will even be able to use the software for free. For active contributors, it gives free licenses. To harmonize ongoing development innovation, community contribution and sustainable engineering, MariaDB Corporation thinks that this new license provides a great way.