Skip to main content

Custom MySQL Database Configuration

Through connection configuration, you can integrate your self-hosted MySQL database into the cloud development platform, enabling:

  • Generate data models based on existing data tables
  • Utilize the model operation capabilities provided by cloud development
  • Directly manage data in the original database

Database Integration Architecture

Creating a Connection Configuration

Creating an Entry Point

  • Database Configuration Management Interface
  • Configuration options when creating a data model

Configuration Parameters

ParameterDescriptionRequired
Configuration NameDisplay name for the connection configurationYes
Configuration IDUnique identifier for the connection configurationYes
Host AddressPublic IP or domain name of the MySQL databaseYes
PortConnection port for the MySQL databaseYes
Database NameName of the database to connect toYes
UsernameDatabase connection usernameYes
PasswordDatabase connection passwordYes
Connection ParametersMySQL connection parametersNo
TimeoutTimeout for connection and accessNo

Connection Configuration Interface

IP Allowlist Configuration

To ensure data security, please add the following IP addresses to the database's allowlist:

175.24.211.44, 
175.24.212.162, 
175.24.213.48, 
175.24.214.104, 
175.24.214.93, 
49.234.25.245, 
49.234.27.58, 
49.234.3.160, 
49.234.34.31, 
49.234.35.33,

Note: All IP addresses must be added to ensure the service runs properly.

Connection Configuration Management

Usage Limitations

  1. Connection configuration used by the data model:

    • Non-deletable
    • Non-modifiable configuration
  2. If you need to modify the configuration:

    • Create a new connection configuration
    • Delete the existing data model
    • Recreate the data model using the new configuration
    • Delete the old connection configuration

Best Practices

  1. Create a dedicated database account and grant only necessary permissions
  2. Regularly update the allowlist configuration to ensure security
  3. Use appropriate connection parameters to optimize performance
  4. Set an appropriate timeout to prevent connection hanging