MySQL Plug-in
Connection Settings
| Property | Description |
|---|---|
| Name | Any name under which this database server appears in the connection configuration. Choose a name that is unique to you during the connection configuration. |
| Host/IP/File | Address of the MySQL server |
| Port | Selection of the port for the database connection. The port can be changed if necessary. |
| Data Source | Name of the database to be used |
| Windows Authentication | Uses the Windows account of the OPC Router service instead of a username and password. This account must have the necessary access rights to the database. The rights of the user under which the configuration environment is running apply to the project configuration. “Test Connection” is only of limited use because it uses the user of the configuration environment rather than the Windows account of the Router service. Notes on configuring Windows user accounts for the OPC Router. |
| User | Username for logging in to the MySQL server |
| Password | Password for logging in to the MySQL server |
Advanced Connection Parameters
| Property | Description |
|---|---|
| Command Time-out | Time (seconds) that the router waits for an SQL command to complete. For long-running queries, it may be necessary to increase this value. Please note that you must also increase this value for individual connections that trigger long queries. |
| Connection Timeout | Time (in seconds) that establishing a connection to the database may take. |
| Concurrent Connections | Number of connections the router is allowed to establish simultaneously. The more connections, the faster the router, but the database may be slower under certain circumstances. Ask your database administrator how many connections they allow the router to use. This naturally also depends on the scope of the project. |
| Polling Interval | Interval at which the database is queried. |
Advanced Settings
| Property | Description |
|---|---|
| BracketsEncloseBehaviour | This property determines when and how backticks (`) are used in your MySQL plugin. More information is available here |
BracketsEncloseBehaviour
- Enclose if dot present: This mode is intended for backward compatibility. If a dot (.) is present in an identifier, backticks are added. This is useful if you have database objects with dots in their names, such as
database.schema.`table.name`. - Disable: In this mode, backticks are never added, regardless of the identifier. This can be useful if you are certain that your identifiers do not contain special characters or spaces and you want to improve the readability of the generated SQL.
- Always: In this mode, backticks are always added. This is useful if your identifiers might contain special characters, spaces, or reserved words.