基于canal实现MySQL作为主库的ES与MySQL数据同步

以下是一个简化版的示例代码，展示了如何使用Canal来同步MySQL数据到Elasticsearch。

import com.alibaba.otter.canal.client.CanalConnector;
import com.alibaba.otter.canal.client.CanalConnectors;
import com.alibaba.otter.canal.protocol.Message;
import com.alibaba.otter.canal.protocol.CanalEntry;
import org.elasticsearch.action.index.IndexRequest;
import org.elasticsearch.client.RequestOptions;
import org.elasticsearch.client.RestHighLevelClient;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
 
public class MySQL2ESSync {
 
    private static final Logger logger = LoggerFactory.getLogger(MySQL2ESSync.class);
 
    public static void main(String args[]) {
        // 连接Canal服务
        CanalConnector connector = CanalConnectors.newSingleConnector(
                new InetSocketAddress(AddressUtils.getHostIp(),
                11111), "example", "", "");
 
        // 连接Elasticsearch客户端
        RestHighLevelClient client = new RestHighLevelClient(...);
 
        try {
            connector.connect();
            connector.subscribe(".*\\..*");
            connector.rollback();
            while (true) {
                Message message = connector.getWithoutAck(1024); // 获取指定数量的数据
                long batchId = message.getId();
                if (batchId == -1 || message.getEntries().isEmpty()) {
                    Thread.sleep(1000);
                } else {
                    dataHandler(message, client);
                    connector.ack(batchId); // 确认消息消费成功
                }
            }
        } catch (Exception e) {
            logger.error("同步数据出错", e);
        } finally {
            try {
                if (connector != null) {
                    connector.disconnect();
                }
                if (client != null) {
                    client.close();
                }
            } catch (Exception e) {
                logger.error("关闭连接出错", e);
            }
        }
    }
 
    private static void dataHandler(Message message, RestHighLevelClient client) throws Exception {
        for (CanalEntry.Entry entry : message.getEntries()) {
            if (entry.getEntryType() == CanalEntry.EntryType.ROWDATA) {
                CanalEntry.RowCha