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.

Sign up for GitHub

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

Jump to bottom

consistency when executing update #2

Closed
tangdi opened this issue Jan 26, 2016 · 3 comments
Closed

consistency when executing update #2

tangdi opened this issue Jan 26, 2016 · 3 comments
Labels
type: discussion

Comments

@tangdi
Copy link

tangdi commented Jan 26, 2016

Hi:
In Sharding-jdbc PreparedStatementExecutor will execute RoutedPreparedStatement list concurrently. Do you have any mechanism to ensure the consistency between multiple datasources when executing updates? It seems to me that if the connection is set auto-commit, one datasource' failure will not rollback other datasources' execution and therefore the overall consistency is not guaranteed. Do we have to use manual commit when using sharding-jdbc to do update operation?
@terrymanu
Copy link
Member

目前事务只是可用，还没有做跨数据库的事务原子性。我们未来会基于BASE做最终一致性的柔性事务。有什么建议都可以提，多谢

@ivywjhua
Copy link

ivywjhua commented Feb 1, 2016

基于BASE做最终一致性的柔性事务? 这个和Notify之类的有什么区别？
可以给个参考链接研究一下么？ @terrymanu

@terrymanu
Copy link
Member

想法还未完全成型。柔性事务可以网上搜下。不过最终我们不一定采用什么方案。等做的时候可以详细讨论

terrymanu pushed a commit that referenced this issue Apr 12, 2018
@maxiaoguang64
Merge pull request #2 from shardingjdbc/dev
97897e7 
merge from sharding jdbc
terrymanu pushed a commit that referenced this issue May 2, 2018
@qiankunshe
Merge pull request #2 from shardingjdbc/dev
b7819b9 
合并最新代码
terrymanu pushed a commit that referenced this issue May 21, 2018
@beckhampu
Merge pull request #2 from sharding-sphere/dev
2551a68 
update from origin
terrymanu pushed a commit that referenced this issue Sep 2, 2018
@maxiaoguang64
Merge pull request #2 from sharding-sphere/dev
267525e 
merge from ss
terrymanu pushed a commit that referenced this issue Sep 21, 2018
@KomachiSion
Merge pull request #2 from sharding-sphere/dev
35f3e56 
merge for fork from origin
terrymanu pushed a commit that referenced this issue Mar 25, 2019
@betterjava
Merge pull request #2 from apache/dev
5f16172 
just async
@kagowu kagowu mentioned this issue Mar 28, 2019
Closed
terrymanu pushed a commit that referenced this issue Jun 10, 2019
@zhouchangjiang
Merge pull request #2 from apache/dev
1166807 
update
tristaZero pushed a commit that referenced this issue Jun 19, 2019
@wgy8283335
Merge pull request #2 from apache/dev
21db13d 
local merge
tristaZero pushed a commit that referenced this issue Sep 9, 2019
@xiyelife
Merge pull request #2 from apache/dev
fdcfdfe 
sync from apache
wgy8283335 added a commit that referenced this issue Nov 25, 2019
@wgy8283335
Merge pull request #2 from apache/orchestration-5.x
ce3199e 
add sharding-orchestration-center module in Orchestration 5.x (#3468)
@Jaskey Jaskey mentioned this issue Mar 13, 2020
Closed
kimmking pushed a commit that referenced this issue Apr 17, 2020
@LeeGuoPing
Merge pull request #2 from apache/master
41511c0 
pull from remote
tristaZero pushed a commit that referenced this issue Sep 6, 2020
@291277058
Merge pull request #2 from apache/master
f1b21b3 
sync
@sunOnly sunOnly mentioned this issue Oct 13, 2020
Closed
@dbzzzzz dbzzzzz mentioned this issue May 31, 2021
Closed
hubao-1125 referenced this issue in hubao-1125/shardingsphere Dec 15, 2021
@hubao-1125
Merge pull request #2 from apache/master
0ccd2a6 
syn pro
xuup added a commit to xuup/shardingsphere that referenced this issue Jul 19, 2022
@xuup
Merge pull request apache#2 from apache/master
d4c904c 
update
tianhao960 added a commit to tianhao960/shardingsphere that referenced this issue Aug 19, 2022
@tianhao960
add createProcedure rule for oracle apache#2
a05009a
tuichenchuxin pushed a commit that referenced this issue Aug 23, 2022
@tianhao960
add createProcedure rule for oracle (#20422)
2ab3a7a 
* add createProcedure rule for oracle #1

* add createProcedure rule for oracle #2

* add createProcedure rule for oracle #3

* add createProcedure rule for oracle #4

* add createProcedure rule for oracle #5

* add createProcedure rule for oracle #6

* add createProcedure rule for oracle #6

* add createProcedure rule for oracle #7
strongduanmu pushed a commit that referenced this issue Aug 24, 2022
@tianhao960
add alter and drop procedure statement for oracle (#20463)
15ee3e3 
* add createProcedure rule for oracle #1

* add createProcedure rule for oracle #2

* add createProcedure rule for oracle #3

* add createProcedure rule for oracle #4

* add createProcedure rule for oracle #5

* add createProcedure rule for oracle #6

* add createProcedure rule for oracle #6

* add createProcedure rule for oracle #7

* add dropProcedure and alterProcedure rule for oracle

* add javadoc and final for ProcedureStatement
tianhao960 added a commit to tianhao960/shardingsphere that referenced this issue Sep 1, 2022
@tianhao960
add visitor for json function, add unit test apache#2
a2f1807
strongduanmu pushed a commit that referenced this issue Sep 1, 2022
@tianhao960
add json function support to mysql parser (#20709)
2919c2f 
* add json function support to mysql parser #1

* add visitor for json function, add unit test #2
tianhao960 added a commit to tianhao960/shardingsphere that referenced this issue Sep 9, 2022
@tianhao960
refactor parallel test framework apache#2
d869598
terrymanu pushed a commit that referenced this issue Sep 14, 2022
@tianhao960
refactor parallel executor framework for junit (#20910)
541a528 
* add support for test parallel run

* refactor parallel test framework #2

* refactor parallel test framework #3

* refactor parallel test framework #4

* refactor parallel test framework #5

* refactor parallel test framework #7
tianhao960 added a commit to tianhao960/shardingsphere that referenced this issue Sep 26, 2022
@tianhao960
add support of ALTER RESOURCE COST apache#2
dde8213
strongduanmu pushed a commit that referenced this issue Sep 26, 2022
@tianhao960
add support of ALTER RESOURCE COST for Oracle (#21185)
b2d181a 
* add support of ALTER RESOURCE COST

* add support of ALTER RESOURCE COST #2

* add support of ALTER RESOURCE COST #3

* add support of ALTER RESOURCE COST for Oracle #4
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
type: discussion
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@ivywjhua @terrymanu @tangdi