MySQL continues to be the most well-liked open supply and developer database on the planet based on DB Engines and Stack Overflow. It’s rated 4.5 out of 5 stars by 1000’s of engineers and customers 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 straightforward to deploy and be taught. It’s quick, dependable, and confirmed. It handles many varieties of use instances from massive web sites like Zillow, to tons of of recreation backends at SQUARE ENIX, to tons of of microservices functions at Square. It really works properly with an enormous ecosystem, together with Java, Python, Node.js, .NET, Linux, Home windows, Apache Tomcat, Kubernetes, and so forth.
We’ve labored exhausting to construct a MySQL cloud service worthy of the title. As we speak, we’re excited to announce an unique functionality on Oracle Cloud Infrastructure (OCI): now you possibly can run each on-line transaction processing (OLTP) and on-line analytics processing (OLAP) workloads within the MySQL Database Service. Earlier than we focus on this highly effective new functionality, let’s recap our total MySQL managed service.
In April, we introduced the MySQL Database Service on Oracle Cloud Infrastructure. Our aim was to construct a cloud service that provides you the newest MySQL options that you really want, with none of the overhead of infrastructure administration. With that in thoughts, our service eliminates the necessity to personal and preserve information heart house or purchase and preserve servers and storage. It consists of automated provisioning, configuration, scaling, patching, upgrading, and backup. It routinely runs the newest model of MySQL (8.0.22) with the newest enhancements and bug fixes.
Evaluate with on-premises, and the distinction is stark.
In September and October, we expanded availability to a complete of eight cloud areas globally together with the U.S., Brazil, Canada, Germany, the U.Ok., Tokyo, and India. In November, we added support for our OCI E3 compute shapes, scaling as much as 64 OCPUs and 1 TB of RAM per digital machine (VM). For a typical MySQL utility needing 100 cores and 1 TB of storage, Oracle Cloud is one-third the value of an identical configuration of AWS RDS in america. And since Oracle prices the identical costs all over the world, the value benefit is even better exterior of the U.S.
MySQL Database Service: Commonplace E3 AMD 16GB per core, all areas have the identical worth
Amazon RDS: Intel R5 16GB per core, AWS US East
Azure: Reminiscence Optimized Intel 20GB per core, MS Azure US-East
Google: Excessive Reminiscence N1 Commonplace Intel 13GB per Core, GCP Northern Virginia
Configuration: 100 OCPUs, 1-TB storage
All this offers you with a compelling alternative on your transactional functions. However, there’s extra.
Enter the MySQL Database Service Analytics Engine
As datasets inside MySQL functions have grown, we noticed a brand new and distinctive alternative. Information has gravity, and every time you need to transfer information to a distinct database prices time and community bandwidth, and infrequently requires a distinct ability set to handle that separate information administration stack. We constructed a brand new engine to get rid of the necessity to extract, rework, and cargo from MySQL.
Benefiting from Oracle’s highly effective cloud infrastructure, the brand new MySQL Analytics Engine processes information in-memory and is optimized for OCI’s reminiscence, CPU, and community structure. The end result? In TPC-H derived queries, analytics are 400 occasions quicker than typical MySQL and at the very least 2 occasions quicker than even AWS Redshift, a service that’s targeted on analytic workloads.
*Benchmark queries are derived from the TPC-H benchmark, however outcomes aren’t corresponding to printed TPC-H benchmark outcomes since they don’t adjust to the TPC-H specification
Utilizing the brand new analytics capabilities is easy. Present functions don’t require modifications. You merely add an analytics cluster to your present cloud MySQL setting, load your tables, after which question the analytics cluster via your MySQL occasion. Additional information propagation is automated and in actual time. You possibly can question information inside seconds of loading. MySQL Analytics Engine has built-in resilience and routinely reforms the analytics cluster and reloads tables if failure happens. You possibly can even use the MySQL Database Service to run analytics in opposition to on-premises MySQL!
Certainly one of 58 Oracle Cloud Infrastructure providers
As you think about the MySQL Database Service on your transactional and analytic functions, know that it’s a local a part of an ever-growing ecosystem of 58 Oracle Cloud providers, third events, and open supply. OCI is famous for its excellent 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 cost for bandwidth throughout availability domains, solely prices for log storage, and consists of a number of superior safety providers together with automated menace monitoring and remediation for free of charge.
So, you possibly can migrate and run present MySQL-based functions, modernize them, or construct new functions far more economically. You possibly can run VM-based and container-based functions or pure capabilities. You possibly can incorporate excessive levels of resiliency, observability, and safety for not solely your tier 1 functions, however throughout your complete utility portfolio.
Clients like Zoom have successfully and economically hosted millions of users and pushed petabytes of data on OCI’s networks every day. Clients like Nissan have run tens of thousands of cores of HPC compute for car design and testing on OCI. SaaS prospects like Cisco, Workforce, and Manhattan Associates and providers like Oracle Information Cloud transact hundreds of thousands of requests and billions of API calls on OCI day-after-day. Whether or not you’re working an internet-scale service or a crucial system of file for IT, Oracle Cloud Infrastructure is confirmed that will help you do it quicker, extra economically, and extra securely.
Run MySQL in public cloud or a devoted area
Oracle additionally has a extremely differentiated capability to deploy a whole cloud area, with all public cloud providers, together with MySQL Database Service, within the buyer premises. Revered 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 providing allows prospects that don’t have close by public cloud entry and prospects with strict compliance or efficiency necessities to have MySQL as a service in a location of their alternative. Manufacturing functions depending on MySQL, or functions that have to be constructed or modernized alongside them, can all run in a Devoted Area, consolidating and simplifying environments for patrons.
Get began right this moment on a greater answer than self-managed, on premises, or in AWS
As a result of it’s totally suitable with MySQL Group version or Enterprise version, it’s easy to migrate from on-premises or other clouds. The advantages are clear, at a aggressive worth to self-management. The distinctive analytics capabilities add to an already vital price-performance benefit over AWS RDS, Aurora, or Redshift.
Begin your 30-day free trial and get entry to a variety of Oracle Cloud providers for 30 days, together with MySQL Database Service. See the documentation for the fast steps to create your MySQL databases and use the MySQL Analytics Engine.
Study extra about migration and working functions with MySQL Database Service with the next guides and reference architectures: