To properly prevent some columns from being accessed, the masking filter that was introduced in MariaDB MaxScale 2.1 must be used together with the database firewall filter. In version 2.1, it was somewhat cumbersome to setup the database firewall filter for use together with the masking filter. With the recently released MariaDB MaxScale 2.2 (GA), we have introduced new features that makes the combined use of the masking filter and the database firewall filter much easier.
In this blog, we configure a simple HA setup of two MariaDB MaxScales using Keepalived and MaxCtrl.
MariaDB MaxScale 2.2 introduces failover, switchover and automatic rejoin for MariaDB Master/Slave replication clusters.
One of the new things in MariaDB MaxScale 2.2 is the addition of a fully integrated administrative interface implemented as a JSON-API conforming REST API. The MariaDB MaxScale REST API is a great way to monitor and interact with MariaDB MaxScale from a wide variety of programming languages but it is not the most convenient thing for command line use.
We are excited to announce MariaDB MaxScale 2.2.2 GA with built in failover management.
We are happy to announce that 2.2.1 beta of MariaDB MaxScale, the next generation database proxy for MariaDB is now available. Beta is an important time in our release and we encourage you to download this release today!
This blog post will explore the setup of an environment using self-signed OpenSSL certificates to make it safe enough to replicate data between the multiple backend database servers and also, we’ll show you how to setup the communication between MariaDB MaxScale and the backend.
With MariaDB MaxScale 2.2 (currently in beta) the monitor for MariaDB instances can detect a Binlog server setup and SQL statements can be properly routed among Master and Slave servers.
The “identity” of the binlog server layer from the slave server’s point of view is something that could be modified in order to provide all slaves such common parameters for all MariaDB MaxScale server they could replicate from.
With all the excitement leading up to the holidays, it's easy to overlook how to prep your database environment for the biggest online shopping days of the year! Each year, more and more shoppers opt for online holiday deals instead of the more traditional mall experience, which means that retailers must prepare for multiple days of high online traffic to their e-commerce sites. This year you’ll be prepared, as I’m passing along 20 tips to tune your database environment for some of the biggest online holiday shopping days – Black Friday and Cyber Monday!