MariaDB Blog

March 22, 2017

Go Big with Analytics at M|17

Analytics is at the heart of extracting value out of data. Adopting an effective analytics strategy can be a distinctive competitive advantage, particularly with the growth of big data and IoT in the enterprise.

Read More

March 14, 2017

ColumnStore: Storage Architecture Choices

Join MariaDB ColumnStore Use Cases Webinar on March 23, 2017 10 a.m. PT

MariaDB ColumnStore provides a complete solution for automated high availability of a cluster. On the data processing side:

  • Multiple front-end or User Module (UM) servers can be deployed to provide failover on SQL processing.

  • Multiple back-end or Performance Module (PM) servers can be deployed to provide failover on distributed data processing.

Due to the shared-nothing data processing architecture, ColumnStore requires the storage tier to deliver high availability for a complete solution. In this blog, I intend to provide some clarity and direction on the architecture and choices available.

Read More

March 08, 2017

Webyog – M|17 Sponsor

By Guest

Authored by Shree Nair, Product Manager, Webyog

We are very excited to sponsor MariaDB’s inaugural user conference, M|17! It’s a great opportunity to introduce Webyog to the MariaDB community, and demonstrate the close collaboration between Webyog and MariaDB – we work together to provide powerful administrative tools for the fastest growing open source database.

Read More

March 07, 2017

Replication Manager, Flashback and Much More!

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.

MariaDB 10.2.4 has fantastic new features that perfectly match Replication Manager's ultimate goals: transparent automated failover on MariaDB master slave architecture (with as little as possible lost in transaction:)).  We are going to explore those new features and how Replication Manager uses them for your benefit!  

Read More

February 28, 2017

JSON with MariaDB 10.2

MariaDB 10.2 includes a number of JSON functions, but why would you use JSON as aren't JSON and SQL data contradictory? This blog shows you why this isn't so and how these JSON functions can be a very useful addition to MariaDB and how MariaDB 10.2 has some other tricks that make JSON with MariaDB even more useful.

Read More

February 16, 2017

Improving the Performance of MariaDB MaxScale

Performance has been a central goal of MariaDB MaxScale’s architecture from the start. Core elements in the drive for performance is the use of asynchronous I/O and Linux’ epoll. With a fixed set of worker threads, whose amount is selected to correspond to the number of available cores, each thread should either be working or be idle, but never be waiting for I/O. This should provide good performance that scales well with the number of available CPUs. However, benchmarking revealed that was not entirely the case. The performance of MaxScale did not continuously increase as more worker threads were added, but after a certain point the performance would actually start to decrease.

When we started working on MariaDB MaxScale 2.1 we decided to investigate what the actual cause for that behaviour was and to make modifications in order to improve the situation.

Read More