- Oracle MySQL Database Service with the MySQL Analytics Engine provides a fully managed scale-out service for analytics and OLTP
- MySQL service that provides customers with a single, unified platform for Online Transaction Processing (OLTP) and Online Analytics Processing (OLAP) workloads
Oracle has announced the availability of the Oracle MySQL Database Service with integrated MySQL Analytics Engine, optimized for and exclusively available in Oracle Cloud Infrastructure (OCI). It said that MySQL service that provides customers with a single, unified platform for Online Transaction Processing (OLTP) and Online Analytics Processing (OLAP) workloads to build and run modern applications faster and more securely.
The company said that the MySQL Analytics Engine, developed for the MySQL Database Service by Oracle’s MySQL engineering team in collaboration with Oracle Labs, is a new, in-memory analytic accelerator that scales to thousands of cores, supports real-time analytics, and is at least two times faster and up to 66 percent less expensive than Amazon Redshift.
Single, unified platform
While MySQL databases are commonly used for OLTP, most enterprises that run MySQL databases also need to run analytics on data stored in MySQL databases. Until today, organisations had to extract, transform, and load (ETL) their data into a separate analytics database. It is a costly and complex process that reduces performance, security, and data quality, delaying the deployment of new applications.
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.”
Any MySQL-compatible tools and applications
It added that 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. When users spin up the service, data from the MySQL database is populated in the memory of the analytics engine, eliminating the need to ETL data to specialised databases.
It further states, “The service works seamlessly with any MySQL-compatible tools and applications and will automatically route queries to the MySQL Analytics Engine, dramatically improving performance. Any changes to the MySQL database are automatically populated into the analytics engine in real-time. This simplifies application development, saves time, enables real-time queries, decreases costs, and improves security. The new service is available across all Oracle Cloud commercial regions and will be available in Oracle Dedicated Region Cloud@Customer.”
On-premises MySQL. developers
The MySQL Database Service is a fully managed database cloud service that enables customers to provision MySQL databases in minutes and focus on development, without having to worry about time-consuming database administration tasks such as scaling, backup, OS patching, and server maintenance. The MySQL Database Service is the only public cloud service built on MySQL Enterprise Edition to help ensure the highest reliability and security as claimed by the company. The new service is completely compatible with on-premises MySQL. developers always have access to the latest MySQL features, and can leverage native services in OCI using technologies such as Kubernetes and Docker.
The company adds, “The MySQL Analytics Engine is architected for massive scale and performance, accelerating MySQL performance by 400 times for analytic queries. The analytics engine offers in-memory hybrid columnar processing, massive inter- and intra-node parallelism optimized for Oracle Cloud Infrastructure, and distributed query processing algorithms while relieving DBAs of time-consuming ETL tasks.”