
Oracle has announced the general availability of a cloud-based MySQL database service with a new analytics engine that can perform transaction processing and business analysis tasks within the same database system.
The software giant is pitching the fully managed MySQL Database Service as a high-performance, lower-cost alternative to competing systems such as the AWS RDS database and Redshift cloud data warehouse, Google Cloud SQL and Microsoft Azure SQL Database
“Partners have been asking Oracle to expand their portfolio of database services. And that’s what Oracle is doing with MySQL Database Service,” said Edwin DeSouza, vice president of product marketing for MySQL at Oracle, in an interview with CRN.
[Related: 10 Big Data Management And Business Analytics Tools You Need To Know About]
Oracle acquired the open-source MySQL database as part of its acquisition of Sun Microsystems in 2010. Sun previously acquired MySQL in 2008.
The MySQL database is widely used for online transaction processing (OLTP) applications, managing data generated by retail, financial and other operational applications that underpin many business processes. But the database, historically, has not been particularly strong in data analysis or online analytical processing (OLAP) capabilities.
That means businesses and organizations often utilize another database separate from the OLTP system when they run analytical applications – such as analyzing sales data to identify customer trends. That leads to increased system complexity, more data movement and transformation, and higher costs.
“MySQL users have had to use another database for OLAP,” DeSouza said. That “adds friction” to database operations, he said, and requires data extract, transform and load (ETL) technology and processes. “Data is not real time, decision making is not real time,” he added.
Wednesday Oracle announced the general availability of the Oracle MySQL Database Service with the MySQL Analytics Engine, a MySQL offering that provides database administrators and application developers with a unified platform for both OLTP and OLAP workloads.
The new MySQL service, which has been in beta test for about a year, is optimized for – and available only through – the Oracle Cloud Infrastructure (OCI), Oracle’s Infrastructure-as-a-Service cloud platform, said Nipun Agarwal, vice president of research and advanced development – the Oracle organization that developed the new capabilities within the MySQL Database Service and the analytics engine.
The MySQL Analytics Engine is an in-memory analytics accelerator that allows users to run sophisticated analytical queries directly against their operational MySQL databases. When customers start up the MySQL service, data from the MySQL database is populated into the analytics engine memory. That, according to Oracle, eliminates the need for complex and expensive data integration and ETL.
“It is significantly faster, significantly cheaper. There is no [more] need to have two different databases, no ETL. All existing tools and applications for MySQL work as-is,” Agarwal said.
The analytical engine scales to thousands of cores and supports real-time analytics, according to Oracle, and the company says the technology performs 2.7 times faster than AWS Redshift at one-third the cost. The engine uses in-memory, hybrid columnar processing with massive inter- and intra-node parallelism optimized for the Oracle Cloud Infrastructure, and uses distributed algorithms also optimized for OCI.
In addition to the new engine, the query optimizer within the MySQL Database Service has been enhanced to support analytical queries as well as OLTP queries.
Oracle MySQL, including the new cloud database service and analytics engine, is competing in a crowded market. A number of vendors, including cloud platform vendors AWS, Google and Microsoft Azure, offer their own MySQL database services.
Other potential competitors include mainstream databases like Oracle’s own flagship relational database and Microsoft SQL Server. The MariaDB database and its recently launched SkySQL managed cloud database service, built by some of MySQL’s original developers, is a competitive threat. And there’s a new generation of database systems such as Splice Machine and MemSQL that support transaction processing and data analytics in one system.
Oracle has hundreds of resellers and systems integrator partners that work with the Oracle Database. But DeSouza said partners – and many cloud customers who come to Oracle through partners – have been asking for a MySQL cloud service.
And while some might see MySQL and the new cloud service as a competing alternative to Oracle’s cash cow database, DeSouza said Oracle understands that it needs to provide partners and customers with a database product at “the price points of open source.”
“Oracle is being very aggressive,” DeSouza said.
related stories
Video
trending stories
sponsored resources

OutSystems
Modern Application Development 360

Symantec
Symantec Business Security Learning Center

HP Amplify™ - A Simplified Global Program for the Customer-Driven Digital Age
HP Inc.

Dell Technologies
Dell Technologies Cloud Learning Center

NPD
Industry Trends 360

EPOS
EPOS

Smart 3rd Party
3rd Party Maintenance 360

Products of the Year Showcase

Cysurance
Cyber Insurance 360

Dell Technologies
Dell Technologies Storage Learning Center

BlackBerry
BlackBerry Learning Center

Spectrum Partner Program
Spectrum Partner Program

ADT
Network Security 360

Dell Technologies
Dell Technologies Server Learning Center

WatchGuard
WatchGuard

APC by Schneider Electric
IoT Platforms 360

Tenable
Cyber Risk 360

Dell Technologies
Dell Technologies Hybrid Cloud Learning Center

StorageCraft
Disaster Recovery Learning Center

Comcast
Comcast Business Learning Center

Vertiv
Edge Computing 360

Sophos
Sophos Cybersecurity Learning Center

Wasabi
Wasabi

Webroot
Webroot Learning Center
