MariaDB takes on Amazon RedShift analytics with ColumnStore
Admins can manage and deploy data analytics using ColumnStore


MariaDB hopes to go up against data analytics players like Teradata and Amazon's Redshift with its new open source columnar storage engine, MariaDB ColumnStore.
The platform enables customers to merge their transactional and analytical processing using one single interface, making it much easier to stay on top of data, without having to wander outside of the familiar MariaDB interface.
MariaDB claimed its product can significantly lower the cost of data warehousing compared to proprietary solutions such as Teradata and Vertica, because it doesn't need separate licensing and hardware agreements to use.
Additionally, MariaDB's ColumnStore takes advantage of flexible deployment options, giving customers the choice of using the cloud or on-premise hosting.
“Data warehouses are famously expensive and complex - requiring proprietary hardware which makes it nearly impossible to deploy on the cloud, or on commodity hardware. MariaDB ColumnStore makes data analytics more accessible, on premise, in the cloud or in a hybrid deployment,” said David Thompson, VP of engineering at MariaDB.
“Costing on average 90% less per TB per year than the leading data warehouses and offering a scalable solution for the cloud, MariaDB ColumnStore presents a new, open source model for big data analytics that is designed to meet today’s enterprise needs.”
ColumnStore also makes it simpler for administrators to manage and execute their data analysis, with the same security set-up as MariaDB Server, including encryption for data in motion, role-based access and auditability. Analysis can be triggered using existing queries without modification thanks to full ANSI SQL capabilities, not supported with Hadoop solutions.
Get the ITPro daily newsletter
Sign up today and you will receive a free copy of our Future Focus 2025 report - the leading guidance on AI, cybersecurity and other IT challenges as per 700+ senior executives
"The demand for robust analytics technologies has exploded as companies look to derive greater value from increasing data volume," said Jason Stamper, data platforms and analytics analyst at 451 Research.
"MariaDB's ColumnStore is a new option for high-performance analytics to big data, which aims to enable faster and more efficient queries while eliminating delays and reducing enterprise data warehousing expenses."
MariaDB ColumnStore was announced in April, with the beta released to testers in May.

Clare is the founder of Blue Cactus Digital, a digital marketing company that helps ethical and sustainability-focused businesses grow their customer base.
Prior to becoming a marketer, Clare was a journalist, working at a range of mobile device-focused outlets including Know Your Mobile before moving into freelance life.
As a freelance writer, she drew on her expertise in mobility to write features and guides for ITPro, as well as regularly writing news stories on a wide range of topics.
-
Should AI PCs be part of your next hardware refresh?
AI PCs are fast becoming a business staple and a surefire way to future-proof your business
By Bobby Hellard
-
Westcon-Comstor and Vectra AI launch brace of new channel initiatives
News Westcon-Comstor and Vectra AI have announced the launch of two new channel growth initiatives focused on the managed security service provider (MSSP) space and AWS Marketplace.
By Daniel Todd
-
Strengthening your data resilience strategy
webinar Safeguard your digital assets
By ITPro
-
Forrester: The Total Economic Impact™ Of IBM OpenPages
whitepaper Cost savings and business benefits enabled by IBM OpenPages
By ITPro
-
More than a number: Your risk score explained
Whitepaper Understanding risk score calculations
By ITPro
-
What is small data and why is it important?
In-depth Amid a deepening ocean of corporate information and business intelligence, it’s important to keep things manageable with small data
By Steve Cassidy
-
Google Ad Manager knocked offline for more than three hours
News The incident prevented publishers from automatically exchanging their ad inventories, potentially causing big losses for those affected
By Rory Bathgate
-
What is cloud analytics?
In-depth Cloud analytics offer businesses cost-effective ways to organise, analyse, and understand data for a variety of business use cases
By Christian Rigg
-
NetSuite launches SuitePeople tools for automating schedules and tracking attendance
News SuitePeople Workforce Management aims to give companies greater oversight and control of their workforces, as well as live metrics
By Rory Bathgate
-
Talking to a business should feel like messaging a friend
Whitepaper Managing customer conversations at scale with the WhatsApp Business Platform
By ITPro