MySQL Plug-in
Connection Settings
| Property | Description |
|---|---|
| Name | Any name under which this database server appears in the connection project. Choose a name that is unique to you during connection projecting. |
| 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 | Enable to use Windows authentication instead of the User and Password properties. Supports local user accounts, DCOM users, and Windows domain users (NT authentication). To use integrated security, the user under which the OPC Router service is started (by default "System") must have access rights to the database. To be able to configure, the user under which the configuration environment was started must have access rights to the database. "Test connection" is not meaningful in this case, as the test is not performed with the "System" user, but with the user who started the configuration environment. |
| User | User name for logging on to the MySQL server |
| Password | Password for logging on 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 the value for individual connections that trigger long queries. |
| Connection Timeout | Time (seconds) that a connection to the database may take. |
| Simultaneous connections | Number of connections that the router is allowed to establish in parallel. The more connections, the faster the router, but the slower the database may be. Ask your database administrator how many connections he allows the router to make. This also depends on the scope of the project, of course. |
| Polling interval | Interval at which the database is queried. |
Advanced settings
| Property | Description |
|---|---|
| BracketsEncloseBehavior | This property determines when and how backticks (`) are used in your MySQL plugin. Here is more information |
BracketsEncloseBehavior
- Enclose if dot present: This mode is intended for backward compatibility. If a period (.) is included 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 sure that your identifiers do not contain any 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.