You can access the tutorial artifact including deployment script (Terraform), related source code, sample data and instruction guidance from the github project: https://github.com/alibabacloud-howto/solution-interactive-game-map-postgis-redis
More tutorial around Alibaba Cloud Database, please refer to: https://github.com/alibabacloud-howto/database
This is demo of building an interactive "Game of Thrones" (https://github.com/andi1991/Atlas-Of-Thrones) map powered by Leaflet, PostgreSQL/PostGIS and Redis on Alibaba Cloud.
Deployment architecture:
- Step 1. Use Terraform to provision ECS, PostgreSQL database and Redis on Alibaba Cloud
- Step 2. Setup sample data in RDS PostgreSQL database
- Step 3. Install NodeJS
- Step 4. Deploy and run the demo game map project
If you are the 1st time to use Terraform, please refer to https://github.com/alibabacloud-howto/terraform-templates to learn how to install and use the Terraform on different operating systems.
Run the terraform script. Please specify the necessary information and region to deploy.
After the Terraform script execution finished, the ECS instance information are listed as below.
eip_ecs: The public EIP of the ECS for gamp map application hostrds_pg_url: The connection endpoint URL of the RDS PostgreSQL databaserds_pg_port: The connection endpoint port of the RDS PostgreSQL databaseredis_url: The connection endpoint URL of the Redis
Click Elastic Compute Service, as shown in the following figure.
We can see one running ECS instance in China(Hongkong) region.
Copy this ECS instance's Internet IP address and remotely log on to this ECS (Ubuntu system) instance. For details of remote login, refer to login。
The default account name and password of the ECS instance:
Account name: root
Password: Aliyun-test
After logging in successfully, enter the following command to download the pre-prepared data script.
wget https://cdn.patricktriest.com/atlas-of-thrones/atlas_of_thrones.sql
Enter the following command to install the PostgreSQL client.
apt update && apt -y install postgresql-client
Enter the following command to connect to the PostgreSQL instance. Please pay attention to replace YOUR-POSTGRESQL-ADDRESS with the connection address of the user's own PostgreSQL instance
psql -h YOUR-POSTGRESQL-ADDRESS -p 5432 -U patrick -d atlas_of_thrones
Password: the_best_passsword
Enter the following command to install the Postgis extension. If the prompt already exists, it doesn’t matter, just proceed directly to the following operations
CREATE EXTENSION postgis;
Enter the following command to exit the client.
\q
Enter the following command, Load the downloaded SQL dump into your newly created database. Please pay attention to replace YOUR-POSTGRESQL-ADDRESS with the connection address of your own PostgreSQL instance
psql -h YOUR-POSTGRESQL-ADDRESS -p 5432 -U patrick -d atlas_of_thrones < atlas_of_thrones.sql
Password: the_best_passsword
Enter the following command to log in to the "atlas_of_thrones" database. Please pay attention to replace YOUR-POSTGRESQL-ADDRESS with the connection address of the user's own PostgreSQL instance
psql -h YOUR-POSTGRESQL-ADDRESS -p 5432 -U patrick -d atlas_of_thrones
Password: the_best_passsword
Enter the following command, we can get a list of available tables.
\dt
Enter the following command, we can inspect the schema of an individual table by running
\d kingdoms
Enter the following command to query data.
SELECT name, claimedby, gid FROM kingdoms;
Enter the following command to exit the client.
\q
Enter the following command to download the Nodejs installation package.
wget http://labex-ali-data.oss-us-west-1.aliyuncs.com/nodejs/node-v12.13.0-linux-x64.tar.xz
Enter the following command to decompress the installation package.
tar -xf node-v12.13.0-linux-x64.tar.xz
Enter the following command to move the unzipped directory to the "/usr/local" directory.
mv node-v12.13.0-linux-x64 /usr/local/node
Enter the command: vim /etc/profile, add the following content to the file.
export NODE_HOME=/usr/local/node
export PATH=$PATH:$NODE_HOME/bin
Enter the following command to make the modification effective.
source /etc/profile
Enter the following command to view the installed version, indicating that the installation is complete.
node -v
npm -v
Enter the following command to install the git tool.
apt -y install git
Enter the following command to download the project.
git clone -b labex https://github.com/andi1991/Atlas-Of-Thrones.git
Enter the following command to enter the project directory.
cd Atlas-Of-Thrones
Enter the command: vim .env, copy the following content to the file, please pay attention to replace YOUR-POSTGRESQL-ADDRESS 、YOUR-REDIS-ADDRESS with the connection address of your own instance
PORT=5000
DATABASE_URL=postgres://patrick:the_best_passsword@YOUR-POSTGRESQL-ADDRESS:5432/atlas_of_thrones?ssl=false
REDIS_HOST=YOUR-REDIS-ADDRESS
REDIS_PORT=6379
CORS_ORIGIN=http://localhost:8080
Enter the following command to install related dependencies.
npm install
Enter the following command to install the dependent package that reported the error separately.
npm cache clean --force
npm i --unsafe-perm [email protected]
Enter the following command to start the service.
npm run dev
Access the service in the browser, enter the link below, please pay attention to replace YOUR-ECS-PUBLIC-IP with the user's own ECS public IP address
YOUR-ECS-PUBLIC-IP:8080
Game map service deployment is completed.
Author of this tutorial on Alibaba Cloud: