MariaDB Corp. debuted Thursday open source proxy MariaDB MaxScale to fully decouple applications and databases. MaxSxale is a database-centric proxy that works with MariaDB Enterprise, MariaDB Enterprise Cluster, MariaDB 5.5, MariaDB 10 and Oracle MySQL, and comes with pluggable architecture which has been designed to increase flexibility and aid customization.
MariaDB MaxScale speeds up and, in some cases eliminates the need for time-consuming database administration processes needed to scale out enterprise applications as businesses grow, or respond to changes.
MariaDB MaxScale helps scale database infrastructure without application-level code changes. MaxScale provides connection-based and statement-based load balancing for MariaDB Galera Cluster, MariaDB Master-Slave replication, and Oracle MySQL Server replication. MariaDB MaxScale also offers zero downtime during both planned and unplanned node outages. MaxScale immediately failover for MariaDB Galera Cluster nodes. When MaxScale reacts to a node failure in MariaDB Replication and MySQL Replication, applications need not re-establish the connection.
The concept of a data-centric proxy is not new, but MariaDB MaxScale is different because it leverages the deep server and parser knowledge of MariaDB to ensure that queries are processed in the exactly the same way inside MariaDB server, making it faster, more efficient and more transparent.
One unique aspect of MaxScale is that it has a modular approach allowing it to do much more than focusing only on load balancing, which many of the other proxies on the market do. MaxScale provides logging, filtering, monitoring mechanisms and allows for the implementation of transparent sharding outside the application itself.
When deploying MaxScale, user’s applications continue to work using the same connectors with no application re-building or code changes. MaxScale’s pluggable architecture allows for the creation of custom database services that do not require changes to applications. MariaDB MaxScale’s extensible architecture allows new plugins to be created by community members as well as MariaDB Enterprise users.
Built upon a lightweight, high-speed networking core designed to facilitate throughput. MariaDB MaxScale runs between the client application and the database cluster offering connection and statement-based load balancing. MariaDB MaxScale allows scaling of an organization's database infrastructure while addressing needs of DBAs, developers and data architects.
MariaDB team focused on the key pain points for application and database professionals and developed five types of plugins: protocols, monitoring, routing, authentication and logging.
Formerly known as SkySQL, MariaDB has over 2 million users globally with 500 customers in over 30 countries, including global brands such as HP, Craigslist, Deutsche Telekom, Virgin Mobile and Booking.com. Open source technology vendors such as Red Hat, SUSE, Rackspace and IBM have chosen MariaDB as their database of choice.
Services with the plugins included in MariaDB MaxScale 1.0 will transform queries to support legacy application, migrate applications and database asynchronously without service disruption, block queries conditionally based on user and query syntax, log and identify bottleneck queries, and offer query duplication to another database, storage engine or application. Send data to transactional storage engine suchs as InnoDB as well as to NoSQL database.
Services with possible new plugins include route to shards databases without application level knowledge of sharding schema, hardened active-active multi-master replication using uptimized routing to Galera multi-master nodes that avoids the deadlock situations possible with multi-master topologies,. It also supports geo-replication through multiple HA clusters with replication across geographically distributed data centers using MaxScale.
MaxScale also comes with the ability to change database protocols from MariaDB and MySQL as well as via JSON to Microsoft SQL Server, Hadoop, PostgreSQL and other database choices.