MySQL Database Service is now easier to use and has flexible deployment options, including High Availability. While creating a new DB System using the web console, users can choose between Standalone, Highly Availability, and HeatWave deployments. The service will pre-populate the necessary fields with the recommended settings. You only need to provide the MySQL user name and password to get MySQL up and running.
With the Standalone option, users get a single-instance MySQL DB System back-ended by the resilient and secure OCI Block Volumes. This option is the most common for test and development environments.
The High Availability option enables applications to meet higher uptime requirements and zero data loss tolerance. When you select the High Availability option, a MySQL DB System with three instances is provisioned across different availability or fault domains. The data is replicated among the instances using a Paxos-based consensus protocol implemented by the MySQL Group Replication technology. Your application connects to a single endpoint to read and write data to the database. In case of failure, the MySQL Database Service will automatically failover within minutes to a secondary instance without data loss and without requiring to reconfigure the application. See the documentation to learn more about MySQL Database Service High Availability.
The HeatWave option deploys a pre-configured DB System to allow accelerated query processing, suitable for running both OLTP and OLAP workloads. With its innovative in-memory analytics engine, HeatWave provides 400x query acceleration for MySQL at a very compelling price.
If you have an existing MySQL application experiencing slow queries, you can also request a Performance Health Check. A MySQL Technician will work closely with your team to run your queries using MySQL Database Service with HeatWave to verify the performance improvements.
You can try MySQL Database Service and many other services for free. Go to oracle.com/cloud/free and create your free account in Oracle Cloud Infrastructure. Check the documentation for the quick steps to create your MySQL databases.