Oracle is releasing an prolonged model of its open-source MySQL service that can embody data warehousing performance. The replace ought to imply that customers of cloud computing database options now not want to depend on a separate data analytics database in the event that they want a data warehouse.
From as we speak, Oracle is making its MySQL Database Service with built-in MySQL Analytics Engine out there, delivering a unified platform for each on-line transaction processing and on-line analytics processing workloads.
The new analytics engine will go head to head with Amazon Redshift, promising to be no less than twice as quick and 66% cheaper than Amazon’s service.
A brand new database service
Although MySQL stays probably the most standard database options on the planet, it has largely been restricted to transaction processing because it lacks among the performance required for analytics.
As a end result, many customers of MySQL databases had to run a separate analytics database, extracting, reworking, and loading their data as a part of a expensive and time-consuming course of.
The new replace signifies that the Oracle MySQL Database Service is the one answer that permits clients to run each transaction and analytics workloads immediately from their MySQL database. It not solely signifies that extra companies might contemplate MySQL for his or her data warehousing wants, they might additionally see Oracle as a viable MySQL service supplier.
“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,” mentioned Edward Screven, chief company architect at Oracle.
“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.”