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
Submission Tags: falconsandbox
Submission: On August 29 via api from US
Form analysis
1 forms found in the DOMGET 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