While MySQL is a popular, open-source database famous for its reliability, high-performance, and ease of use – it is optimized only for online transaction processing (OLTP) and not online analytical processing (OLAP). This raises the need to create separate systems for OLTP and OLAP, which is an error-prone process and creates lags. Moreover, the changes made to OLTP database do not automatically reflect in the OLAP counterpart.
MySQL HeatWave is the only MySQL service with a native scalable query accelerator that:
- Uses single database for both transaction and analytical processing
- Eliminates ETL (extract, transform, load) and supports real-time analytics
- Delivers extreme performance which is 400x faster than MySQL and scales to thousands of cores.
MySQL Database Service with HeatWave on Oracle Cloud Infrastructure is 100% developed, managed, and supported by Oracle. This service is built on an innovative, in-memory analytics engine which is architected for scalability and performance and is optimized for Oracle Cloud Infrastructure (OCI) Gen2 hardware. Note that Oracle uses the enterprise version of MySQL rather than the open-source version provided as a managed services by Amazon and Google. This makes MDS a highly optimized services for the OCI and the cost to a customer is approximately one-third of any major cloud vendor.
On September 01 at 11 AM Central, Infolob will deliver an executive webinar on the Oracle MySQL Database Service and HeatWave on Oracle Cloud Infrastructure (OCI). It will cover:
- MDS Architecture
- Heatwave Architecture
- Native MySQL Analytics
- Real-time Analytics for MySQL on Prem
- Deployment Scenarios
- Aurora to MDS Migration
- Infolob MDS Heatwave Services