Get the App
SLTechnology News&Howtos  ›  Database  › 

​ mysql Multi-source replication Skip error handling method

Shulou Source: shulou.com Published: 2022-06-01 07:02:09 11月01日 Update

Mysql multi-source replication skips error handling:

The first method: first stop all channel, then execute sql_slave_skip_counter, then open the error channel, and finally open all channel.

The second method: you can also directly stop the wrong channel, then sql_slave_skip_counter, and finally start the error chanel.

If it is in gtid mode, you can refer to this idea.

Tags: Methods faults multiple sources processing ideas patterns errors references Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Linux Shulou Technology OPPO Reno Docker Microsoft