Giter Club home page Giter Club logo

dbsync's Introduction

dbsync

database sync tools.

config

config.json file.

  1. SrcDB source database config.
  2. DesDB destcation database config.
  3. DataSync data sync handle config.

eg :

eg Logo

build

  • make install
  • make
  • make release

run

./bin/start.sh

note

dbsync是数据库同步工具,使用go编写,主要特性有

  1. 支持数据库种类多(oracle,postgresql,mysql,sqlserver等,其他添加中)
  2. 灵活支持自定义SQL,支持多表和视图
  3. 支持字段映射,可以配置字段的映射关系
  4. 批量操作,性能较高

benchmark

  • 本地虚拟机 centos6 2核2G
  • PostgreSQL 10.6
  • mysql 5.1.73
  1. insert 117275 条记录 14S TPS 8376/s
  2. update 117275 条记录 44S TPS 2665/s

problem

如果有任何疑问或错误,欢迎在 issues 进行提问或给予修正意见。 如果喜欢或对你有所帮助,欢迎 Star。

我是小铭哥 专注做后台开发和系统架构 我在重庆两江新区。

wx Logo

License

所有文章采用知识共享署名-非商业性使用-相同方式共享 3.0 **大陆许可协议进行许可。

dbsync's People

Contributors

zhangjinming avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.