MariaDB ColumnStore performance optimization exercise

We are dealing with both relational and NoSQL databases and we are often involved in advising our customers on choosing better product for their unique circumstances. One of our favorites, MariaDB ColumnStore has number of immediate advantages for utilization in BI systems:

For companies already using MySQL it may offer additional benefit of not leaving MySQL universe.

However, there are other good NoSQL vendors around and we are always on the lookout for better product or features. This time we noticed number of discussions and blogs that claimed MariaDB ColumnStore as having significant performance issues comparing to competition.

For example, here they compare the following vendors (and MariaDB ColumnStore appears the slowest):

Conclusion

We experimented using very simple optimization method and common hardware – and still results are pretty good. If we were using the same hardware as described in the original comparison or applied parameter optimization – we tend to believe our results would be even better.

We are glad to be able to confirm MariaDB ColumnStore capabilities and will continue recommending it to our customers.