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/kyym/dbsyncer-is-an-open-source-data-synchronization-middleware.html

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

What is the delivery method?

1, automatic: after taking the photo, click the (download) link to download; 2. Manual: After taking the photo, contact the seller to issue it or contact the official to find the developer to ship.

View details

How long is the trading cycle?

1, the default transaction cycle of the source code: manual delivery of goods for 1-3 days, and the user payment amount will enter the platform guarantee until the completion of the transaction or 3-7 days can be issued, in case of disputes indefinitely extend the collection amount until the dispute is resolved or refunded!

View details

Matters needing attention

1. Heptalon will permanently archive the process of trading between the two parties and the snapshots of the traded goods to ensure that the transaction is true, effective and safe! 2, Seven PAWS can not guarantee such as "permanent package update", "permanent technical support" and other similar transactions after the merchant commitment, please identify the buyer; 3, in the source code at the same time there is a website demonstration and picture demonstration, and the site is inconsistent with the diagram, the default according to the diagram as the dispute evaluation basis (except for special statements or agreement); 4, in the absence of "no legitimate basis for refund", the commodity written "once sold, no support for refund" and other similar statements, shall be deemed invalid; 5, before the shooting, the transaction content agreed by the two parties on QQ can also be the basis for dispute judgment (agreement and description of the conflict, the agreement shall prevail); 6, because the chat record can be used as the basis for dispute judgment, so when the two sides contact, only communicate with the other party on the QQ and mobile phone number left on the systemhere, in case the other party does not recognize self-commitment. 7, although the probability of disputes is very small, but be sure to retain such important information as chat records, mobile phone messages, etc., in case of disputes, it is convenient for seven PAWS to intervene in rapid processing.

View details

Systemhere declaration

1. As a third-party intermediary platform, Qichou protects the security of the transaction and the rights and interests of both buyers and sellers according to the transaction contract (commodity description, content agreed before the transaction); 2, non-platform online trading projects, any consequences have nothing to do with mutual site; No matter the seller for any reason to require offline transactions, please contact the management report.

View details