MariaDB Blog

June 23, 2017

Schema Sharding with MariaDB MaxScale 2.1 - Part 1

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. This blog is about MariaDB MaxScale being able to handle different databases across shards, and splitting up reads and writes into each of the shards to achieve the maximum level of horizontal scalability with MariaDB Server.

After reading this blog you will be able to:

  • Know how MariaDB MaxScale handles shards with SchemaRouter router;

  • Know how MariaDB MaxScale handles the split of reads and writes with ReadWriteSplit router;

  • Know how we can combine both mentioned router in order to have an scalable environment.

Read More

June 21, 2017

Secure Binlog Server: Encrypted binary Logs and SSL Communication

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.

Read More