tag:blogger.com,1999:blog-768233104244702633.post5488735872437270768..comments2023-11-16T03:16:54.746-08:00Comments on The Scale-Out Blog: Parallel Replication Using Shards Is the Only Workable Approach for SQLRobert Hodgeshttp://www.blogger.com/profile/05379726998057344092noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-768233104244702633.post-56734340697874871422011-03-23T07:25:36.643-07:002011-03-23T07:25:36.643-07:00RH> Updates in critical shards cause full seria...RH> Updates in critical shards cause full serialization across all shards.<br /><br />I'd like to emphasize this sentence and give it some weight, as it really means you need to <i>wait</i> for all the parallel threads to reach the seqno in the critical shard, block, commit in the critical shard and then resume. This flattens out the parallelization, thus needs to be avoided as much as architecture allows.Linas Virbalashttps://www.blogger.com/profile/05606598879200226659noreply@blogger.com