Did you know that approximately 70% of Oracle customers are also using MySQL? The use cases for each database are often different – and sometime overlap. But the needs of a database are the same – among them are security, integration with other products, and strong monitoring. One of the advantages of the MySQL / Oracle relationship is that Oracle is integrating MySQL with many of its other software products such as:
- Goldengate, for real time heterogeneous replication from/to MySQL and other databases. Goldengate real life use cases include real time replication of selected MySQL data collected online to a data warehouse in Oracle, Teradata, Neteeza, etc; query offloading from a transactional system built on Oracle, DB2 Z series, SQL Server, etc to a MySQL query instance; and real time reporting by real time replication of a subset of data from corporate …