- Integrated Data Dictionary: the new dictionary is created to replace the the .frm and InnoDB DD dictionary. This feature is needed to support transactional DDL operation in the future.
- Encryption of transaction log (redo and undo log)
MySQL 8.0 is still under development. The followings are some major features discussed in the OpenWorld session:
Yes,The latest bundle patch release of Oracle GoldenGate for MySQL, ORACLE GOLDENGATE V18.104.22.168.160823 FOR MySQL, starts to certify on MySQL 5.7. New MySQL 5.7 features, including the JSON datatype and the enhanced distributed transaction, are not supported in this release. Oracle GoldenGate for MySQL supports both data capture and delivery for MySQL databases. You can download this release at http://support.oracle.com.
If you run earlier versions of Oracle GoldenGate with MySQL 5.7, you could get the following error :
2016-03-02 07:07:19 ERROR OGG-00146 Call to VAMRead returned with error status 600: VAM Client Report < CAUSE OF FAILURE : Event Pointer is NULL WHEN FAILED : While processing the event in logProcessor WHERE FAILED : MySQLBinLog Reader Module CONTEXT OF FAILURE : No Information Available!>
GoldenGate for MySQL
Oracle GoldenGate for MySQL replicates DML operations for MySQL databases. Here, I discuss Oracle GoldenGate for MySQL, MySQL database and MySQL replication.
Heterogeneity Security High Performance Real-Time DML Globalization