I wanted to do some tests with MariaDB MaxScale and realized that the two existing routers (beyond the binlog router that is, which is a bit special) didn't do what I wanted them to do. What I was looking for was a simple round-robin feature and neither the readconnroute nor readwritesplit could be configured to do this. They are just too smart for my simple experiment.
The new CDC protocol modules in MaxScale 2.0.0 can be used to convert binlog events into easy to stream data. These streams can be guided to other systems for further processing and in-depth analysis. In this article, we set up a simple Kafka broker on CentOS 7 and publish changes in the database as JSON to it with the help of the new CDC protocol in MaxScale.
MariaDB MaxScale 2.0 can be configured for MariaDB 10 Binlog to AVRO conversion and the converted files can be requested with the new CDC protocol. This post will cover details of how to use the CDC protocol to request streaming data from MariaDB MaxScale.
If you are like me (let's for everyones sake hope you are not, though), you like to do things the hard way, in particular when it comes to testing things. For example, when installing things on your Linux box, just to try them out, you might not want to do a yum install, an rpm -ivh or an apt-get to have some files spread all over your system. Instead you want to tar xvf some tarball and possibly, if you are in a good mood or you want to be nice so you get some gifts for the holidays or maybe because it is just that day, you unpack that tarball in /usr/local instead of in /home/bofh/junk.
MariaDB MaxScale 2.0 for data streaming requires configuring the MariaDB Master to send binary log events to MariaDB MaxScale, and configuring MariaDB MaxScale to receive and convert binary logs. This blog is a step by step guide to successfully receive binary log events from a Master database and convert them to AVRO records.
MariaDB MaxScale team has designed a modular solution to stream binlog events coming from the Master database to the data lake via messaging systems such as Kafka’s distributed broker. The binlog events for inserts, updates and deletes are converted in AVRO or JSON format before it’s forwarded to the data lake. Kafka is used as a data ingestion pipeline for distributed data process environment.
Magicbricks migrated from a proprietary database to MariaDB (version 10.1.x) to support its growing online traffic.
Enterprise users who have a large number of MariaDB servers often want to centralize their MariaDB user account administration -- especially for the user accounts of the database administration team. This can simplify some database administration tasks, since users do not have to be manually created on every server.
Developing on your Mac? Get the latest stable MariaDB version set up on OS X easily with Homebrew. See this step by step guide on installing MariaDB 10.1.16.
I am happy to see MariaDB Corporation announcing a major new version of MariaDB MaxScale. MaxScale 2.0 Beta is now available here.