MySQL Database Service Analytics Engine and Oracle Cloud Infrastructure: Run applications and analytics with better performance, scale, and efficiency

December 2, 2020 | 6 minute read
Leo Leung
Vice President, Product Marketing, OCI
Text Size 100%:

MySQL is still the most popular open source and developer database on the planet according to DB Engines and Stack Overflow. It’s rated 4.5 out of five stars by thousands of engineers and users on g2, TrustRadius, and Gartner. It’s used by the world’s largest social networks, ecommerce companies, and banks, as well as the most innovative manufacturers and high-tech companies.

Why? It’s easy to deploy and learn. It’s fast, reliable, and proven. It handles many types of use cases from large websites like Zillow, to hundreds of game backends at SQUARE ENIX, to hundreds of microservices applications at Square. It works well with a huge ecosystem, including Java, Python, Node.js, .NET, Linux, Windows, Apache Tomcat, Kubernetes, and so on.

We’ve worked hard to build a MySQL cloud service worthy of the name. Today, we’re excited to announce an exclusive capability on Oracle Cloud Infrastructure (OCI): now you can run both online transaction processing (OLTP) and online analytics processing (OLAP) workloads in the MySQL Database Service. Before we discuss this powerful new capability, let’s recap our overall MySQL managed service.

In April, we introduced the MySQL Database Service on Oracle Cloud Infrastructure. Our goal was to build a cloud service that gives you the latest MySQL features that you want, without any of the overhead of infrastructure management. With that in mind, our service eliminates the need to own and maintain data center space or buy and maintain servers and storage. It includes automated provisioning, configuration, scaling, patching, upgrading, and backup. It automatically runs the latest version of MySQL (8.0.22) with the latest improvements and bug fixes.

Compare with on-premises, and the difference is stark.

A chart comparing MySQL on-premises with MySQL Database Service.

In September and October, we expanded availability to a total of eight cloud regions globally including the U.S., Brazil, Canada, Germany, the U.K., Tokyo, and India. In November, we added support for our OCI E3 compute shapes, scaling up to 64 OCPUs and 1 TB of RAM per virtual machine (VM). For a typical MySQL application needing 100 cores and 1 TB of storage, Oracle Cloud is one-third the price of a similar configuration of AWS RDS in the United States. And because Oracle charges the same prices around the world, the price advantage is even greater outside of the U.S.

A bar graph comparing the annual cost for a 100-CPU 1-TB storage configuration.

MySQL Database Service: Standard E3 AMD 16GB per core, all regions have the same price
Amazon RDS: Intel R5 16GB per core, AWS US East
Azure: Memory Optimized Intel 20GB per core, MS Azure US-East
Google: High Memory N1 Standard Intel 13GB per Core, GCP Northern Virginia
Configuration: 100 OCPUs, 1-TB storage

All this provides you with a compelling choice for your transactional applications. But, there’s more.

Enter the MySQL Database Service Analytics Engine

As datasets within MySQL applications have grown, we saw a new and unique opportunity. Data has gravity, and each time you have to move data to a different database costs time and network bandwidth, and often requires a different skill set to manage that separate data management stack. We built a new engine to eliminate the need to extract, transform, and load from MySQL.

Taking advantage of Oracle’s powerful cloud infrastructure, the new MySQL Analytics Engine processes data in-memory and is optimized for OCI’s memory, CPU, and network architecture. The result? In TPC-H derived queries, analytics are 400 times faster than conventional MySQL and at least 2 times faster than even AWS Redshift, a service that’s focused on analytic workloads.

A bar graph comparing the speed of MySQL with MySQL Analytics Engine.

*Benchmark queries are derived from the TPC-H benchmark, but results are not comparable to published TPC-H benchmark results since they do not comply with the TPC-H specification

Using the new analytics capabilities is simple. Existing applications don’t require changes. You simply add an analytics cluster to your existing cloud MySQL environment, load your tables, and then query the analytics cluster through your MySQL instance. Further data propagation is automatic and in real time. You can query data within seconds of loading. MySQL Analytics Engine has built-in resilience and automatically reforms the analytics cluster and reloads tables if failure occurs. You can even use the MySQL Database Service to run analytics against on-premises MySQL!

One of 58 Oracle Cloud Infrastructure services

As you consider the MySQL Database Service for your transactional and analytic applications, know that it’s a native part of an ever-growing ecosystem of 58 Oracle Cloud services, third parties, and open source. OCI is noted for its outstanding price-performance. Compute and Kubernetes-managed containers cost 50% less than AWS, storage is up to 98% less, and outbound bandwidth is 80% less. OCI doesn’t charge for bandwidth across availability domains, only charges for log storage, and includes multiple advanced security services including automatic threat monitoring and remediation at no cost.

So, you can migrate and run existing MySQL-based applications, modernize them, or build new applications much more economically. You can run VM-based and container-based applications or pure functions. You can incorporate high degrees of resiliency, observability, and security for not only your tier 1 applications, but across your whole application portfolio.

Customers like Zoom have successfully and economically hosted millions of users and pushed petabytes of data on OCI’s networks every day. Customers like Nissan have run tens of thousands of cores of HPC compute for car design and testing on OCI. SaaS customers like Cisco, Workforce, and Manhattan Associates and services like Oracle Data Cloud transact millions of requests and billions of API calls on OCI every day. Whether you’re running an internet-scale service or a critical system of record for IT, Oracle Cloud Infrastructure is proven to help you do it faster, more economically, and more securely.

A graphic showing Oracle Cloud Infrastructure and Dedicated Region Cloud@Customer offerings.

Run MySQL in public cloud or a dedicated region

Oracle also has a highly differentiated ability to deploy an entire cloud region, with all public cloud services, including MySQL Database Service, in the customer premises. Respected Gartner analyst Lydia Leong has said that what customers really want is such a single tenant offering, with all provider services, an isolated control plane, at the same pricing model as the public cloud, and that Oracle is the only vendor to provide it. This offering enables customers that don’t have nearby public cloud access and customers with strict compliance or performance requirements to have MySQL as a service in a location of their choice. Production applications dependent on MySQL, or applications that need to be built or modernized alongside them, can all run in a Dedicated Region, consolidating and simplifying environments for customers.

Get started today on a better solution than self-managed, on premises, or in AWS

Because it’s fully compatible with MySQL Community edition or Enterprise edition, it’s simple to migrate from on-premises or other clouds. The benefits are clear, at a competitive price to self-management. The unique analytics capabilities add to an already significant price-performance advantage over AWS RDS, Aurora, or Redshift.

Start your 30-day free trial and get access to a wide range of Oracle Cloud services for 30 days, including MySQL Database Service. See the documentation for the quick steps to create your MySQL databases and use the MySQL Analytics Engine.

Learn more about migration and running applications with MySQL Database Service with the following guides and reference architectures:

Leo Leung

Vice President, Product Marketing, OCI

I'm an experienced product manager and product marketer at both large and startup vendors. I've been an cloud application, platform, and infrastructure end user and website developer, enterprise storage system product manager and marketer, cloud storage and cloud application product manager and operations manager, and storage software product marketer. I've managed business partnerships with many infrastructure ISVs, as well as large systems vendors like Cisco, Dell, EMC, HPE, and IBM.

Previous Post

DIY SOC2 compliance for custom containers and Kubernetes running on Oracle Cloud Infrastructure

Sanjay Basu | 4 min read

Next Post

Announcing Oracle Cloud Infrastructure Private DNS

Paul Cainkar | 3 min read