The Benefits of running MySQL in the Oracle Cloud
MySQL
MySQL is the world’s most popular open-source database because of its reliability, high performance, and ease of use. It powers the world’s most trafficked websites including Facebook, Twitter, YouTube and Booking.com. MySQL combines the benefits of a widely adopted open-source database solution with a strong ecosystem, millions of users, and the backing of Oracle. According to DB-Engines, MySQL is ranked as the most popular open-source database[1] with millions of downloads every year and this number is continuously rising. In addition, MySQL was named DBMS of the Year in 2019[2].
Security and Compliance
Always up to date with the Latest Security Fixes. Get the latest MySQL security updates from the MySQL Team to limit your exposure to security vulnerabilities. Advanced Security Features to Help Meet Regulatory Requirements. Access built-in MySQL security features to comply with governments’ data privacy laws and regulatory requirements for GDPR, HIPAA, etc.
Native to Oracle Gen 2 Cloud
MySQL Database Service is designed to work natively with Oracle Gen 2 Cloud. Oracle adopts a zero-trust architecture. The zero-trust strategy within Oracle Cloud delivers security-first design principles which are built-in, automated and always on within Oracle Cloud services. This reduces complexity and human error and therefore increase the overall security. Its core infrastructure includes total encryption, least privilege identity, access management as well as granular resource and network control. MySQL Database Service is fully integrated with Oracle technologies such as Oracle Golden Gate, Oracle Data Integrator, Oracle Audit Vault, Oracle Container Engine for Kubernetes, Oracle Analytics Cloud, and more.
Native High Availability
To achieve high availability, the database system must be resilient to many types of failures (server, network, power, et cetera). If this is to happen, companies can protect their data and ensure business continuity using High Availability (HA) solutions. With the MySQL Database Service on OCI, native HA is built-in with automatic failover. MySQL Database Service on OCI optimizes the placement of database instances in different availability- and fault domains, resulting in the highest availability. In addition, the solution uses group replication over the used fault domains. This means that the replications are spread over different datacenters and in case of a failure, resulting in zero data loss.
MySQL Database Service is a fully managed service, running on Oracle Gen 2 Cloud Infrastructure. It enables you to:
- Instantly provision MySQL instances and connect to a production-ready, pre-configured MySQL database.
- Automate database specific tasks such as configuration, security patching, backup, and monitoring.
- Choose from multiple compute shapes, depending on your application and capacity requirements.
- Provision fast, reliable, and secure cloud storage for all enterprise workloads.
- Set up fast, predictable networking with end-to-end network security, including a Virtual Cloud Network (VCN).
- Monitor the health of your resources, optimize the performance of your applications, and respond to anomalies in real-time.
- Access dozens of additional Oracle Cloud Services for a faster transition to the cloud.
- On-the-go scalability of your resources.
This results in more uptime of developers, database engineers, and DevOps to focus on value-added tasks that are key to your business. In the below overview, you can see the differences between the traditional MySQL on-premises solution and the fully managed MySQL Database Service.
Cost Savings
Comparing the cost of MySQL Database Service to its competitors such as Amazon RDS, Microsoft Azure for MySQL, and Google Cloud SQL, it is apparent that Oracle MySQL Database Service is the best ‘bang for your buck’. The cost savings can be calculated in the publicly available price lists. As you can see in the chart below MySQL Database Services is significantly less expensive than its competitors.
HeatWave
Oracle recently introduced a new MySQL PaaS solution called ‘HeatWave’. This service provides the only hyper-scalable integrated query accelerator and is exclusively available in the Oracle Cloud Infrastructure (OCI). This solution overcomes the limitations of traditional data warehouse and analytics environments that use periodic long-running ETL batch jobs required to refresh data. Therefore, HeatWave delivers:
- 5400x Faster MySQL query acceleration (using industry-standard TCP-H benchmark) compared to Amazon RDS at 2/3 of the cost.
- 1400x faster than Amazon Aurora (using industry-standard TCP-H benchmark) at 1/2 the cost (comparing 1 year of TCO).
- At half the cost of Amazon Redshift.
- 8x faster (TCP-H benchmark) and 1/2 the cost over Amazon Snowflake.
- A single MySQL database for OLTP and OLAP.
- Run existing applications and BI without changes.
Conclusion
If you are looking into renewing your infrastructure, or considering a move to the cloud, this is the perfect moment to opt for Oracle Cloud and its MySQL offerings. You have a serious chance of increasing your performance, decreasing your cost, and therefore maximizing your ROI in a secure, flexible, and fully managed environment. And maybe you were not aware yet, but Oracle Cloud Infrastructure and Quistor embrace your multi-cloud journey. With the current partnership between Microsoft and Oracle you are able to connect your Oracle Cloud Infrastructure to Microsoft Azure with under 2 milliseconds of latency.
[1] (DB-Engines, 2022)
[2] (Matthias Gelbmann, 2020)
Are you interested in learning more about MySQL in the Cloud? Register here to join our webinar!