# db-db-job **Repository Path**: bboss/db-db-job ## Basic Information - **Project Name**: db-db-job - **Description**: db-db-job spring boot同步案例工程 - **Primary Language**: Java - **License**: Apache-2.0 - **Default Branch**: master - **Homepage**: https://esdoc.bbossgroups.com/#/db-es-tool?id=_5-database-database%e6%95%b0%e6%8d%ae%e5%90%8c%e6%ad%a5%e4%bd%bf%e7%94%a8%e6%96%b9%e6%b3%95 - **GVP Project**: No ## Statistics - **Stars**: 0 - **Forks**: 0 - **Created**: 2020-04-04 - **Last Updated**: 2025-11-17 ## Categories & Tags **Categories**: Uncategorized **Tags**: None ## README # Spring boot数据库到数据库同步工具 通过本工具可以非常方便地实现多种数据源之间的数据同步功能，数据库与数据库之间的数据同步功能 Bboss is a good elasticsearch Java rest client. It operates and accesses elasticsearch in a way similar to mybatis. [基于spring boot数据库到数据库同步案例使用参考文档](https://esdoc.bbossgroups.com/#/usedatatran-in-spring-boot) # BBoss Environmental requirements JDK requirement: JDK 1.8+ Elasticsearch version requirements: 1.x,2.X,5.X,6.X,+ Spring booter 1.x,2.x,+ # bboss elasticsearch 数据导入工具demo 使用本demo所带的应用程序运行容器环境，可以快速编写，打包发布可运行的数据导入工具 支持的数据库： mysql,maridb，postgress,oracle ,sqlserver,db2等 支持的Elasticsearch版本： 1.x,2.x,5.x,6.x,+ 支持海量PB级数据同步导入功能 [使用参考文档](https://esdoc.bbossgroups.com/#/db-es-tool) # 构建部署 ## 准备工作 gradle安装配置参考文档： https://esdoc.bbossgroups.com/#/bboss-build ## 下载源码工程-基于gradle 从上面的地址下载源码工程，然后导入idea或者eclipse，根据自己的需求，修改导入程序逻辑 com.frameworkset.sqlexecutor.Db2DBdemo 如果需要测试和调试导入功能，运行com.frameworkset.sqlexecutor.Application的main方法即可即可： 修改数据库配置-db-db-job\src\main\resources\application.properties db-db-job工程已经内置mysql jdbc驱动，如果有依赖的第三方jdbc包（比如oracle驱动），可以将第三方jdbc依赖包放入db-db-job\lib目录下 修改完毕配置后，就可以进行功能调试了。 测试调试通过后，就可以构建发布可运行的版本了：进入命令行模式，在源码工程根目录db-db-job下运行以下gradle指令打包发布版本 release.bat ## 运行作业 gradle构建成功后，在build/distributions目录下会生成可以运行的zip包，解压运行导入程序 linux： chmod +x restart.sh ./restart.sh windows: restart.bat ## 作业jvm配置 修改jvm.options，设置内存大小和其他jvm参数 -Xms1g -Xmx1g # 作业参数配置 在使用[db-elasticsearch-tool](https://github.com/bbossgroups/db-elasticsearch-tool)时，为了避免调试过程中不断打包发布数据同步工具，可以将部分控制参数配置到启动配置文件resources/application.properties中,然后在代码中通过以下方法获取配置的参数： ```ini #工具主程序 mainclass=org.frameworkset.elasticsearch.imp.Dbdemo # 参数配置 # 在代码中获取方法：CommonLauncher.getBooleanAttribute("dropIndice",false);//同时指定了默认值false dropIndice=false ``` 在代码中获取参数dropIndice方法： ```java boolean dropIndice = CommonLauncher.getBooleanAttribute("dropIndice",false);//同时指定了默认值false ``` 另外可以在resources/application.properties配置控制作业执行的一些参数，例如工作线程数，等待队列数，批处理size等等： ``` queueSize=50 workThreads=10 batchSize=20 ``` 在作业执行方法中获取并使用上述参数： ```java int batchSize = CommonLauncher.getIntProperty("batchSize",10);//同时指定了默认值 int queueSize = CommonLauncher.getIntProperty("queueSize",50);//同时指定了默认值 int workThreads = CommonLauncher.getIntProperty("workThreads",10);//同时指定了默认值 importBuilder.setBatchSize(batchSize); importBuilder.setQueue(queueSize);//设置批量导入线程池等待队列长度 importBuilder.setThreadCount(workThreads);//设置批量导入线程池工作线程数量 ``` ## 技术交流群:166471282 ## 微信公众号:bbossgroup ![GitHub Logo](https://static.oschina.net/uploads/space/2017/0617/094201_QhWs_94045.jpg) CREATE TABLE `batchtest` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(4000) DEFAULT NULL, `author` varchar(1000) DEFAULT NULL, `content` longtext, `title` varchar(1000) DEFAULT NULL, `optime` datetime DEFAULT NULL, `oper` varchar(1000) DEFAULT NULL, `subtitle` varchar(1000) DEFAULT NULL, `collecttime` datetime DEFAULT NULL, `ipinfo` varchar(2000) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=271475 DEFAULT CHARSET=utf8 INSERT INTO batchtest (id, name, author, content, title, optime, oper, subtitle, collecttime, ipinfo) VALUES (269389, '认证管理', 'duoduo', 'admin(系统管理员) 退出[公共开发平台]', '解放', '2018-05-20 00:33:34', 'admin', '小康', '2020-05-07 23:14:28', '{"country":"中国","countryId":"CN","area":"","areaId":"","region":"浙江省","regionId":"ZJ","city":"杭州","cityId":"","county":"浙江省","countyId":"ZJ","isp":"Chinanet","ispId":4134,"ip":"115.204.150.34","geoPoint":{"lon":120.1619,"lat":30.294}}'); INSERT INTO batchtest (id, name, author, content, title, optime, oper, subtitle, collecttime, ipinfo) VALUES (269390, '认证管理', 'duoduo', 'admin(系统管理员) 登陆[内容管理系统平台]', '解放', '2018-04-11 23:02:46', 'admin', '小康', '2020-05-07 23:14:28', '{"country":"中国","countryId":"CN","area":"","areaId":"","region":"浙江省","regionId":"ZJ","city":"杭州","cityId":"","county":"浙江省","countyId":"ZJ","isp":"Chinanet","ispId":4134,"ip":"115.204.150.34","geoPoint":{"lon":120.1619,"lat":30.294}}'); INSERT INTO batchtest (id, name, author, content, title, optime, oper, subtitle, collecttime, ipinfo) VALUES (269391, '认证管理', 'duoduo', 'admin(系统管理员) 退出[公共开发平台]', '解放', '2018-03-27 23:12:54', 'admin', '小康', '2020-05-07 23:14:28', '{"country":"中国","countryId":"CN","area":"","areaId":"","region":"浙江省","regionId":"ZJ","city":"杭州","cityId":"","county":"浙江省","countyId":"ZJ","isp":"Chinanet","ispId":4134,"ip":"115.204.150.34","geoPoint":{"lon":120.1619,"lat":30.294}}'); INSERT INTO batchtest (id, name, author, content, title, optime, oper, subtitle, collecttime, ipinfo) VALUES (269392, '机构管理', 'duoduo', '系统管理员新增子机构3eqr', '解放', '2016-11-29 00:05:57', 'admin', '小康', '2020-05-07 23:14:28', '{"country":"中国","countryId":"CN","area":"","areaId":"","region":"浙江省","regionId":"ZJ","city":"杭州","cityId":"","county":"浙江省","countyId":"ZJ","isp":"Chinanet","ispId":4134,"ip":"115.204.150.34","geoPoint":{"lon":120.1619,"lat":30.294}}'); INSERT INTO batchtest (id, name, author, content, title, optime, oper, subtitle, collecttime, ipinfo) VALUES (269393, '认证管理', 'duoduo', 'admin(系统管理员) 登陆[内容管理系统平台]', '解放', '2018-03-12 23:52:06', 'admin', '小康', '2020-05-07 23:14:27', '{"country":"中国","countryId":"CN","area":"","areaId":"","region":"浙江省","regionId":"ZJ","city":"杭州","cityId":"","county":"浙江省","countyId":"ZJ","isp":"Chinanet","ispId":4134,"ip":"115.204.150.34","geoPoint":{"lon":120.1619,"lat":30.294}}'); INSERT INTO batchtest (id, name, author, content, title, optime, oper, subtitle, collecttime, ipinfo) VALUES (269394, '认证管理', 'duoduo', 'admin(系统管理员) 退出[公共开发平台]', '解放', '2018-03-12 21:16:50', 'admin', '小康', '2020-05-07 23:14:28', '{"country":"中国","countryId":"CN","area":"","areaId":"","region":"浙江省","regionId":"ZJ","city":"杭州","cityId":"","county":"浙江省","countyId":"ZJ","isp":"Chinanet","ispId":4134,"ip":"115.204.150.34","geoPoint":{"lon":120.1619,"lat":30.294}}'); INSERT INTO batchtest (id, name, author, content, title, optime, oper, subtitle, collecttime, ipinfo) VALUES (269395, '认证-管理', 'duoduo', 'admin(系统管理员) 登陆[公共开发平台]', '解放', '2019-10-31 23:48:55', '|admin', '小康', '2020-05-07 23:14:28', '{"country":"中国","countryId":"CN","area":"","areaId":"","region":"浙江省","regionId":"ZJ","city":"杭州","cityId":"","county":"浙江省","countyId":"ZJ","isp":"Chinanet","ispId":4134,"ip":"115.204.150.34","geoPoint":{"lon":120.1619,"lat":30.294}}'); INSERT INTO batchtest (id, name, author, content, title, optime, oper, subtitle, collecttime, ipinfo) VALUES (269396, '站点管理', 'duoduo', '创建站点.站点名:test', '解放', '2018-03-12 23:37:34', 'admin', '小康', '2020-05-07 23:14:27', '{"country":"中国","countryId":"CN","area":"","areaId":"","region":"浙江省","regionId":"ZJ","city":"杭州","cityId":"","county":"浙江省","countyId":"ZJ","isp":"Chinanet","ispId":4134,"ip":"115.204.150.34","geoPoint":{"lon":120.1619,"lat":30.294}}'); INSERT INTO batchtest (id, name, author, content, title, optime, oper, subtitle, collecttime, ipinfo) VALUES (269397, '认证管理', 'duoduo', 'admin(系统管理员) 登陆[公共开发平台]', '解放', '2016-11-02 21:18:31', 'admin', '小康', '2020-05-07 23:14:28', '{"country":"中国","countryId":"CN","area":"","areaId":"","region":"浙江省","regionId":"ZJ","city":"杭州","cityId":"","county":"浙江省","countyId":"ZJ","isp":"Chinanet","ispId":4134,"ip":"115.204.150.34","geoPoint":{"lon":120.1619,"lat":30.294}}');