This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.0 by this push:
new 0cc604e5e2d delete external table docs 2.0 (#28350)
0cc604e5e2d is described below
commit 0cc604e5e2d36a66c53dc8daa507ffd3f43ea8a5
Author: ZhenchaoXu <[email protected]>
AuthorDate: Sat Dec 16 23:36:54 2023 +0800
delete external table docs 2.0 (#28350)
---
docs/en/docs/ecosystem/mysql-to-doris.md | 241 ----------------------------
docs/sidebars.json | 1 -
docs/zh-CN/docs/ecosystem/mysql-to-doris.md | 206 ------------------------
3 files changed, 448 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 9a4e74f086b..00000000000
--- a/docs/en/docs/ecosystem/mysql-to-doris.md
+++ /dev/null
@@ -1,241 +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
-
-This is an easy-to-use tool to help mysql users on using doris with odbc
external table creation, olap table creation and data sync.
-
-mysql to doris code
[here](https://github.com/apache/doris/tree/master/extension/mysql_to_doris)
-
-## Directory Structure
-
-```text
-├── bin
-│ └── run.sh
-├── conf
-│ ├── doris_external_tables
-│ ├── doris_tables
-│ ├── env.conf
-│ └── mysql_tables
-└── lib
- ├── jdbc
- │ ├── create_jdbc_catalog.sh
- │ └── sync_to_doris.sh
- ├── e_auto.sh
- ├── e_mysql_to_doris.sh
- ├── get_tables.sh
- ├── mysql_to_doris.sh
- ├── mysql_type_convert.sh
- ├── sync_check.sh
- └── sync_to_doris.sh
-```
-
-## configurations
-
-All configuration files are in the conf directory.
-
-### env.conf
-
-Fill in your doris and mysql information here.
-
-```text
-# doris env
-fe_master_host=<your_fe_master_host>
-fe_master_port=<your_fe_master_query_port>
-doris_username=<your_doris_username>
-doris_password=<your_doris_password>
-doris_odbc_name=<your_doris_odbc_driver_name>
-doris_jdbc_catalog=<jdbc_catalog_name>
-doris_jdbc_default_db=<jdbc_default_database>
-doris_jdcb_driver_url=<jdcb_driver_url>
-doris_jdbc_driver_class=<jdbc_driver_class>
-
-# mysql env
-mysql_host=<your_mysql_host>
-mysql_port=<your_mysql_port>
-mysql_username=<your_mysql_username>
-mysql_password=<your_mysql_password>
-```
-
-### mysql_tables
-
-Fill in the mysql table here, in the form of `database.table`.
-
-```text
-db1.table1
-db1.table2
-db2.table3
-```
-
-### doris_tables
-
-Fill in the doris olap table here, in the form of `database.table`.
-
-```text
-doris_db.table1
-doris_db.table2
-doris_db.table3
-```
-
-### doris_external_tables
-
-Fill in the doris external table here, in the form of `database.table`.
-
-```text
-doris_db.e_table1
-doris_db.e_table2
-doris_db.e_table3
-```
-
-## How to use
-
-bin/run.sh is the startup shell script and this is options for the script:
-
-```shell
-Usage: run.sh [option]
- -e, --create-external-table: create doris external table
- -o, --create-olap-table: create doris olap table
- -i, --insert-data: insert data into doris olap table from doris external
table
- -d, --drop-external-table: drop doris external table
- -a, --auto-external-table: create doris external table and auto check
mysql schema change
- --database: specify the database name to process all tables under the
entire database, and separate multiple databases with ","
- -t, --type: specify external table type, valid options: ODBC(default), JDBC
- -h, --help: show usage
-```
-
-### 1. Create doris external table
-
-use like this:
-
-```shell
-sh bin/run.sh --create-external-table
-```
-
-or
-
-```shell
-sh bin/run.sh -e
-```
-
-then doris odbc external table has been created, and the table creation
statement will be generated in `result/mysql/e_mysql_to_doris.sql` file.
-
-If `--type` option is specified as `JDBC`, create jdbc catalog statement will
be generated in `result/mysql/jdbc_catalog.sql` file.
-
-### 2. Create doris olap table
-
-use like this:
-
-```shell
-sh bin/run.sh --create-olap-table
-```
-
-or
-
-```shell
-sh bin/run.sh -o
-```
-
-then doris odbc olap table has been created, and the table creation statement
will be generated in `result/mysql/mysql_to_doris.sql` file.
-
-### 3. Create doris olap table and sync data from odbc external table
-
-The premise is that you have created the external table, if not, please create
it first.
-
-use like this:
-
-```shell
-sh bin/run.sh --create-olap-table --insert-data
-```
-
-or
-
-```shell
-sh bin/run.sh -o -i
-```
-
-then doris odbc olap table has been created, and the table creation statement
will be generated in `result/mysql/mysql_to_doris.sql` file, and the insert
statement is generated in `result/mysql/sync_to_doris.sql` file.
-
-#### Sync result check
-
-After the data is synchronized, the task of checking the synchronization
results will be executed to compare the data volume of the olap table and mysql
table, and the checking results will be saved in the `result/mysql/sync_check`
file.
-
-#### Drop external table
-
-If you want to drop odbc external table after data sync finished, add
`--drop-external-table` or `-d` option.
-
-use like this:
-
-```shell
-sh bin/run.sh --drop-external-table
-```
-
-or
-
-```shell
-sh bin/run.sh -d
-```
-
-this option is valid for `ODBC` type.
-
-### 4. Create doris external table and sync schema change automatically
-
-use like this:
-
-```shell
-sh bin/run.sh --auto-external-table
-```
-
-or
-
-```shell
-sh bin/run.sh -a
-```
-
-the program will run in the background, process id is saved in `e_auto.pid`,
and this option is valid for `ODBC` type.
-
-### Process by specifying the database
-
-If you have a large number of tables and do not need to customize the doris
table name, you can specify the database name to be processed through the
`--databases` option without manual configuration.
-
-use like this:
-
-```shell
-# single database
-sh bin/run.sh --database db1
-```
-
-or
-
-```shell
-# multiple databases
-sh bin/run.sh --database db1,db2,db3
-```
-
-With this option, the program will automatically obtain all the tables under
the specified mysql database, and generate the configuration of `mysql_tables`,
`doris_tables` and `doris_external_tables`.
-
-**Please note that this option needs to be used in conjunction with other
options.**
diff --git a/docs/sidebars.json b/docs/sidebars.json
index c606696b545..35dc65bf34a 100644
--- a/docs/sidebars.json
+++ b/docs/sidebars.json
@@ -234,7 +234,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 300f6ce02d5..00000000000
--- a/docs/zh-CN/docs/ecosystem/mysql-to-doris.md
+++ /dev/null
@@ -1,206 +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
-
-这是一个通过集合了 odbc 外部表创建、内部表创建以及数据同步等功能来帮助 MySQL 用户使用 Doris 的易用工具。
-
-mysql to doris
代码[这里](https://github.com/apache/doris/tree/master/extension/mysql_to_doris)
-
-## 目录结构
-
-```text
-├── bin
-│ └── run.sh
-├── conf
-│ ├── doris_external_tables
-│ ├── doris_tables
-│ ├── env.conf
-│ └── mysql_tables
-└── lib
- ├── jdbc
- │ ├── create_jdbc_catalog.sh
- │ └── sync_to_doris.sh
- ├── e_auto.sh
- ├── e_mysql_to_doris.sh
- ├── get_tables.sh
- ├── mysql_to_doris.sh
- ├── mysql_type_convert.sh
- ├── sync_check.sh
- └── sync_to_doris.sh
-```
-
-## 配置信息
-
-所有配置文件都在`conf`目录下。
-
-### env.conf
-在这里配置 MySQL 和 Doris 的相关配置信息。
-```text
-# doris env
-# doris env
-fe_master_host=<your_fe_master_host>
-fe_master_port=<your_fe_master_query_port>
-doris_username=<your_doris_username>
-doris_password=<your_doris_password>
-doris_odbc_name=<your_doris_odbc_driver_name>
-doris_jdbc_catalog=<jdbc_catalog_name>
-doris_jdbc_default_db=<jdbc_default_database>
-doris_jdbc_driver_url=<jdbc_driver_url>
-doris_jdbc_driver_class=<jdbc_driver_class>
-
-# mysql env
-mysql_host=<your_mysql_host>
-mysql_port=<your_mysql_port>
-mysql_username=<your_mysql_username>
-mysql_password=<your_mysql_password>
-```
-
-### mysql_tables
-在这里配置 MySQL 表信息，以`database.table`的形式。
-```text
-db1.table1
-db1.table2
-db2.table3
-```
-
-### doris_tables
-在这里配置 Doris Olap 表信息，以`database.table`的形式。
-```text
-doris_db.table1
-doris_db.table2
-doris_db.table3
-```
-
-### doris_external_tables
-在这里配置 Doris ODBC 外部表信息，以`database.table`的形式。
-```text
-doris_db.e_table1
-doris_db.e_table2
-doris_db.e_table3
-```
-
-## 如何使用
-bin/run.sh 是启动的 shell 脚本，下面是脚本的参数选项：
-```shell
-Usage: run.sh [option]
- -e, --create-external-table: create doris external table
- -o, --create-olap-table: create doris olap table
- -i, --insert-data: insert data into doris olap table from doris external
table
- -d, --drop-external-table: drop doris external table
- -a, --auto-external-table: create doris external table and auto check
mysql schema change
- --database: specify the database name to process all tables under the
entire database, and separate multiple databases with ","
- -t, --type: specify external table type, valid options: ODBC(default), JDBC
- -h, --help: show usage
-```
-
-### 创建 Doris ODBC 外部表
-使用方法如下：
-```shell
-sh bin/run.sh --create-external-table
-```
-或者
-```shell
-sh bin/run.sh -e
-```
-执行完成后 ODBC 外部表就创建完成，同时建表语句会被生成到`result/mysql/e_mysql_to_doris.sql`文件中。
-
-### 创建 Doris OLAP 表
-使用方法如下：
-```shell
-sh bin/run.sh --create-olap-table
-```
-或者
-```shell
-sh bin/run.sh -o
-```
-执行完成后 ODBC OLAP 表就创建完成，同时建表语句会被生成到`result/mysql/mysql_to_doris.sql`文件中。
-
-如果设置 `--type` 选项为 `JDBC`，则会创建 JDBC Catalog，同时创建语句语句会被生成到
`result/mysql/jdbc_catalog.sql` 文件中。
-
-### 创建 Doris OLAP 表同时从外部同步数据
-
-前提是你已经创建外部表（JDBC 方式则为 JDBC Catalog），如果没有，请先创建。
-
-使用方法如下：
-```shell
-sh bin/run.sh --create-olap-table --insert-data
-```
-或者
-```shell
-sh bin/run.sh -o -i
-```
-执行完成后 ODBC OLAP
表就创建完成，同时建表语句会被生成到`result/mysql/mysql_to_doris.sql`文件中，并且同步语句会被生成到`result/mysql/sync_to_doris.sql`文件中。
-
-#### 同步结果检查
-同步数据之后会执行同步结果检查任务，对olap表和mysql表的数据量进行对比，检查结果保存在 `result/mysql/sync_check` 文件中。
-
-#### 删除 ODBC 外部表
-如果在数据同步执行完成后想要删除 ODBC 外部表，添加`--drop-external-table`或`-d`选项。
-
-使用方式如下：
-```shell
-sh bin/run.sh --create-olap-table --insert-data --drop-external-table
-```
-或者
-```shell
-sh bin/run.sh -o -i -d
-```
-
-此选项只当 `--type` 为 `ODBC` 时有效。
-
-### 创建 Doris OLAP 表并且自动同步表结构变化
-使用方式如下：
-```shell
-sh bin/run.sh --auto-external-table
-```
-或者
-```shell
-sh bin/run.sh -a
-```
-
-程序会在后台执行，进程 ID 被保存到`e_auto.pid`文件。
-
-### 通过指定数据库来处理
-
-如果你的表比较多，并且不需要自定义doris表名，可以通过`--databases`选项指定要处理的数据库名，无需手动配置。
-
-使用方式如下：
-```shell
-# 单个数据库
-sh bin/run.sh --databases db1
-```
-或者
-```shell
-# 多个数据库
-sh bin/run.sh --databases db1,db2,db3
-```
-
-通过这个选项，程序会自动获取mysql指定数据库下的全部表，并生成mysql_tables,
doris_tables和doris_external_tables的配置。
-
-**请注意，该选项需要配合其他选项一起使用。**
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
