1. Learn about deploying MySQL Database Service in Oracle Cloud
  2. Learn About Deploying MySQL Database Service in Oracle Cloud

Learn About Deploying MySQL Database Service in Oracle Cloud

Oracle MySQL Database Service (MDS) is a fully-managed database service deployed within Oracle Cloud Infrastructure (OCI) that supports operators and developers looking to rapidly deploy secure, cloud-native applications.

Oracle MySQL Database Service is the only MySQL offering that includes the ability to use HeatWave, an integrated, high performance, in-memory query accelerator. HeatWave enables customers to run sophisticated analytics directly against their operational MySQL database, removing the requirement for complex, time-consuming, and expensive data migration and integration with a separate analytics database. HeatWave accelerates MySQL performance tremendously for analytics and mixed workloads. HeatWave is fully optimized for Oracle Cloud Infrastructure and Oracle MySQL Database Service is 100% built, managed, and supported by the Oracle Cloud Infrastructure and MySQL engineering teams.

About Oracle MySQL Database Service

Benefits of MySQL and Oracle MySQL Database Service include:

  • On-demand scalability: MDS offers unmatched scalability to facilitate the management of deeply integrated applications using a small footprint even in large deployments with many terabytes of data. On-demand flexibility is one of the key features of MDS. This database offering allows complete customization by eCommerce businesses with demanding database server requirements.

  • High performance: MDS features a unique storage-engine framework that allows system administrators to configure MDS for optimal performance. Regardless whether it’s to run an eCommerce site that receives a million queries in a day or a high-speed OLTP system, MDS is engineered to meet the requirements of even the most demanding applications while ensuring high speed, full-text indexes and unique memory cache for enhanced performance.

  • Data security: MDS is well known for being the most secure and reliable database management system, serving as the database back-end for web applications such as WordPress, Drupal, Joomla, Facebook and Twitter. The data security and support for transactional processing that are included in recent versions of MDS can greatly benefit any business, especially eCommerce businesses that involve frequent orders or other transactions.

  • Comprehensive transactional support: MDS ranks highly on the list of transactional database offerings available in the market. With features like complete atomic, consistent, isolated, durable transaction support, multiversion transaction support, and unrestricted row-level locking, it is the go-to solution for full data integrity. It guarantees instant deadlock identification through server-enforced referential integrity.

  • Reduced total cost of ownership (TCO): By migrating current database apps to MDS, enterprises are enjoying significant cost savings on new projects. The dependability and ease of management that accompany MDS save you time otherwise wasted troubleshooting downtime issues and performance problems.

About Deployment Options

Deployment options for Oracle MySQL Database Service include:

  • Standalone: With the Standalone option, users get a single-instance MDS back-ended by resilient and secure Oracle Cloud Infrastructure Block Volumes. This option is typically recommended for test and development environments.

  • High Availability: The High Availability option is recommended for use cases that require either or both higher uptime and zero data-loss requirements. When you select this option, MDS provides three instances across different availability or fault domains. The data is then replicated across the instances using a Paxos-based consensus protocol implemented by the MySQL Group Replication technology. Applications connect to only one endpoint to read and write data to the database. In case of a failure, MDS will automatically failover to a secondary instance in a matter of minutes, without data loss or application reconfiguration.

  • HeatWave: The HeatWave option deploys a preconfigured database system which allows accelerated query processing, suitable for both OLTP and OLAP workloads. With its innovative in-memory analytics engine, HeatWave provides 400x query acceleration for MySQL at a very compelling price.