searchdatamanagement.techtarget.com Open in urlscan Pro
2606:4700::6812:5c  Public Scan

URL: https://searchdatamanagement.techtarget.com/news/252476908/MariaDB-X4-brings-smart-transactions-to-open-source-database
Submission Tags: falconsandbox
Submission: On August 29 via api from US

Form analysis 1 forms found in the DOM

GET https://www.techtarget.com/search/query

<form action="https://www.techtarget.com/search/query" method="get" class="header-search">
  <label for="header-search-input" class="visuallyhidden">Search the TechTarget Network</label>
  <input class="header-search-input ui-autocomplete-input" id="header-search-input" autocomplete="off" type="text" name="q" placeholder="Search the TechTarget Network">
  <button aria-label="Search" class="header-search-submit"><i class="icon" data-icon="g"></i></button>
</form>

Text Content

SearchDataManagement
Search the TechTarget Network
Sign-up now. Start my free, unlimited access.
Login Register
 * Techtarget Network
 * News
 * Features
 * Tips
 * More Content
    * Answers
    * Buyer's Guides
    * Definitions
    * Essential Guides
    * Opinions
    * Photo Stories
    * Podcasts
    * Quizzes
    * Tutorials
    * Sponsored Communities

 * Multimedia

 * SearchDataManagement
 * Topic DBMS
    * Integration
    * Resources
    * Quality / governance
    * BI
    * ECM
    * Data warehouse
    * MDM
    * Verticals
    * All Topics

 * SubTopic All Subtopics
    * AWS data warehousing
    * DBMS strategy
    * DBMS software
    * IBM DB2
    * Microsoft SQL Server management
    * Oracle database management
    * All Subtopics

 * Follow:
 * 
 * 
 * 



Nmedia - Fotolia

Nmedia - Fotolia

News Stay informed about the latest enterprise technology news and product
updates.


MARIADB X4 BRINGS SMART TRANSACTIONS TO OPEN SOURCE DATABASE

 * 




OPEN SOURCE DATABASE VENDOR MARIADB UPDATES ITS FLAGSHIP PLATFORM WITH NEW
FEATURES TO ENABLE THE CONVERGENCE OF TRANSACTIONAL AND ANALYTICAL DATABASES.

Share this item with your network:

 * 
 * 
 * 


By
 * Sean Michael Kerner

Published: 16 Jan 2020

MariaDB has come a long way from its MySQL database roots. The open source
database vendor released its new MariaDB X4 platform, providing users with
"smart transactions" technology to enable both analytical and transactional
databases.



MariaDB, based in Redwood City, Calif., was founded in 2009 by the original
creator of MySQL, Monty Widenius, as a drop-in replacement for MySQL, after
Widenius grew disillusioned with the direction that Oracle was taking the open
source database.

Oracle acquired MySQL via its acquisition of Sun Microsystems in 2008. Now, in
2020, MariaDB still uses the core MySQL database protocol, but the MariaDB
database has diverged significantly in other ways that are manifest in the X4
platform update.

The MariaDB X4 release, unveiled Jan. 14, puts the technology squarely in the
cloud-native discussion, notably because MariaDB is allowing for specific
workloads to be paired with specific storage types at the cloud level, said
James Curtis, senior analyst of data, AI and analytics at 451 Research.

"There are a lot of changes that they implemented, including new and improved
storage engines, but the thing that stands out are the architectural adjustments
made that blend row and columnar storage at a much deeper level -- a change
likely to appeal to many customers," Curtis said.

MariaDB

MariaDB X4 database architecture



MARIADB X4 SMART TRANSACTIONS CONVERGES DATABASE FUNCTIONS

The divergence with MySQL has ramped up over the past three years, said Shane
Johnson, senior director of product marketing at MariaDB. In recent releases
MariaDB has added Oracle database compatibility, which MySQL does not include,
he noted.

In addition, MariaDB's flagship platform provides a database firewall and
dynamic data masking, both features designed to improve security and data
privacy. The biggest difference today, though, between MariaDB and MySQL is how
MariaDB supports pluggable storage engines, which gain new functionality in the
X4 update.

