- MySQL only supports online transaction processing OLTP.
- MySQL is not designed for OLAP.
- So how to analyze data on MySQL
- Using HeatWave
- In Memory columnar analytics engine
- Optimized for OCI
- Have a HeatWave plugin.
- Heatwave nodes
- Number of heatwave nodes depends on size of data and amount of compression during loading of data.
- HeatWave is exclusively available to OCI.