In this second installment of schema sharing with MariaDB MaxScale to combine SchemaRouter and ReadWriteSplit MaxScale routers, we'll go through the details of implementing it in order to shard databases among many pairs of master/slave servers.
Most of the time when you start a database design you don’t imagine how your applications need to scale. Sometimes, you need to shard your databases among some different hosts and then, on each shard you want to split reads and writes between master and slaves.
The 2.1.3 GA release of MariaDB MaxScale, introduces the following key features for the secure setup of MariaDB MaxScale Binlog Server:
The binlog cache files in the MaxScale host can now be encrypted.
MaxScale binlog server also uses SSL in communication with the master and the slave servers.
This blog covers how the binary log encryption works in MariaDB Server and in MariaDB MaxScale.
Performance is important and perhaps doubly so for a database proxy such as MariaDB MaxScale. When we started working with MariaDB MaxScale 2.1 we decided to make some significant changes to the internal architecture, with the aim of improving the overall performance. In this blog post, I will describe what we have done and show how the performance has improved.
MariaDB MaxScale includes multiple filters, and one of the most useful, flexible and easiest to use is the regex filter and in this blog we will look at how this can be used to transform SQL statements that aren't 100% compatible with MariaDB.
We are happy to announce the 2.1 GA release of MariaDB MaxScale, the next-generation database proxy for MariaDB.
We believe an enterprise database solution requires technology, tools and services, and that it should be easy to buy, easy to deploy and easy to manage – providing a great customer and user experience from beginning to end. That's why we're introducing MariaDB TX.
Thank you to everyone who joined us at our first-ever MariaDB user conference in New York City on April 11-12. Thank you also to our sponsors for their generous support: Amazon Web Services, Galera Cluster, Qualcomm Datacenter Technologies, Monyog, Intel, Alibaba Cloud, eperi, Navicat, MariaDB Foundation, diginomica, insideBIGDATA and ODBMS.org.
Couldn’t make the event or want to relive your favorite session? Access all the M|17 video recordings.
Note: Replication Manager is developed and maintained by community members. It can be used with MariaDB Server, but it is not supported with an enterprise subscription.
The beta version of the upcoming MaxScale 2.1 has been released. This new release takes MaxScale to the next level by introducing functionality that makes it possible to configure parts of MaxScale’s configuration at runtime.