> The thing that stands out are the architectural adjustments made that blend
> row and columnar storage at a much deeper level -- a change likely to appeal
> to many customers. James CurtisSenior analyst of data, AI and analytics, 451
> Research

Previously when using the pluggable storage engine, users would deploy an
instance of MariaDB for transactional use cases with the InnoDB storage engine
and another instance with the ColumnStore columnar storage engine for analytics,
Johnson explained.

In earlier releases, a Change Data Capture process synchronized those two
databases. In the MariaDB X4 update, transactional and analytical features have
been converged in an approach that MariaDB calls smart transactions.

"So, when you install MariaDB, you get all the existing storage engines, as well
as ColumnStore, allowing you to mix and match to use row and columnar data to do
transactions and analytics, very simply, and very easily," Johnson said.


MARIADB X4 ALIGNS CLOUD STORAGE

Another new capability in MariaDB X4 is the ability to more efficiently use
cloud storage back ends.

"Each of the storage mediums is optimized for a different workload," Johnson
said.

For example, Johnson noted that Amazon Web Service's S3 is a good fit for
analytics, because of its high-availability and capacity. He added that for
transactional applications with row-based storage, Amazon Elastic Block Store
(EBS) is a better fit. The ability to mix and match both EBS and S3 in the
MariaDB X4 platform makes it easier for users to consolidate both analytics and
transactional workloads in the database.

"The update for X4 is not so much that you can run MariaDB in the cloud, because
you've always been able to do that, but rather that you can run it with smart
transactions and have it optimized for cloud storage services," Johnson said.


MARIADB DATABASE AS A SERVICE (DBAAS) IS COMING

MariaDB said it plans to expand its portfolio further this year.

The core MariaDB open source community project is currently at version 10.4,
with plans for version 10.5, which will include the smart transactions
capabilities, to debut sometime in the coming weeks, according to MariaDB.

The new smart transaction capabilities have already landed in the MariaDB
Enterprise 10.4 update. The MariaDB Enterprise Server has more configuration
settings and hardening for enterprise use cases.

The full MariaDB X4 platform goes a step further with the MariaDB MaxScale
database proxy, which provides automatic failover, transaction replay and a
database firewall, as well as utilities that developers need to build database
applications.

Johnson noted that traditionally new features tend to land in the community
version first, but as it happened, during this cycle MariaDB developers were
able to get the features into the enterprise release quicker.

MariaDB has plans to launch a new DBaaS product this year. Users can already
deploy MariaDB to a cloud of choice on their own. MariaDB also has a managed
service that provides full management for a MariaDB environment.

"With the managed service, we take care of everything for our customers, where
we deploy MariaDB on their cloud of choice and we will manage it, administer it,
operate and upgrade, it," Johnson said. "We will have our own database as a
service rolling out this year, which will provide an even better option."

NEXT STEPS

MariaDB expands SkySQL cloud database for high availability



DIG DEEPER ON DATABASE MANAGEMENT SYSTEMS (DBMS)

 * HOW DO YOU SOLVE A PROBLEM LIKE ‘BAD DATABASE DAYS’ MARIADB?
   
   
   By: Adrian Bridgwater

 * OPEN SOURCE DATABASE COMPARISON TO CHOOSE THE RIGHT TOOL
   
   
   By: Joseph Carew

 * DISTRIBUTED SQL DATABASE CAPABILITIES COME TO MARIADB X5
   
   
   By: Sean Kerner

 * WHY THE OPEN SOURCE DBAAS MARKET IS HOT
   
   
   By: Sean Kerner

Sponsored News
 * Modernize business-critical workloads with intelligence –Dell Technologies
 * 5 Advantages of Modernizing IT with Converged and Hyperconverged
   Infrastructure –Dell Technologies
 * 7 Ways for IT to Deliver Outstanding PC Experiences in a Remote Work World
   –Intel
 * See More

