This is an automated email from the ASF dual-hosted git repository. yiguolei pushed a commit to branch branch-1.2-lts in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-1.2-lts by this push: new f417fdb01d2 delete external table docs1.2 (#28355) f417fdb01d2 is described below commit f417fdb01d26103e8947033214ff0dd8a8c6280a Author: ZhenchaoXu <49646212+i...@users.noreply.github.com> AuthorDate: Wed Dec 13 20:01:16 2023 +0800 delete external table docs1.2 (#28355) --- docs/en/docs/ecosystem/mysql-to-doris.md | 105 --------------------------- docs/sidebars.json | 1 - docs/zh-CN/docs/ecosystem/mysql-to-doris.md | 108 ---------------------------- 3 files changed, 214 deletions(-) diff --git a/docs/en/docs/ecosystem/mysql-to-doris.md b/docs/en/docs/ecosystem/mysql-to-doris.md deleted file mode 100644 index 67afcd1f9d2..00000000000 --- a/docs/en/docs/ecosystem/mysql-to-doris.md +++ /dev/null @@ -1,105 +0,0 @@ ---- -{ - - "title": "Mysql to Doris", - "language": "en" - -} ---- - -<!-- -Licensed to the Apache Software Foundation (ASF) under one -or more contributor license agreements. See the NOTICE file -distributed with this work for additional information -regarding copyright ownership. The ASF licenses this file -to you under the Apache License, Version 2.0 (the -"License"); you may not use this file except in compliance -with the License. You may obtain a copy of the License at - - http://www.apache.org/licenses/LICENSE-2.0 - -Unless required by applicable law or agreed to in writing, -software distributed under the License is distributed on an -"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY -KIND, either express or implied. See the License for the -specific language governing permissions and limitations -under the License. ---> - -# Mysql to Doris - -mysql to doris is mainly suitable for automating the creation of doris odbc tables, mainly implemented with shell scripts - -## manual - -mysql to doris code [here](https://github.com/apache/doris/tree/master/extension/mysql_to_doris) - -### Directory Structure - -```text -├── mysql_to_doris -│ ├── conf -│ │ ├── doris.conf -│ │ ├── mysql.conf -│ │ └── tables -│ ├── all_tables.sh -│ │ -└── └── user_define_tables.sh -``` - -1. all_tables.sh - - This script mainly reads all the tables under the mysql specified library and automatically creates the Doris odbc external table - -2. user_define_tables.sh - - This script is mainly used for users to customize certain tables under the specified mysql library to automatically create Doris odbc external tables - -3. conf - - Configuration file, `doris.conf` is mainly used to configure doris related, `mysql.conf` is mainly used to configure mysql related, `tables` is mainly used to configure user-defined mysql library tables - -### full - -1. Download using mysql to doris [here](https://github.com/apache/doris/tree/master/extension/mysql_to_doris) -2. Configuration related files - - ```shell - #doris.conf - master_host= - master_port= - doris_password= - doris_odbc_name='' - - #mysql.conf - mysql_host= - mysql_password= - ``` - - | Configuration item | illustrate | - | -------------- | ----------------------- | - | master_host | Doris FE master node IP | - | master_port | Doris FE query_port port | - | doris_password | Doris Password (default root user) | - | doris_odbc_name | The name of mysql odbc in the odbcinst.ini configuration file under be/conf | - | mysql_host | Mysql IP | - | mysql_password | Mysql Password (default root user) | - -3. Execute the `all_tables.sh` script - -``` -sh all_tables.sh mysql_db_name doris_db_name -``` -After successful execution, the files directory will be generated, and the directory will contain `tables` (table name) and `tables.sql` (doris odbc table creation statement) - -### custom - -1. Modify the `conf/tables` file to add the name of the odbc table that needs to be created -2. To configure mysql and doris related information, refer to step 2 of full creation -3. Execute the `user_define_tables.sh` script - -``` -sh user_define_tables.sh mysql_db_name doris_db_name -``` - -After successful execution, the user_files directory will be generated, and the directory will contain `tables.sql` (doris odbc table creation statement) diff --git a/docs/sidebars.json b/docs/sidebars.json index 6f9552deb76..55b66394f33 100644 --- a/docs/sidebars.json +++ b/docs/sidebars.json @@ -230,7 +230,6 @@ "ecosystem/datax", "ecosystem/seatunnel", "ecosystem/kyuubi", - "ecosystem/mysql-to-doris", "ecosystem/logstash", "ecosystem/beats", "ecosystem/plugin-development-manual", diff --git a/docs/zh-CN/docs/ecosystem/mysql-to-doris.md b/docs/zh-CN/docs/ecosystem/mysql-to-doris.md deleted file mode 100644 index f08b192c9e2..00000000000 --- a/docs/zh-CN/docs/ecosystem/mysql-to-doris.md +++ /dev/null @@ -1,108 +0,0 @@ ---- -{ - - "title": "Mysql to Doris", - "language": "zh-CN" - -} ---- - -<!-- -Licensed to the Apache Software Foundation (ASF) under one -or more contributor license agreements. See the NOTICE file -distributed with this work for additional information -regarding copyright ownership. The ASF licenses this file -to you under the Apache License, Version 2.0 (the -"License"); you may not use this file except in compliance -with the License. You may obtain a copy of the License at - - http://www.apache.org/licenses/LICENSE-2.0 - -Unless required by applicable law or agreed to in writing, -software distributed under the License is distributed on an -"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY -KIND, either express or implied. See the License for the -specific language governing permissions and limitations -under the License. ---> - -# Mysql to Doris - -mysql to doris 主要适用于自动化创建doris odbc 表,主要用shell脚本实现 - -## 使用手册 - -mysql to doris 代码[这里](https://github.com/apache/doris/tree/master/extension/mysql_to_doris) - -### 目录结构 - -```text -├── mysql_to_doris -│ ├── conf -│ │ ├── doris.conf -│ │ ├── mysql.conf -│ │ └── tables -│ ├── all_tables.sh -│ │ -└── └── user_define_tables.sh -``` - -1. all_tables.sh - - 这个脚本主要是读取mysql指定库下的所有表,自动创建Doris odbc外表 - -2. user_define_tables.sh - - 这个脚本主要用于用户自定义指定mysql库下某几张表,自动创建Doris odbc外表 - -3. conf - - 配置文件,`doris.conf`主要是配置doris相关的,`mysql.conf`主要配置mysql相关的,`tables`主要用于配置用户自定义mysql库的表 - -### 全量 - -1. 下载使用mysql to doris[这里](https://github.com/apache/doris/tree/master/extension/mysql_to_doris) - -2. 配置相关文件 - - ```shell - #doris.conf - master_host= - master_port= - doris_password= - doris_odbc_name='' - - #mysql.conf - mysql_host= - mysql_password= - ``` - - | 配置项 | 说明 | - |------------------| ----------------------- | - | master_host | Doris FE master节点IP | - | master_port | Doris FE query_port端口 | - | doris_password | Doris 密码(默认root用户) | - | doris_odbc_name | be/conf 下odbcinst.ini配置文件中mysql odbc的名称 | - | mysql_host | Mysql IP | - | mysql_password | Mysql 密码(默认root用户) | - - -3. 执行`all_tables.sh`脚本 - -``` -sh all_tables.sh mysql_db_name doris_db_name -``` - -执行成功后会生成 files目录,该目录包含`tables`(表名称) 和 `tables.sql` (doris odbc建表语句) - -### 自定义 - -1. 修改`conf/tables`文件,添加需要创建doris odbc的表 -2. 配置mysql和doris相关信息,参考全量创建第2步 -3. 执行`user_define_tables.sh`脚本 - -``` -sh user_define_tables.sh mysql_db_name doris_db_name -``` - -执行成功后会生成 user_files目录,该目录包含 `tables.sql` (doris odbc建表语句) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org