Abstract:With the rapid development of open source technology, open source database has completed the replacement of commercial database in many business scenarios. The substitution of MySQL database for Oracle database is the most common. In the process of staged substitution, MySQL database and Oracle database often exist in the same set of business system, and MySQL database needs to synchronize data with Oracle database. At the same time, the deployment mode of multi node and high availability cluster in MySQL database further increases the difficulty of data synchroni-zation. By researching the method of data extraction of MySQL cluster by using Oracle GoldenGate software, we design a set of effective schemes to solve the problem of synchronizing data from MySQL cluster to Oracle database, and ensure the consistency and integrity of database in the process of synchronization.