`DROP TABLE ABC`,则至少需要填入`DROP TABLE`. 16. # skip-sqls = ["ALTER USER", "CREATE USER"] 17. 18. ## 在使用 route-rules 功能后， 19. ## replicate-do-db & replicate-ignore-db 匹配合表之后(target-schema & target-table )数值 20 60. #[[route-rules]] 61. #pattern-schema = "route_*" 62. #pattern-table = "abc_*" 63. #target-schema = "route" 64. #target-table = "abc" 65. 66. #[[route-rules]] 67. #pattern-schema = "route_*" 68. #pattern-table #pattern-table = "xyz_*" 69. #target-schema = "route" 70. #target-table = "xyz" 71. 72. [from] 73. host = "127.0.0.1" 74. user = "root" 75. password = "" 76. port = 3306 77. 78. [to] 79. host = "127

"mysql-01" # ID of the data �→ source, which is source-id in source1.yaml 230 route-rules: ["sale-route-rule"] # Table route rules �→ applied to the data source filter-rules: ["store-filter-rule", "sale-filter-rule"] "log-bak-ignored" # Block & Allow Lists �→ rules applied to the data source - source-id: "mysql-02" route-rules: ["sale-route-rule"] filter-rules: ["store-filter-rule", "sale-filter-rule"] block-allow-list: "log-bak-ignored" tables, in order to support merging different sharded �→ tables into a single target table. sale-route-rule: # Rule name. Migrate and merge tables from �→ upstream to the downstream. schema-pattern:

source-id: "mysql-01" # ID of the data �→ source, which is source-id in source1.yaml route-rules: ["sale-route-rule"] # Table route rules �→ applied to the data source filter-rules: ["store-filter-rule", "sale-filter-rule"] "log-bak-ignored" # Block & Allow Lists �→ rules applied to the data source - source-id: "mysql-02" route-rules: ["sale-route-rule"] filter-rules: ["store-filter-rule", "sale-filter-rule"] block-allow-list: "log-bak-ignored" tables, in order to support merging different sharded �→ tables into a single target table. sale-route-rule: # Rule name. Migrate and merge tables from �→ upstream to the downstream. schema-pattern:

mysql-instances: - source-id: "mysql-01" # 数据源 ID，即 source1.yaml 中的 �→ source-id route-rules: ["sale-route-rule"] # 应用于该数据源的 table route 规则 filter-rules: ["store-filter-rule", "sale-filter-rule"] # 应用于该数据源的 binlog source-id: "mysql-02" route-rules: ["sale-route-rule"] filter-rules: ["store-filter-rule", "sale-filter-rule"] block-allow-list: "log-bak-ignored" ### 分表合并配置 routes: sale-route-rule: schema-pattern: rule。以示例如何避免实例1的 my_db2 被同步。 bw-rule-2: do-dbs: ["my_db2"] routes: # 上游和下游表之间的路由 table routing 规则集 route-rule-1: # 配置名称。将 my_db1 中的 table1 和 table2 合并导入下游 my �→ _db.table5 schema-pattern: "my_db1" # 库名匹配规则，支持通配符

merge these codes with route information, highlighting airlines and destinations that align with user’s preferences. Prepare data First, create a table to store airport route data: ##### Create a table AUTO_INCREMENT PRIMARY KEY, airport_code VARCHAR(10), airline_code VARCHAR(10), destination_code VARCHAR(10), route_details TEXT, duration TIME, frequency INT, airplane_type VARCHAR(50), price DECIMAL(10, 2), layover tidb_vector_client.execute( """INSERT INTO airplan_routes ( 521 airport_code, airline_code, destination_code, route_details, duration, frequency, airplane_type, price, layover ) VALUES ('JFK', 'DL', 'LAX', 'Non-stop

merge these codes with route information, highlighting airlines and destinations that align with user’s preferences. Prepare data First, create a table to store airport route data: ##### Create a table AUTO_INCREMENT PRIMARY KEY, airport_code VARCHAR(10), airline_code VARCHAR(10), destination_code VARCHAR(10), route_details TEXT, duration TIME, frequency INT, airplane_type VARCHAR(50), price DECIMAL(10, 2), layover tidb_vector_client.execute( """INSERT INTO airplan_routes ( 516 airport_code, airline_code, destination_code, route_details, duration, frequency, airplane_type, price, layover ) VALUES ('JFK', 'DL', 'LAX', 'Non-stop

source-id: "mysql-01" # ID of the data �→ source, which is source-id in source1.yaml route-rules: ["sale-route-rule"] # Table route rules �→ applied to the data source filter-rules: ["store-filter-rule", "sale-filter-rule"] "mysql-02" route-rules: ["sale-route-rule"] filter-rules: ["store-filter-rule", "sale-filter-rule"] block-allow-list: "log-bak-ignored" 737 ### Configurations for merging MySQL shards routes: sale-route-rule: downstream tables, in order to support merging different �→ sharded table into a single target table. route-rule-1: # Rule name. Migrate and merge table1 and �→ table2 from my_db1 to the downstream my_db.table5

source-id: "mysql-01" # ID of the data �→ source, which is source-id in source1.yaml route-rules: ["sale-route-rule"] # Table route rules �→ applied to the data source filter-rules: ["store-filter-rule", "sale-filter-rule"] "mysql-02" route-rules: ["sale-route-rule"] filter-rules: ["store-filter-rule", "sale-filter-rule"] block-allow-list: "log-bak-ignored" 745 ### Configurations for merging MySQL shards routes: sale-route-rule: downstream tables, in order to support merging different �→ sharded table into a single target table. route-rule-1: # Rule name. Migrate and merge table1 and �→ table2 from my_db1 to the downstream my_db.table5

mysql-instances: - source-id: "mysql-01" # 数据源 ID，即 source1.yaml 中的 �→ source-id route-rules: ["sale-route-rule"] # 应用于该数据源的 table route 规则 filter-rules: ["store-filter-rule", "sale-filter-rule"] # 应用于该数据源的 binlog source-id: "mysql-02" route-rules: ["sale-route-rule"] filter-rules: ["store-filter-rule", "sale-filter-rule"] block-allow-list: "log-bak-ignored" ### 分表合并配置 routes: sale-route-rule: schema-pattern: rule。以示例如何避免实例1的 my_db2 被同步。 bw-rule-2: do-dbs: ["my_db2"] routes: # 上游和下游表之间的路由 table routing 规则集 route-rule-1: # 配置名称。将 my_db1 中的 table1 和 table2 合并导入下游 my �→ _db.table5 schema-pattern: "my_db1" # 库名匹配规则，支持通配符

source-id: "mysql-01" # ID of the data �→ source, which is source-id in source1.yaml route-rules: ["sale-route-rule"] # Table route rules �→ applied to the data source filter-rules: ["store-filter-rule", "sale-filter-rule"] "mysql-02" route-rules: ["sale-route-rule"] filter-rules: ["store-filter-rule", "sale-filter-rule"] block-allow-list: "log-bak-ignored" 750 ### Configurations for merging MySQL shards routes: sale-route-rule: downstream tables, in order to support merging different �→ sharded table into a single target table. route-rule-1: # Rule name. Migrate and merge table1 and �→ table2 from my_db1 to the downstream my_db.table5