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

DBSyncer is an open source data synchronization middleware插图

Assumed source table data format

DBSyncer is an open source data synchronization middleware插图1

Preview

DBSyncer is an open source data synchronization middleware插图2

Driver management

DBSyncer is an open source data synchronization middleware插图3

Driver details

DBSyncer is an open source data synchronization middleware插图4

Driver table field relationship configuration

DBSyncer is an open source data synchronization middleware插图5

Monitor

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

Telegram:@John_Software

collect(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.

Ictcoder Free Source Code DBSyncer is an open source data synchronization middleware https://ictcoder.com/dbsyncer-is-an-open-source-data-synchronization-middleware/

lllll

Share free open-source source code

Previous article： Python3-based open source OCR identification toolkit with multiple identification models

Next article： Background management system based on Vue3.0+TypeScript+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. ICTcoder will then settle the payment for the seller. Note: Please ensure to place your order and make payment through ICTcoder. If you do not place your order and make payment through ICTcoder, and the seller sends fake source code or encounters any issues, ICTcoder 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 ICTcoder until 7 days after the transaction is completed and both parties confirm that there are no issues. ICTcoder will then settle with the seller. In case of any disputes, ICTcoder 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 ICTcoder, any issues and disputes have nothing to do with ICTcoder, and ICTcoder will not be responsible for any liabilities!

View details

Matters needing attention

1. ICTcoder 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. ICTcoder 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 ICTcoder 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 ICTcoder can intervene quickly.

View details

ICTcoder reminds and declares

1. As a third-party intermediary platform, ICTcoder 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 ICTcoder 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