Oracle announced integrated Analytics Engine for MySQL Database Service, optimized for and exclusively available in Oracle Cloud Infrastructure. It is also the only MySQL service that can provide customers with a single, unified platform for Online Transaction Processing and Online Analytics Processing workloads to build and run modern applications faster and more securely. MySQL Analytics Engine is developed by Oracle’s MySQL engineering team in collaboration with Oracle Labs.
2 times faster and up to 66% less expensive than Amazon Redshift
MySQL Analytics Engine is a new in-memory analytic accelerator that scales to thousands of cores, supports real-time analytics, and is faster and more affordable than Amazon Redshift. The new solution provides a fully managed scale-out service for analytics and OLTP and is the only service that enables customers to run OLTP and OLAP workloads directly from their MySQL database.
It eliminates the need to ETL data to specialized databases by populating the MySQL data from the MySQL database in the memory of the analytics engine. According to the announcement, any changes to the MySQL database are also automatically populated into the analytics engine in real-time. Edward Screven, Chief Corporate Architect, Oracle, said,
“MySQL is the most popular database among developers and is widely used by companies across industries. But, until today, MySQL users have been forced to move their data into separate incompatible data warehouses for analytics leading to higher costs and delayed answers. With the MySQL engineering team’s latest innovations, Oracle is the only provider that offers developers and database administrators a single, unified platform that can easily run high-performance real-time analytics against their MySQL database without requiring any change to their MySQL applications, making Oracle Cloud Infrastructure the best place to run MySQL applications.”