CN106250514B - 基于Mysql数据库和SQL日志的跨国数据同步方法 - Google Patents
基于Mysql数据库和SQL日志的跨国数据同步方法 Download PDFInfo
- Publication number
- CN106250514B CN106250514B CN201610630962.4A CN201610630962A CN106250514B CN 106250514 B CN106250514 B CN 106250514B CN 201610630962 A CN201610630962 A CN 201610630962A CN 106250514 B CN106250514 B CN 106250514B
- Authority
- CN
- China
- Prior art keywords
- log
- database
- sql
- node
- transnational
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 61
- 230000008569 process Effects 0.000 claims abstract description 32
- 230000001360 synchronised effect Effects 0.000 claims abstract description 23
- 239000000284 extract Substances 0.000 claims abstract description 6
- 238000012544 monitoring process Methods 0.000 claims description 5
- 238000012423 maintenance Methods 0.000 claims description 4
- 238000013461 design Methods 0.000 claims description 3
- 238000000605 extraction Methods 0.000 claims description 3
- 230000007257 malfunction Effects 0.000 claims description 3
- 230000006641 stabilisation Effects 0.000 abstract description 3
- 238000011105 stabilization Methods 0.000 abstract description 3
- 230000008439 repair process Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000011084 recovery Methods 0.000 description 2
- 230000003796 beauty Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000007613 environmental effect Effects 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 239000000126 substance Substances 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/275—Synchronous replication
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/273—Asynchronous replication or reconciliation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Debugging And Monitoring (AREA)
Abstract
Description
Claims (6)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610630962.4A CN106250514B (zh) | 2016-08-04 | 2016-08-04 | 基于Mysql数据库和SQL日志的跨国数据同步方法 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610630962.4A CN106250514B (zh) | 2016-08-04 | 2016-08-04 | 基于Mysql数据库和SQL日志的跨国数据同步方法 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN106250514A CN106250514A (zh) | 2016-12-21 |
CN106250514B true CN106250514B (zh) | 2019-10-15 |
Family
ID=58077412
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610630962.4A Active CN106250514B (zh) | 2016-08-04 | 2016-08-04 | 基于Mysql数据库和SQL日志的跨国数据同步方法 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106250514B (zh) |
Families Citing this family (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107423452A (zh) * | 2017-09-02 | 2017-12-01 | 国网辽宁省电力有限公司 | 一种电网异构数据库同步复制迁移方法 |
CN107590256A (zh) * | 2017-09-20 | 2018-01-16 | 北京九桥同步软件有限公司 | 异构数据库同步方法和装置 |
CN108664609B (zh) * | 2018-05-10 | 2021-04-30 | 中国银行股份有限公司 | 一种数据共享的方法、网络设备及终端 |
CN108984660A (zh) * | 2018-06-28 | 2018-12-11 | 中译语通科技股份有限公司 | 一种MySQL数据库主从同步数据去重方法 |
CN109271448A (zh) * | 2018-09-25 | 2019-01-25 | 武汉达梦数据库有限公司 | 基于数据库为平台的数据同步***及方法 |
CN109753511B (zh) * | 2018-12-28 | 2020-12-04 | 北京东方国信科技股份有限公司 | 一种大数据平台的跨地域实时同步方法及*** |
CN110659256B (zh) * | 2019-09-30 | 2021-02-26 | 掌阅科技股份有限公司 | 多机房同步方法、计算设备及计算机存储介质 |
CN110851528B (zh) * | 2019-10-09 | 2022-09-02 | 网联清算有限公司 | 数据库同步方法、装置、存储介质及计算机设备 |
CN115794941A (zh) * | 2022-10-10 | 2023-03-14 | 上海商米科技集团股份有限公司 | 跨区域的数据同步方法、***及计算机可读介质 |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104252505A (zh) * | 2013-06-29 | 2014-12-31 | 北京新媒传信科技有限公司 | 数据库管理平台中数据库实例的同步方法和装置 |
CN105446825A (zh) * | 2014-06-12 | 2016-03-30 | 阿里巴巴集团控股有限公司 | 数据库测试方法及装置 |
-
2016
- 2016-08-04 CN CN201610630962.4A patent/CN106250514B/zh active Active
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104252505A (zh) * | 2013-06-29 | 2014-12-31 | 北京新媒传信科技有限公司 | 数据库管理平台中数据库实例的同步方法和装置 |
CN105446825A (zh) * | 2014-06-12 | 2016-03-30 | 阿里巴巴集团控股有限公司 | 数据库测试方法及装置 |
Also Published As
Publication number | Publication date |
---|---|
CN106250514A (zh) | 2016-12-21 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106250514B (zh) | 基于Mysql数据库和SQL日志的跨国数据同步方法 | |
US11947438B2 (en) | Operation and maintenance system and method | |
CN109379251B (zh) | 继电保护装置过程层goose及sv通信自动测试方法及*** | |
CN104022903A (zh) | 一站式自动化运维*** | |
WO2018126964A1 (zh) | 任务执行方法、装置和服务器 | |
CN109634970B (zh) | 表数据同步方法、设备、存储介质及装置 | |
CN105915381B (zh) | 一种实现监控***业务逻辑在线修改*** | |
CN108459951B (zh) | 测试方法和装置 | |
CN103067230A (zh) | 一种通过植入监控代码实现对http服务监控的方法 | |
CN114327678B (zh) | 一种支持多引擎的实时数据处理***及方法 | |
CN102014016A (zh) | 一种网络协议缺陷测试***及方法 | |
CN113973053B (zh) | 一种网络靶场的探针管理***与方法 | |
CN112804093B (zh) | 一种基于故障能力中心的集中调度支撑方法和*** | |
CN107577780A (zh) | 一种数据中心云资源同步方法和装置 | |
CN110334326A (zh) | 一种识别配方文件并转化为xml文件的方法及*** | |
WO2019223178A1 (zh) | 跨平台任务调度方法、***、计算机设备和存储介质 | |
CN110019203A (zh) | 一种基于知识库的服务器自动巡检***与方法 | |
CN111181775B (zh) | 基于自动发现主机资产的一体化运维管理告警方法 | |
CN111913933A (zh) | 基于统一支撑平台的电网历史数据管理方法及*** | |
CN113946559A (zh) | 数据处理方法、目标数据库***及数据处理*** | |
CN114172921A (zh) | 一种调度录音***的日志审计方法及装置 | |
CN112565232B (zh) | 一种基于模板和流量状态的日志解析方法及*** | |
CN111817865A (zh) | 一种监控网管设备的方法及监控*** | |
CN110445752A (zh) | 一种支持多种can设备并灵活解析各类can报文的实现方法 | |
CN114124859B (zh) | 一种网络维护平台智能客户服务机器人及维护方法 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20190108 Address after: 200233 Block A, Room 501, 12 Block 1001 Qinzhou North Road, Xuhui District, Shanghai Applicant after: Shanghai Moku Data Technology Co.,Ltd. Address before: Room 6020, 6th floor, No. 399 Fute North Road, Pudong New Area Free Trade Pilot Area, Shanghai, 2001 Applicant before: MOLBASE (SHANGHAI) BIOTECHNOLOGY CO.,LTD. |
|
TA01 | Transfer of patent application right | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
TR01 | Transfer of patent right |
Effective date of registration: 20240308 Address after: Unit 901-2, No. 57 Chengyi North Street, Software Park Phase III, Jimei District, Xiamen City, Fujian Province, 361000 Patentee after: Xiamen Baoyi Intelligent Technology Co.,Ltd. Country or region after: China Address before: 200233 Block A, Room 501, 12 Block 1001 Qinzhou North Road, Xuhui District, Shanghai Patentee before: Shanghai Moku Data Technology Co.,Ltd. Country or region before: China |
|
TR01 | Transfer of patent right |