Oracle announced the general availability today of a new analytics engine for its MySQL database running in the cloud.
The MySQL database has long been used for online transaction processing (OLTP) workloads, though in recent years there has been demand for it to also support analytics use cases. The new Oracle MySQL Database Service with MySQL Analytics Engine will now enable users to run online analytics processing (OLAP) workloads alongside OLTP. The MySQL Analytics Engine will be available to only users of the Oracle Cloud Infrastructure platform, and is not part of the open source MySQL project.
“Just a few years after OLTP databases were established, the need for OLAP arose,” said Holger Mueller, vice president and principal analyst at Constellation Research. “But the need for enterprises to store OLTP and analyze data has not vanished — though it has eluded enterprises for the longest time.”
Mueller added that MySQL is a popular OLTP database, and with the addition of the MySQL Database Service Analytics Engine enterprises will be able to get both OLTP and OLAP from one product. It will also help improve developers’ abilities to build next-generation applications, he said.