DBSyncer is an open source data synchronization middleware. Provides synchronization scenarios such as Mysql, Oracle, SqlServer, Elasticsearch(ES), Kafka, and SQL(Mysql/Oracle/SqlServer). You can upload plug-ins to customize synchronous conversion services, monitor full and incremental data statistics, and warn application performance.

Combination drive, custom library synchronization to library combination, combination between relational database and non-relational, any collocation table synchronization mapping relationship
Real-time monitoring, driving full or incremental real-time synchronization of operating status, results, synchronization logs and system logs
Develop plugins and customize conversion synchronization logic

Installation and configuration

< Steps

Install JDK 1.8 (details omitted)
Download installation package DBSyncer-1.0.0-Beta.zip
Decompress the installation package, run bin/startup.bat for Windows, and bin/startup.sh for Linux.
Open your browser to http://127.0.0.1:18686
Account and password: admin/admin

Incremental Synchronization Configuration (source repository)

Mysql

Dump Binlog binary logs. The Master synchronizes the Slave, creates IO threads to read data, writes to relaylog, and captures incremental data based on message subscriptions.
Configuration

Modify the my.ini file

# Service unique ID
server_id=1
log-bin=mysql_bin
binlog-format=ROW
max_binlog_cache_size = 256M
max_binlog_size = 512M
expire_logs_days = 7
# Listen to synchronized libraries, multiple libraries using commas ", "concatenate 
replicate-do-db=test

Oracle

CDN Registration Subscription. Listen to add, delete and change events, get rowid, execute SQL query according to rowid, get the changed data.
grants the account the permission to listen, and requires that the target source table must define a varchar field of length 18, and implement the operation by receiving the rowid value.

grant change notification to Your account

Timing

Preview

资源下载此资源为免费资源立即下载

Telegram:@John_Software

☆☆☆☆☆0 pts · 0 reviews

Updated 2025-02-24

Q&A

No questions yet. Ask the seller!

Reviews

No reviews yet. Share your experience after purchase.

收藏(0) Like (0)

Disclaimer: This article is published by a third party and represents the views of the author only and has nothing to do with this website. This site does not make any guarantee or commitment to the authenticity, completeness and timeliness of this article and all or part of its content, please readers for reference only, and please verify the relevant content. The publication or republication of articles by this website for the purpose of conveying more information does not mean that it endorses its views or confirms its description, nor does it mean that this website is responsible for its authenticity.

TopTinker Enterprise & Office Open Source Data Synchronization Middleware for Databases and Search Engines https://toptinker.com/38579.html

lllll 商家类型：个人（声明）

Share free open-source source code

Previous article： Python 3 OCR Toolkit for Text Recognition in Screenshots and Printed Images

Next article： Vue3, Vite, TypeScript Admin Dashboard Template with Element-Plus

Q&A

Ordering Process

1. Automatic: After making an online payment, click the (Download) link to download the source code; 2. Manual: Contact the seller or the official to check if the template is consistent. Then, place an order and make payment online. The seller ships the goods, and both parties inspect and confirm that there are no issues. TopTinker will then settle the payment for the seller. Note: Please ensure to place your order and make payment through TopTinker. If you do not place your order and make payment through TopTinker, and the seller sends fake source code or encounters any issues, TopTinker will not assist in resolving them, nor can we guarantee your funds!

View details

Transactions and Disputes

1. Default transaction cycle for source code: The seller manually ships the goods within 1-3 days. The amount paid by the user will be held in escrow by TopTinker until 7 days after the transaction is completed and both parties confirm that there are no issues. TopTinker will then settle with the seller. In case of any disputes, TopTinker will have staff to assist in handling until the dispute is resolved or a refund is made! If the buyer places an order and makes payment not through TopTinker, any issues and disputes have nothing to do with TopTinker, and TopTinker will not be responsible for any liabilities!

View details

Matters needing attention

1. TopTinker will permanently archive the transaction process between both parties and snapshots of the traded goods to ensure the authenticity, validity, and security of the transaction! 2. TopTinker cannot guarantee services such as "permanent package updates" and "permanent technical support" after the merchant's commitment. Buyers are advised to identify these services on their own. If necessary, they can contact TopTinker for assistance; 3. When both website demonstration and image demonstration exist in the source code, and the text descriptions of the website and images are inconsistent, the text description of the image shall prevail as the basis for dispute resolution (excluding special statements or agreements); 4. If there is no statement such as "no legal basis for refund" or similar content, any indication on the product that "once sold, no refunds will be supported" or other similar declarations shall be deemed invalid; 5. Before the buyer places an order and makes payment, the transaction details agreed upon by both parties via WhatsApp or email can also serve as the basis for dispute resolution (in case of any inconsistency between the agreement and the description of the conflict, the agreement shall prevail); 6. Since chat records and email records can serve as the basis for dispute resolution, both parties should only communicate with each other through the contact information left on the system when contacting each other, in order to prevent the other party from denying their own commitments. 7. Although the probability of disputes is low, it is essential to retain important information such as chat records, text messages, and email records, in case a dispute arises, so that TopTinker can intervene quickly.

View details

TopTinker reminds and declares

1. As a third-party intermediary platform, TopTinker solely protects transaction security and the rights and interests of both buyers and sellers based on the transaction contract (product description, agreed content before the transaction); 2. For online trading projects not on the TopTinker platform, any consequences are unrelated to this platform; regardless of the reason why the seller requests an offline transaction, please contact the administrator to report.

View details