Through connection configuration, we provide the ability to connect to self-owned third-party databases, enabling integration with specified databases and generating data models based on tables in the specified database, along with providing model operations and Database Management Center
(DMC).
When a self-owned MySQL database is integrated, data read-write operations are performed in the connected MySQL database. Data management on the data model, model configuration, and model read-write operations will be written into the MySQL database.
Connection Configuration
In the database configuration management interface, you can view created connection configurations in the current environment or choose to create connection configurations. Meanwhile, when creating models using a self-owned MySQL database, you can also create connection configurations or select existing ones.
When creating connection configurations, fill in the following information:
Connection configuration name and identifier: Used to specify the name and unique identifier of the database connection configuration.
Host and port: When connecting to the database through an IP address or domain name, you need to fill in the host address and connection port of the MySQL database. The host address can be filled with a public network IP address or domain name.
Database name: Fill in the database to be connected and used.
Username and password: Fill in the username and password authentication information used to connect to the database.
Connection parameters: Used to set optional parameter configurations when establishing a connection with the database. For detailed connection parameters, see MySQL connection options. Timeout: The timeout duration for connections or access.
IP Address Allowlist
Self-built MySQL databases exposed to the public network usually need to be configured with an IP address allowlist to prevent unauthorized access. You can add the following IP addresses to the IP address allowlist to allow access for the CloudBase data model components. All of them need to be added to the 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,
Connection Configuration Management
Existing connection configurations can be managed through database configuration.
When a connection configuration is in use by a certain data model, meaning there is a data model created based on the current connection configuration, the corresponding connection configuration cannot be deleted. If you need to delete a connection configuration, delete the corresponding data model first, and then delete the connection configuration.
Connection configurations cannot be modified. If reconfiguration is needed, you can create a connection configuration and delete the old one.