MySQL is widely used for transaction processing databases, but it has usually been necessary to extract data into a separate database for analytics work.
"The Oracle MySQL Database Service with the MySQL Analytics Engine 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," said Oracle officials.
The service automatically populates the memory of the analytics engine with data from the MySQL database, and works with MySQL-compatible tools and applications.
Queries are automatically routed to the MySQL Analytics Engine, simplifying application development, saving time, and enabling real-time queries, as well as decreasing costs and improving security.
"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," said Oracle chief corporate architect Edward Screven.
"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."
According to Oracle, the service is at least twice as fast as Amazon Redshift and up to 66% less expensive. As Oracle chairman and CTO Larry Ellison is fond of saying, "you have to be willing to pay less".
"At Siemens Healthineers we use several MySQL databases. During our tests of the new MySQL Database Service Analytics Engine we discovered astonishing performance improvements, reducing query times from hours to literally seconds in cases of non-index based queries," said Siemens Healthineers senior key expert Jens Uecker.
"This enables us to expand service to new levels and opens the door to many more analytics-based capabilities, all while maintaining a single, seamless database platform."
MySQL Database for Analytics costs $0.5500248 per node per hour. The service is available in all Oracle Cloud commercial regions and will be available in Oracle Dedicated Region Cloud@Customer.