Related Content
 * MariaDB SkySQL enables cloud-native database as a ... – SearchDataManagement
 * MariaDB goes bigly on cloud-native smart apps – ComputerWeekly.com
 * MariaDB – SearchDataManagement



Latest TechTarget resources
 * Business Analytics
 * AWS
 * Content Management
 * Oracle
 * SAP
 * SQL Server

SearchBusinessAnalytics
 * How to develop a data literacy program in your organization
   
   This handbook examines the need for data literacy in organizations and offers
   advice on boosting the data literacy skills of ...

 * Alteryx platform update includes automated recommendations
   
   Automation is an ongoing focus for Alteryx. The vendor's latest update adds
   an automated recommendation feature that suggests ...

 * 14 most in-demand data science skills you need to succeed
   
   The demand for data scientists continues to grow, but the job requires a
   combination of technical and soft skills. Here are 14 ...

SearchAWS
 * In search of AWS Solutions Architect preparation?
   
   Think you're ready for the AWS Certified Solutions Architect certification
   exam? Test your knowledge with these 12 questions, and...

 * Experts raise privacy concerns over Amazon fleet surveillance
   
   Amazon said its van monitoring system is designed solely for driver safety.
   But many industry experts have concerns regarding the...

 * Here's why Amazon's global expansion won't come easy
   
   Amazon would like to strengthen its global footprint, but the e-commerce
   giant faces roadblocks and challenges today that did not...

SearchContentManagement
 * How to choose the right document management system
   
   With numerous options to choose from, picking the right document management
   system for your organization depends on a careful ...

 * Adobe buys Frame.io cloud video review platform for $1.275B
   
   Adobe plans to acquire Frame.io review and approval platform for $1.275
   billion to streamline digital collaboration among video ...

 * Follow 6 Power Apps best practices to build business apps
   
   While Power Apps is part of most Microsoft 365 subscriptions, some users may
   not know how to take advantage of it. Explore six ...

SearchOracle
 * Supreme Court sides with Google in Oracle API copyright suit
   
   The Supreme Court ruled 6-2 that Java APIs used in Android phones are not
   subject to American copyright law, ending a ...

 * Oracle Autonomous Database shifts IT focus to strategic planning
   
   This handbook looks at what Oracle Autonomous Database offers to Oracle users
   and issues that organizations should consider ...

 * Oracle Autonomous Database features free DBAs from routine tasks
   
   Oracle Autonomous Database can automate routine administrative and
   operational tasks for DBAs and improve productivity, but ...

SearchSAP
 * How does SAP intend to support a circular economy?
   
   SAP's circular economy efforts include its new software Responsible Design
   and Production. Learn how it can help producers take ...

 * IBM touts hybrid cloud for S/4HANA transformations
   
   IBM's hybrid cloud presents a strong alternative to the public cloud
   hyperscalers for S/4HANA deployments, but many don't see the...

 * Bold vision for SAP Business Network not yet a reality
   
   SAP is trying to create a 'network of networks' with its SAP Business
   Network, which it unveiled in June, but it still has to ...

SearchSQLServer
 * SQL Server database design best practices and tips for DBAs
   
   Good database design is a must to meet processing needs in SQL Server
   systems. In a webinar, consultant Koen Verbeeck offered ...

 * SQL Server in Azure database choices and what they offer users
   
   SQL Server databases can be moved to the Azure cloud in several different
   ways. Here's what you'll get from each of the options ...

 * Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL
   
   In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN
   techniques and find various examples for creating SQL ...

 * About Us
 * Editorial Ethics Policy
 * Meet The Editors
 * Contact Us
 * Advertisers
 * Business Partners
 * Media Kit
 * Corporate Site

 * Contributors
 * Reprints
 * Answers
 * Definitions
 * E-Products
 * Events
 * Features

 * Guides
 * Opinions
 * Photo Stories
 * Quizzes
 * Tips
 * Tutorials
 * Videos

All Rights Reserved, Copyright 2005 - 2021, TechTarget

Privacy Policy
Cookie Preferences
Do Not Sell My Personal Info


Close