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. For project configuration, the rights of the user under which the configuration environment is running apply. "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 Timeout | 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 Time-out | Time (in seconds) that establishing a connection to the database is allowed to take. |
| Concurrent Connections | Number of connections the router is allowed to establish simultaneously. The more connections, the faster the router; however, the database may become slower under certain circumstances. Ask your database administrator how many connections he allows 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 period (.) is present in an identifier, backticks are added. This is useful if you have database objects with periods in their names, such as
database.schema.`table.name`. - Disable: In this mode, no backticks are 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.