由于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