When connecting to a MySQL database from the Syniti Knowledge Platform (SKP), provide the following connection properties to establish a secure and reliable connection. This article explains each property to understand what information is required and how it is used.
Property | Description | Notes |
|---|---|---|
Name | Name of the MySQL connection unique to the SKP. | NA |
Description | Enter a description that briefly states the purpose of this connection. | NA |
Hostname | Hostname is the network name or IP address of the MySQL server you want to connect to. | * The server name, for example, MySQLPROD01. * An IP address, for example, 192.168.10.50. |
Port | The port number your MySQL uses to accept connections. | By default, the MySQL port is 3306. If you are not sure, you can use this default port. |
Username | The login name used to sign in to the MySQL. | This login name should be an account that your administrator has created for database access. |
Password | The password for the username above. | Authenticates your connection to the database. |
Database | The name of the specific MySQL database you want to connect to. | MySQL can have many databases; this tells the SKP which one to use. |
Connection Timeout | The maximum number of seconds the system will wait when trying to connect before stopping and showing an error. | Default value is 60 seconds. If your server is slow or far away, you can raise this number. |
Connection Pooling | Connection pooling allows the system to reuse existing database connections instead of creating a new one every time the SKP performs an operation. | * Enabled (Default): The SKP keeps a group (pool) of open database connections ready to use. This reduces the time spent opening and closing connections. * Disabled: A new connection is created and closed for each operation. This is simpler and uses fewer system resources but can be slower for frequent operations. |
Minimum Pool Size | The minimum number of connections that the system will always keep open when pooling is enabled. | Even if the SKP is idle, it will maintain at least this number of ready-to-use connections. Useful when you expect regular activity and want faster response times. For example, If Minimum Pool Size = 2, the SKP always keeps at least 2 connections open. |
Maximum Pool Size | The maximum number of connections the SKP is allowed to open when pooling is enabled. | This prevents the system or database from being overloaded with too many connections. When the pool reaches this limit, new requests must wait until a connection is released. For example, If Maximum Pool Size = 10, the SKP never opens more than 10 connections at the same time. |
SSL Mode | Mode for controlling the SSL connection. | Disabled: SSL is not used. Preferred: The client first attempts an SSL connection; if that fails, it falls back to a non-SSL connection. Required: The connection must use SSL; if an SSL connection cannot be established, an error is returned. Verify-CA: SSL is required, and the server certificate must be verified against a trusted Certificate Authority (CA). Verify-Full: SSL is required, the server certificate must be verified against a trusted CA, and the server hostname must match the certificate. |
SSL Client Private Key | The PEM-encoded private key corresponding to the client certificate. | Required when a client certificate is provided. |
Extended Properties | Use the + Add Property button to add any additional connection properties. | NA |