DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Refcards Trend Reports Events Over 2 million developers have joined DZone. Join Today! Thanks for visiting DZone today,
Edit Profile Manage Email Subscriptions Moderation Admin Console How to Post to DZone Article Submission Guidelines
View Profile
Sign Out
Refcards
Trend Reports
Events
Zones
Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Partner Zones AWS Cloud
by AWS Developer Relations
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Partner Zones
AWS Cloud
by AWS Developer Relations
  1. DZone
  2. Data Engineering
  3. Databases
  4. What's New in MariaDB MaxScale 2.1
Content provided by MariaDB logo

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.

Dipti Joshi user avatar by
Dipti Joshi
·
May. 30, 17 · News
Like (2)
Save
Tweet
Share
2.25K Views

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:

  • Release notes
  • List of bugs fixed
  • Binaries
  • MaxScale 2.1.3 documentation in our Knowledge Base
  • Source code in GitHub tagged with maxscale-2.1.3

Comments

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends: