当事务再次执行查询,并发现一组结果自最后一次查询后由于另一个事务提交了新的数据而发生了更改,则会发生幻像读。
A phantom read occurs when a transaction re-executes a query and finds a set of results changed since the last query due to another transaction that committed new data.
由于只需复制被更改的数据,所以读事务不受 HADR 实现的影响。
Only data changes are required to be replicated, so read transaction are unaffected by the implementation of HADR.
添加清单10中的代码将数据读回并更改呈现的信息。
Add the code shown below in Listing 10 to read the data back in and change the presented information.
应用推荐