Azure: Future for Your Datacentre?
Oracle has announced the general availability of its managed MySQL Database Service, along with a feature that integrates online analytical processing (OLAP) into the platform.
The company claims its offering is faster and lower-cost than competing systems such as Amazon’s Redshift cloud data warehouse, Google Cloud SQL and Microsoft SQL Database.
It is based on the popular MySQL database software, which Oracle acquired with Sun Microsystems in 2010. Sun previously bought MySQL in 2008.
MySQL is widely used for online transaction processing (OLTP) applications, managing data from retail or financial transactions, for instance.
But organisations have often maintained a second database for data analysis or OLAP actions, such as finding customer trends based on the analysis of sales data.
Oracle’s system aims to remove this additional complexity, automatically populating the MySQL data into the in-memory analytics engine.
The analytical engine scales to thousands of cores and supports real-time analytics, Oracle said, claiming it is 2.7 times faster and one-third the cost of AWS Redshift.
The engine, available exclusively on Oracle Cloud Infrastructure (OCI), uses in-memory, hybrid columnar processing with massive inter- and intra-node parallelism optimised for Oracle’s cloud.
A query optimiser within the service has also been enhanced to support analytical queries as well as OLTP queries, Oracle said.
It said the service works with all MySQL-compatible tools and applications and automatically routes queries to the MySQL Analytics Engine, improving performance.
Any changes to the database are populated to the analytics engine in real time, simplifying application development and decreasing costs.
“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.
He said the new system offers developers and database administrators a “single, unified platform”.
US Congress passes bill to regulate stablecoins, in major win for crypto industry as it…
Discover Silicon UK's bold new redesign—enhancing tech journalism, user experience, and client campaigns with a…
Meta vows to spend hundreds of billions of dollars on AI infrastructure as it seeks…
US Defence Department hands contracts of up to $200m each to AI leaders as White…
OpenAI pushes back release of hotly anticipated open-source model indefinitely as it seeks to compete…
Driverless taxis could see $40bn in revenues a year in mainland China, boosted by cutting-edge…