This blog is about setting up Data Streaming from MariaDB TX to MariaDB AX. We will be using Virtual Box CentOS images.
Perhaps the most user-visible InnoDB changes in the MariaDB Server 10.3.7 GA release are Instant ADD COLUMN for InnoDB tables, the new parameter alter_algorithm and the clauses
ALGORITHM=NOCOPY that can protect the database from executing costly
ALTER TABLE operations taking hours.
In this blog post, we look at how to configure Change Data Capture from the MariaDB Server to
MariaDB ColumnStore via MariaDB MaxScale. Our goal in this blog post is to have our analytical
ColumnStore instance reflect the changes that happen on our operational MariaDB Server.
By introducing SQL functions for JSON, developers can now use a single database for both structured and semi-structured data – and administrators don’t have to worry about losing transactions, data integrity and reliability. It’s the best of both worlds!
In this blog post, we show how to connect Tableau to MariaDB TX or MariaDB AX and how to create advanced visualizations in Tableau using data in MariaDB.
Learn how Billy Mobile deployed MariaDB ColumnStore for fast, interactive analysis of big data that easily integrates with Tableau for data visualization.
There are many great unique features of MariaDB ColumnStore, one of which is the speed in which you can get data from CSV files into MariaDB ColumnStore using the tool ‘cpimport’. But what if your data is in another format? Or you wish to stream data into MariaDB ColumnStore from another application? This is where MariaDB ColumnStore’s new write API comes into play.
Today, the market wants an enterprise open source data warehouse for modern analytical workloads. We call it MariaDB AX. It’s for everything from traditional business intelligence/reporting and data mining to modern analytics, including decision support systems and recommendation engines. Learn what it takes to be an enterprise open solution for modern analytics and data warehousing.
In order to have faster time to insight and time to action it’s critical that:
Organizations make data available for analysis as soon as it arrives, and;
Applications stream data from data sources to analytics platform seamlessly.
The new MariaDB AX includes MariaDB ColumnStore Data Adapters, enables easy integration with data from various sources such as web/mobile services, IoT, sensors, social networks, device logs and machine learning model output.