Tutorial

Database Creation

SuperMap iManager supports to ‘one-click’ creating Redis, MySQL, MinIO, PostGIS, PostgreSQL, Elasticsearch, Yukon, SeaweedFS , or Neo4j database, please refer to the following steps(The following content demonstrate how to create MySQL database, the steps of creating other databases are same as this demonstration):

1. Open Sites Management on the left navigation bar.
2. Clicks on + Create.

3. Fills in the name of MySQL environment, and select MySQL in the Site type.

   Advanced Options:

   • Namespace: Specifies the namespace for the created site. If not specified, the system will assign a namespace for it. The specified namespace will be created automatically when it does not exist and will be deleted when the site is deleted. The existing namespace will not be deleted.
   • MySQL external port: Set the external port number of MySQL access address, a random port would be used if not set.
   • MySQL Web client external port: Set the external port number of MySQL Web client access address, a random port would be used if not set.
   • Use Service Mesh: Click to open service mesh function, the site is available to achieve service trace and service metrics. Modify the value of deploy_istio_enabled to ‘true’ in the ‘values.yaml’ file of iManager deployment package first if you want to use service mesh, please refer to Guides > Deployment Guide > Install iManager.

   • Resources Allocation: Set the limitation of CPU and Memory of the database environment. The CPU/Memory in the database environment is different to the CPU/Memory in hardware machine, the CPU/Memory in the database environment is the CPU/Memory occupy of a service node in Kubernetes, the total CPU/Memory of the database environment is equal to the sum of CPU/Memory of service nodes.

     • CPU(Required): Set the maximum CPU of the database environment.
     • Memory(Required): Set the maximum Memory of the database environment.
     • Pods: Set the maximum number of available pods in the Site.
     • Default container CPU limit: Set the maximum available CPU of a single container when creating.
     • Default container Memory limit: Set the maximum available Memory of a single container when creating.

   Notes:
   If the database environment enable Service Mesh, each service node would create a istio-proxy, a istio-proxy occupies 2 core CPU and 1 GB Memory, the total CPU/Memory of the database environment is equal to the sum of CPU/Memory of service nodes plus the occupy of the istio-proxy.

4. Clicks on OK.
5. Check the status on the MySQL page, while the status change to ‘Normal’, the MySQL created successfully.