Skip to content
Navigation Menu
Sign in
Appearance settings
Platform
AI CODE CREATION
GitHub Copilot
Write better code with AI
GitHub Copilot app
Direct agents from issue to merge
MCP Registry
Integrate external tools
DEVELOPER WORKFLOWS
Actions
Automate any workflow
Codespaces
Instant dev environments
Issues
Plan and track work
Code Review
Manage code changes
Code Quality
Enforce quality at merge
APPLICATION SECURITY
GitHub Advanced Security
Find and fix vulnerabilities
Code security
Secure your code as you build
Secret protection
Stop leaks before they start
EXPLORE
Why GitHub
Documentation
Blog
Changelog
Marketplace
View all features
Solutions
BY COMPANY SIZE
Enterprises
Small and medium teams
Startups
Nonprofits
BY USE CASE
App Modernization
DevSecOps
DevOps
CI/CD
View all use cases
BY INDUSTRY
Healthcare
Financial services
Manufacturing
Government
View all industries
View all solutions
Resources
EXPLORE BY TOPIC
AI
Software Development
DevOps
Security
View all topics
EXPLORE BY TYPE
Customer stories
Events & webinars
Ebooks & reports
Business insights
GitHub Skills
SUPPORT & SERVICES
Documentation
Customer support
Community forum
Trust center
Partners
View all resources
Open Source
COMMUNITY
GitHub Sponsors
Fund open source developers
PROGRAMS
Security Lab
Maintainer Community
GitHub Stars
Archive Program
REPOSITORIES
Topics
Trending
Collections
Enterprise
ENTERPRISE SOLUTIONS
Enterprise platform
AI-powered developer platform
AVAILABLE ADD-ONS
GitHub Advanced Security
Enterprise-grade security features
Copilot for Business
Enterprise-grade AI features
Premium Support
Enterprise-grade 24/7 support
Pricing
Search
/
Sign in
Sign up
Appearance settings
You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.
You switched accounts on another tab or window.
Reload
to refresh your session.
Dismiss alert
{{ message }}
alibaba
/
otter
Public
Notifications
You must be signed in to change notification settings
Fork
2.5k
Star
8.1k
Code
Issues
319
Pull requests
15
Actions
Projects
Wiki
Security and quality
0
Insights
Additional navigation options
Code
Issues
Pull requests
Actions
Projects
Wiki
Security and quality
Insights
Otter双向回环控制
Jump to bottom
agapple edited this page
Aug 17, 2013
·
1 revision
基本需求
支持mysql/oracle的异构数据库的双向回环,早期有变态需求:杭州是mysql,美国是oracle,需要做双向同步。
需要支持级联同步,比如A<->B->C,A同步到B的数据,不能从B回到A,但需要同步到C
实现思路
利用事务机制,在事务头和尾中插入otter同步标识
解析时识别同步标识,判断是否需要屏蔽同步
几点注意:
基于标准SQL实现
可以支持mysql/oracle等异构数据库的双向同步
事务完整解析&完整可见性
事务被拆开同步,会出现部分回环同步,数据不一致. 比如一个事务被拆分为了3截,中间一截因为没有事务头和尾的标识,如果发生同步了,就会导致数据不一致.
实现示意图
Wiki pages
Pages
23
Loading
Home
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
Adminguide
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
Docker_QuickStart
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
Faq
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
Introduction
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
Manager_InitSql
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
Manager_Quickstart
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
Manager使用介绍
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
Manager配置介绍
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
Node_Quickstart
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
Otter双向回环控制
基本需求
实现思路
实现示意图
Loading
Otter扩展性
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
Otter数据一致性
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
Otter数据入库算法
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
Otter调度模型
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
Otter高可用性
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
QuickStart
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
windows_QuickStart
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
映射规则配置
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
用户捐赠
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
相关PPT&PDF
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
相关ppt&pdf
Uh oh!
There was an error while loading.
Please reload this page
.
Loading
网友贡献
Uh oh!
There was an error while loading.
Please reload this page
.
Show 8 more pages…
Table of Contents
Home
Introduction
Otter调度模型
Otter数据入库算法
Otter双向回环控制
Otter数据一致性
Otter高可用性
Otter扩展性
QuickStart
Docker_QuickStart
Manager_QuickStart
Node_QuickStart
AdminGuide
Manager使用介绍
Manager配置介绍
映射规则配置
相关PPT&PDF
网友贡献
FAQ
Clone this wiki locally
You can’t perform that action at this time.