| --- |
| sidebar_position: 0 |
| title: Deployment Prerequisites |
| keywords: ["Deployment Prerequisites"] |
| description: Deployment Prerequisites |
| --- |
| |
| This article describes some of the prerequisites you need to prepare before deploying the Apache ShenYu gateway. |
| |
| ## Database Initialize |
| |
| Before deploying the `Shenyu-admin` project, initialize the database it uses (databases currently support: Mysql, PostgreSql, Oracle), which used the script files are stored in db directory [project root directory](https://github.com/apache/shenyu/tree/master/db), The following describes the initial steps for each database. |
| |
| ### Mysql |
| |
| In [the mysql initialization scripts directory](https://github.com/apache/shenyu/tree/master/db/init/mysql) found in the initialization script `schema.sql`, Use the client connection tool to connect to your Mysql service and execute, so you get a database named `shenyu`, which can later be used as the database for the `Shenyu-admin` project. |
| |
| * sql script: https://github.com/apache/shenyu/tree/master/db/init/mysql |
| |
| * driver: |
| |
| * maven repository: https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.30/ |
| * homepage: https://www.mysql.com/products/connector/ |
| |
| ### PostgreSql |
| |
| In [the pg initialization scripts directory](https://github.com/apache/shenyu/tree/master/db/init/pg) found in the initialization script `create-database.sql`、 `create-table.sql`, and use the client connection tool to connect to your PostgreSql service. so you get a database named `shenyu`, which can later be used as a database for the `Shenyu-admin` project. |
| |
| * sql script: https://github.com/apache/shenyu/tree/master/db/init/pg |
| |
| * driver: |
| |
| * maven repository: https://mvnrepository.com/artifact/org.postgresql/postgresql/42.5.0 |
| * homepage: https://jdbc.postgresql.org/download/ |
| |
| ### Oracle |
| |
| In [the oracle initialization scripts directory](https://github.com/apache/shenyu/blob/master/db/init/oracle) found in the initialization script `schema.sql`, Use the client connection tool to connect to your Oracle service to create a database, execute the `schema.sql` script on this database, and initialize the `Shenyu-admin` database. After can be [project configuration file](https://github.com/apache/shenyu/blob/master/shenyu-admin/src/main/resources/application-oracle.yml) to adjust your Oracle environment configuration. |
| |
| * sql script: https://github.com/apache/shenyu/blob/master/db/init/oracle |
| |
| * driver: |
| |
| * maven repository: https://mvnrepository.com/artifact/com.oracle.database.jdbc/ojdbc8/19.3.0.0 |
| * homepage: https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html |
| |
| ### OpenGauss |
| |
| In [the openGuass initialization scripts directory](https://github.com/apache/shenyu/blob/master/db/init/og) found in the initialization script `create-table.sql`, Use the client connection tool to connect to your openGauss service to create a database, execute the `create-table.sql` script on this database, and initialize the `Shenyu-admin` database. After can be [project configuration file](https://github.com/apache/shenyu/blob/master/shenyu-admin/src/main/resources/application-og.yml) to adjust your openGauss environment configuration. |
| |
| * sql script: https://github.com/apache/shenyu/blob/master/db/init/og |
| |
| * driver: |
| |
| * maven repository: https://mvnrepository.com/artifact/org.opengauss/opengauss-jdbc/5.0.0-og |
| * homepage: https://gitee.com/opengauss/openGauss-connector-jdbc |
