Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

What's New in MariaDB MaxScale 2.1

DZone's Guide to

What's New in MariaDB MaxScale 2.1

Here are the new capability of the new 2.1 GA release of MariaDB MaxScale, the next-generation database proxy for MariaDB.

· Database Zone
Free Resource

Download the Guide to Open Source Database Selection: MySQL vs. MariaDB and see how the side-by-side comparison of must-have features will ease the journey. Brought to you in partnership with MariaDB.

We are happy to announce the 2.1 GA release of MariaDB MaxScale, the next-generation database proxy for MariaDB.

MariaDB MaxScale 2.1 introduces the following key new capabilities.

Dynamic Configuration

  • Server, monitor, and listeners: MaxScale 2.1 supports dynamic configuration of servers, monitors, and listeners, which can be added, modified or removed during runtime. A set of new commands were added to maxadmin.
  • Database firewall filter: Rules can now be modified during runtime using the new module commands introduced in this release.
  • Persistent configuration changes: The runtime configuration changes are immediately applied to the running MaxScale as well as persisted using the new hierarchical configuration architecture.

Security

  • Selective data masking: Meet your HIPAA and PCI compliance needs by obfuscating sensitive data using the new masking filter.
  • Result set limiting: Prevent access to large sets of data with a single query by using maxrows filter — securing your database servers against malicious or accidental DoS attack.
  • Secured single sign-on: MariaDB MaxScale now supports LDAP/GSSAPI authentication support.
  • Prepared statement filtering by database firewall: The database firewall filter now applies the filtering rules to prepared statements as well.
  • Function filtering by database firewall: Now the database firewall filter adds a rule to whitelist or blacklist a query based on presence of a function.
  • Secure binlog server: The binlog cache files on MaxScale can now be encrypted. MaxScale binlog server also uses SSL in communication with master and slave.

Query Performance

  • Query cache filter: MariaDB MaxScale 2.1 now allows caching of query results in MaxScale for a configurable timeout. If a query is in cache, MaxScale will return results from cache before going to server to fetch query results. Our internal testing has shown 2.8x performance improvement from 2.0 to 2.1.3 using cache filter.
  • Streaming insert plugin: A new plugin in MariaDB MaxScale 2.1 converts all INSERT statements done inside an explicit transaction into LOAD DATA LOCAL INFILE.

Scalability

  • Aurora Cluster support: MariaDB MaxScale can now be used as a proxy for Amazon Aurora Cluster. The newly added monitor detects read replicas and write node in Aurora Cluster and supports launchable scripts on monitored events like other monitors.
  • Multi-master for MySQL monitor: Now MariaDB MaxScale can detect complex multi-master replication topologies for MariaDB and MySQL environment.
  • Failover mode for MySQL monitor: For a two-node master-slave cluster, MariaDB MaxScale now allows the slave to act as a master in case the original master fails.
  • Read-write splitting with master pinning: MariaDB MaxScale 2.1 introduces a new “Consistent Critical Read Filter.” This filter detects a statement that would modify the database and route all subsequent statements to the master server where data is guaranteed to be in an up-to-date state.

Thanks to community members and especially OutboundEngine who beta tested MariaDB MaxScale 2.1.0 to MariaDB MaxScale 2.1.2 in order for us to reach GA with MariaDB MaxScale 2.1.3.

Links:

Interested in reducing database costs by moving from Oracle Enterprise to open source subscription?  Read the total cost of ownership (TCO) analysis. Brought to you in partnership with MariaDB.

Topics:
mariadb ,maxscale ,queries ,database

Published at DZone with permission of Dipti Joshi, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

THE DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

X

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}