Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

新生命工具数据同步 #22

Open
Fat-Snail opened this issue Jan 22, 2024 · 1 comment
Open

新生命工具数据同步 #22

Fat-Snail opened this issue Jan 22, 2024 · 1 comment
Labels
enhancement New feature or request

Comments

@Fat-Snail
Copy link
Contributor

1、需要自增键(Identity)同步到备份库,现解决方案是把需要同步的table的Identity值设为false,然后备份库就只有主键而没有自增键,当然,这个功能可有可无,只不过考虑到备份库以后可以切换到主库

2、同步窗台,需要反馈已同步到条数和百分比,不然点击同步按钮后,都不知道同步到什么表,还剩多少未同步完。这个功能也非常简单,在我写的工具已经实现了,但是 OnPage的事件返回的Row数量上有点出入,不知道什么bug

3、分表的同步估计不能使用现有的同步逻辑,具体还没想到什么好的方法,分表的展示应该就是一个,不然有256个表,看起来就有点多

4、同步应该支持自定义,有些表变化比较多,有些表可能一个月都很少数据变化。所以同步更及时应该要区分表的实际状况

@Fat-Snail
Copy link
Contributor Author

5、还有开始同步时,可以多线程同步,这个已经在我的工具实现,主要是把要同步的表加入队列,然后使用TimerX进行多表同步,这样速度上就更优了

@nnhy nnhy added the enhancement New feature or request label Mar 5, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants