实时计算 Flink版产品使用合集之如何实现MySQL单表数据同步到多个表

-- 创建MySQL源表
CREATE TABLE mysql_source (
    id INT,
    name STRING,
    -- 其他字段...
) WITH (
    'connector' = 'mysql-cdc',
    'hostname' = 'your_mysql_host',
    'port' = '3306',
    'username' = 'your_username',
    'password' = 'your_password',
    'database-name' = 'your_database',
    'table-name' = 'your_source_table'
);
-- 创建第一个目标表
CREATE TABLE target_table1 (
    id INT,
    name STRING,
    -- 其他字段...
) WITH (
    'connector' = 'jdbc',  -- 或其他适合你的sink连接器
    'url' = 'jdbc:mysql://your_target_host:3306/your_target_database',
    'table-name' = 'target_table1',
    'username' = 'your_target_username',
    'password' = 'your_target_password'
);
-- 创建第二个目标表
CREATE TABLE target_table2 (
    id INT,
    name STRING,
    -- 其他字段...
) WITH (
    'connector' = 'jdbc',  -- 或其他适合你的sink连接器
    'url' = 'jdbc:mysql://your_target_host:3306/your_target_database',
    'table-name' = 'target_table2',
    'username' = 'your_target_username',
    'password' = 'your_target_password'
);
-- 将源数据流同步到两个目标表
INSERT INTO target_table1 SELECT * FROM mysql_source;
INSERT INTO target_table2 SELECT * FROM mysql_source;