MariaDB Blog

July 20, 2017

Do you need five 9s?

When it comes to database high availability, how many 9s do you really need? Finding the right mix of reliability and infrastructure complexity is vital to make the best use of your resources. In this blog, we will take a high-level look at three common approaches, spanning from 99.9% to 99.999% uptime.

Read More

July 13, 2017

Analysis of Financial Time Series Data Using MariaDB ColumnStore

MariaDB ColumnStore is a GPLv2 open source columnar database built on MariaDB Server. It is a fork and evolution of the former InfiniDB. It can be deployed in the cloud (optimized for Amazon Web Services) or on a local cluster of Linux servers using either local or networked storage. In this blog post, I will show some examples of analysis of financial time series data using MariaDB ColumnStore.

 

Read More

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