Tag: MariaDB

Posted on

MariaDB launches Oracle compatible enterprise open source database

MariaDB TX 3.0 introduces built-in, system-versioned tables, enabling developers to easily build temporal features into applications. This eliminates the need to manually create columns, tables and triggers in order to maintain row history, freeing DBAs to simply create new tables with system versioning or alter existing tables to add it, streamlining the process significantly. Developers can query a table with standard SQL to see what data looked like at a previous point in time, such as looking at a customer’s profile history to see how preferences have changed over time.

— MariaDB launches Oracle compatible enterprise open source database :: betanews https://betanews.com/2018/05/24/mariadb-enterprise-open-source-database/

Posted on

MariaDB ColumnStore Adds Simultaneous Analytics, Transactional Processing – The New Stack


InnoDB or the other default MySQL storage engine MyISAM provide reasonable performance on analytical query workloads up to 100,000 rows or tables under a million rows. Performance is harder to tune and maintain beyond that, Thompson wrote in a blog post.
ColumnStore is suitable for reporting or analysis on much larger data sets. Mobile applications of customer Pinger, for example, process millions of text messages and phone calls with ColumnStore, in addition to more than 1.5 billion rows of logs per day.

Source: MariaDB ColumnStore Adds Simultaneous Analytics, Transactional Processing – The New Stack

Looks interesting. We’ve had performance issues with our large db tables for years that we’ve managed to work around, but it’s likely time to take a look at a redesign around a newer technology.