Shulou(Shulou.com)06/01 Report--

Oracle ADG has maximum protection mode to ensure database consistency, but we usually choose the maximum available mode for disaster recovery. So whether MySQL also has a maximum protection mode, let's see how it can be implemented.

MySQL financial level architecture, maximum protection mode implementation method.

1. One master and two standby units

2. Lossless semi-synchronization

3. Recommended version 5.7.2x

4. Core parameter setting

Rpl_semi_sync_master_wait_no_slave=ON

Rpl_semi_sync_master_timeout=1000000000000000000 # main library does not receive ACK and does not submit

Rpl_semi_sync_master_wait_point=AFTER_SYNC

Give yourself a little time to think every day, and there may be unexpected results.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.