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, The following describes the initial steps for each database.
Mysql#
In the mysql initialization scripts directory 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 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 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 to adjust your Oracle environment configuration.
sql script: https://github.com/apache/shenyu/blob/master/db/init/oracle
driver:
OpenGauss#
In the openGuass initialization scripts directory 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 to adjust your openGauss environment configuration.
sql script: https://github.com/apache/shenyu/blob/master/db/init/og
driver: