# PanguSync

**Repository Path**: harrydeep/pangu-sync

## Basic Information

- **Project Name**: PanguSync
- **Description**: 数据库实时同步,数据库热备,数据库增量同步,支持Mysql、Sqlserver双向同步,一款超一流的数据库同步工具
- **Primary Language**: C#
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 4
- **Created**: 2024-10-16
- **Last Updated**: 2024-10-16

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

### 🏭 企业级数据库同步低成本接地气方案【在增量同步领域，易用性、容错性、稳定性吊打各类三方工具，无需binlog/CDC也能轻松玩转Mysql/Sqlserver双主、一主多从】
### 💦 酣畅淋漓的同步体验，极易上瘾
1. 微信仅做交易和解答付费客户的问题
2. 支持Sqlserver和Mysql，满足以下条件者可轻松部署：

| 表拥有主键  | Insert语句指定字段  | 触发器不更新自身表字段值  |
|---|---|---|
|  ✔️ |  ✔️ |  ✔️  |

3. 购买时提供[**硬件序列号**] ，收到cc2.license文件后，替换试用版该文件即可
4. 不提供部署，如果确实需要远程支持，额外收取人工费5000元



|  |试用版|  体验版|  专业版 | 企业版  | 至尊版 |
|---|---|---|---|---|---|
|原价|免费| ~~￥200~~| ~~￥500~~ |  ~~￥2000~~|  ~~￥3000~~|
|优惠价(开发票)<br>[发票样例](https://pan.baidu.com/s/1U7jMJv-76q36T6diGwAVug?pwd=abcd#list/path=%2F)💥| 免费  | ❌ | ￥650<br>[[**购买**]](https://item.taobao.com/item.htm?ft=t&id=844161694427) |￥1000<br>[[**购买**]](https://item.taobao.com/item.htm?ft=t&id=843656590840) |￥1200<br>[[**购买**]](https://item.taobao.com/item.htm?ft=t&id=843658126546)  |
|优惠价(不开票)🌟|免费| ￥100<br>[**[购买]**](https://item.taobao.com/item.htm?ft=t&id=802638471181)| ￥400<br>[**[购买]**](https://item.taobao.com/item.htm?ft=t&id=754824495442)|  ￥640<br>[**[购买]**](https://item.taobao.com/item.htm?id=761877111372)|  ￥768<br> [**[购买]**](https://item.taobao.com/item.htm?ft=t&id=767418824294) |
|授权期限| 2h/次（次数不限） | 终生 &nbsp;&nbsp;&nbsp;&nbsp;   | 终生 &nbsp;&nbsp;&nbsp;&nbsp;  | 终生 &nbsp;&nbsp;&nbsp;&nbsp; | 终生 &nbsp;&nbsp;&nbsp;&nbsp; | 
| **任务数量** | 5| 50| 500  |  2000 | 不限|
|授权数量| 不限| 1台   | 1台  | 1台 |1台 |






|Edition|Enterprise |Supreme|
|---|---|---|
|Price|  USD 150| USD 180|
|Authorization time|Limitless|Limitless|
|Authorized quantity|1|1|
|Number of tasks|  2000 tasks | Limitless|
|Provide|Hardware ID |Hardware ID |
|Payment method|[Paypal](https://paypal.me/hotstandby) | [Paypal](https://paypal.me/hotstandby)  |
|How to activate|Replace cc2.license|Replace cc2.license|
- Send Hardware ID and payment evidence to email【435031783@qq.com】

##    💥   轻松拿捏亿级大数据量下的增量热备（Easily handle incremental hot backup under billion level big data volume）: https://www.bilibili.com/video/BV1yb8zeHEmx/?vd_source=8db0f4c511ee648e595718cb636c8df7

###  🌟 某大型医院云胶片热备案例（Case study of cloud film hot preparation in a large hospital）: https://www.bilibili.com/video/BV14x4y167A2/?spm_id_from=333.999.0.0&vd_source=8db0f4c511ee648e595718cb636c8df7 








# PanguSync





![输入图片说明](%E4%BB%BB%E5%8A%A1%E4%B8%BB%E7%95%8C%E9%9D%A2.png)




###    🌵  1. 简介

PanguSync是双机热备软件[**PanguHA**](https://gitee.com/AaronE_2890620459/pangu-ha)的一个子模块，它是一款功能强大的数据库增量同步软件【增量指的是增量变化，即insert、update、delete】，提供了数据热备的功能，从而保证业务系统数据安全。它能够将一个正在运行的数据系统中的数据准实时的同步到另外的一个或者多个数据库上， 在这个过程中保证数据的完整性、正确性和一致性。
####   Introduction
PanguSync is a submodule of the dual machine hot backup software [**PanguHA**](https://gitee.com/AaronE_2890620459/pangu-ha). It is a powerful database incremental synchronization software that provides data hot backup functionality to ensure the security of business system data. It can synchronize data from a running data system to one or more other databases in near real time, ensuring the integrity, correctness, and consistency of the data during this process.


 



###      🔯    2. 同步模式（Sync Mode）
| A->B |A<=>B |A->B，A->C |  A->B->C  | A->B->C->A | A<=>B<=>C|
|---|---|---|---|---|---|
|✔️  | ✔️ |  ✔️|    ❌ | ❌ |❌|
|A写|A或B写|A写|/|/|/|

- A<=>B模式一般不要双写，仅做热备切换或一写多读。
- 双写需满足【不更新复合主键值】【没有自增主键】，否则极限情况下，双写同一条数据会逻辑矛盾。


A<=>B mode generally does not allow dual writing, only performs hot standby switching or one write multiple reads. If there is no self added ID, it can be double written.


 

###    📺  3. 视频（Video）
- [操作教程（Operation tutorial）](https://www.bilibili.com/video/BV1VC411h7ph/?vd_source=8db0f4c511ee648e595718cb636c8df7) 
- [某大型医院云胶片热备案例（Hot standby case in a large hospital）](https://www.bilibili.com/video/BV14x4y167A2/?spm_id_from=333.999.0.0&vd_source=8db0f4c511ee648e595718cb636c8df7)
- [亿级数据下的增量热备测试（Incremental hot standby test under billion level data）](https://www.bilibili.com/video/BV1yb8zeHEmx/?vd_source=8db0f4c511ee648e595718cb636c8df7)


###   📢  4. 注意事项
- 操作系统: **Windows7 SP1** 及以上、**Windows Server 2008R2 SP1** 及以上
- 环境: **.NET Framework 4.6.1** 及以上
- 点击 **DBSync.exe** 运行
- 配置双向同步时，IP需要互相对应
- 选库不选表可批量生成任务
-  🔴  **当源和目标新增、修改、删除相同字段时，软件将自动更新配置，无需手动编辑保存运行** 


#### matters needing attention
- OS: Windows 7 SP1 and above, Windows Server 2008 R2 SP1 and above
- Platform: x86/x64
- Environment: NET Framework 4.6.1 and above
- Click DBSync.exe to run
- When configuring bidirectional sync, IPs need to correspond to each other
- Batch generation of tasks can be achieved by selecting a database instead of a table
- 🔴 When the source and target add, modify, or delete the same field, the software will automatically update the configuration without the need for manual editing, saving, and running



###    🍇  5. 大数据量初始化超时
初次部署如果数据量较大，比如有上亿的初始数据，如果初始化超时请配置全局参数【初始化超时】或执行以下脚本：https://blog.csdn.net/sss899000/article/details/138615017


#### Initialization scheme for large data volume
If the initial deployment involves a large amount of data, such as billions of initial data, and the init timeout occurs, please configure the global parameter 'Init Timeout' or execute the following script: https://blog.csdn.net/sss899000/article/details/138615017





###   💪   6. 核心优势
-  🚀 可根据库批量生成表任务，方便快捷
-  📈 采用增量同步的方式
-  🔌 支持Mysql→Sqlserver、Mysql→Mysql、Sqlserver→Sqlserver、Sqlserver→Mysql
-  ♋️  支持双向同步，可用于高可用热备场景
-  👑 允许主键值(包括复合主键值)的修改同步
-  👠 自动解决自增主键冲突 
-  🔑 自动解决唯一索引和唯一键冲突【同类型数据库】 
-  🔒 自动解决外键约束冲突【父子表都需要配置任务】
-  〰️  支持断点续传
-  ♓️  自动映射源和目标的字段变更【同类型数据库】
-  ☕️ 配置简单，只需懂数据库基操


####  Core advantages
-  It can generate table tasks in batches based on the database, which is convenient and fast
-  Adopting incremental synchronization method
-  Supports Mysql->Sqlserver、Mysql->Mysql、Sqlserver->Sqlserver、Sqlserver->Mysql
-  Supports bidirectional synchronization and can be used in high availability and multi active scenarios
-  Allow synchronous modification of primary key values【including composite primary key values】
-  Automatically resolve self increasing primary key conflicts
-  Automatically resolve conflicts between unique indexes and unique keys【same type database】
-  Automatically resolve foreign key constraint conflicts【Both parent and child tables require configuration tasks】
-  Supports breakpoint resume
-  Automatically map field changes for source and target【same type database】
-  Simple configuration, only need to understand database basic operations


###    📐  7. 测试版本
- Mariadb 10.2.38、Mysql5.6.4、Mysql 5.7.44、Mysql 8.0.16
- Sqlserver 2008R2及以上

#### Tested version
- Mariadb 10.2.38、Mysql5.6.4、Mysql 5.7.44、Mysql 8.0.16
- SQL Server 2008R2 and above

###  ㊙️ 8. 关于开机自启动
- 将软件设置为快捷方式，然后Win+R输入shell:startup，将快捷方式拖入该目录
- 付费版可以自动运行任务，在Config文件夹下面添加一个AutoStart.txt文件即可

#### Regarding self starting during startup
- Set the software as a shortcut, then enter 'shell: startup' in Win+R and drag the shortcut into that directory
- The paid version can automatically run tasks. Simply add an 'AutoStart.txt' file to the Config folder