flinksql cdc mysql 的 jar 包

最新推荐文章于 2024-06-16 20:55:17 发布

阿斗还能扶

最新推荐文章于 2024-06-16 20:55:17 发布

阅读量174

点赞数

文章标签： mysql android 数据库

本文链接：https://blog.csdn.net/qq_59127145/article/details/132646524

版权

由于flink cdc mysql 没有发现现成的 jar包，需要自己打包
StreamExecutionEnvironment env = StreamExecutionEnvironment.getExecutionEnvironment();
TableEnvironment tableEnv = TableEnvironment.create(new Configuration());
StreamTableEnvironment streamTableEnv = StreamTableEnvironment.create(env);
streamTableEnv.executeSql("CREATE TABLE t1 (\n" +
        "     id BIGINT,\n" +
        "     name STRING,\n" +
        "     PRIMARY KEY (id) NOT ENFORCED\n" +
        "   ) WITH (\n" +
        "     'connector' = 'mysql-cdc',\n" +
        "     'scan.startup.mode' = 'latest-offset',\n" +
        "     'hostname' = 'localhost',\n" +
        "     'port' = '3307',\n" +
        "     'username' = 'root',\n" +
        "     'password' = 'mysql',\n" +
        "     'database-name' = 'mysql8',\n" +
        "     'table-name' = 'admit'\n" +
        "   );");
streamTableEnv.executeSql("select * from t1").print();

两个注意点，必须设置binlog格式为 ROW 必须指定主键

jar包百度云：

链接：https://pan.baidu.com/s/1-WdwJU_kZhnrRVFHJlZrBg?pwd=6666
提取码：6666