Shulou(Shulou.com)06/02 Report--

This article will explain in detail how to synchronize real-time data from MySQL to Oracle. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have some understanding of the relevant knowledge after reading this article.

Step 1: configure the MySQL connection

1. Click "connection Management" in the left menu bar of the Tapdata Cloud operation background, then click the "create connection" button in the upper right corner of "connection list" in the right area, open the connection type selection page, and then select MySQL.

two。 Enter the required configuration information on the connection information configuration page that opens

[connection name]: set the name of the connection. The names of multiple connections cannot be repeated.

[database address]: database IP / Host

[Port]: database port

[database name]: tapdata database connection uses a db as a data source. The db here refers to the database in a database instance, not an mysql instance.

[account number]: the account number that can access the database

[password]: the password corresponding to the database account

[time zone]: the time zone of the database is used by default. If you specify a time zone, the specified time zone setting is used.

3. Test the connection and prompt the test to pass

4. Just save the connection after passing the test.

Step 2: configure the Oracle connection

1. To do the same as the first step, click "connection Management" in the left menu bar, then click "create connection" button in the upper right corner of "connection list" in the right area, open the connection type selection page, and then select Oracle.

two。 Enter the required configuration information in turn in the open connection information configuration page, and then save the test connection after the configuration is completed.

Step 3: select synchronization mode-full / incremental / full + increase

Go to the Tapdata Cloud operation background task management page, and click the add Task button to enter the task setting process.

According to the connection just established, select the source side and the target side.

According to the data requirements, select the libraries and tables that need to be synchronized. If you need to modify the table name, you can batch set the table name on the target side through the batch modification function of the table name on the page.

After the above options are set, the next step is to select the synchronization type. The platform provides full synchronization, incremental synchronization, full + incremental synchronization, and sets the write mode and the number of reads.

If full + incremental synchronization is selected, Tapdata Agent will automatically enter the incremental synchronization state after the full task is completed. In this state, Tapdata Agent continuously listens for data changes on the source side (including write, update, delete), and writes these data changes to the target side in real time.

Click the task name to open the task details page, where you can view the task details.

Click Task Monitoring to open the task execution details page, where you can view specific information about task progress / milestones, etc.

Step 4: check the data

After the general synchronization is completed, I am used to checking the data to prevent stepping on the pit.

Tapdata Cloud has three check modes. I often use the fastest fast count check. I only need to select the table to be verified without setting other complex parameters and conditions.

If you feel that it is not enough, you can also choose the full field value check of the table, which not only needs to select the table to be checked, but also needs to set the index field for each table.

Advanced verification is also supported when checking the full field values of the table. JS verification logic can be added through advanced verification, which can verify the data of the source and destination.

There is also a check method to associate a field value check. When creating an associated field value check, in addition to selecting a table to be checked, you also need to set an index field for each table.

It's not too convenient to write your own code. The above is the operation sharing of real-time synchronization of MySQL data to Oracle. I hope the above operation sharing will be helpful to you! The codeword is not easy. Please indicate the source when reprinted.

Synchronization of other databases

The real-time synchronization of other database data to Oracle, MySQL, PG, SQL Server, MongoDB, ES, Dameng, Kafka, GP, MQ, ClickHouse, Hazelcast Cloud, ADB MySQL, ADB PostgreSQL, KunDB, TiDB, Dummy DB is also done by configuring the connection between the source and the destination, and then selecting the synchronization mode for the new task: full / incremental / full + increment, because the steps are the same, other mapping will not be described. When creating a connection, did you find that DB2, Sybase, and Gbase databases are now in a gray locked state, which should be under development, and may support the synchronization of these databases later. Tapdata Cloud is promised to be used for free forever, but friends with higher requirements and budgets can also use the enterprise version, which can be found on Tapdata's website: tapdata.net, or you can apply for a trial.

So much for real-time data synchronization from MySQL to Oracle. I hope the above content can be helpful to you and learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.