MySQL

Options for MySQL/MySQL-5 Servers

Name	Name of the configuration
Host/IP	IP address of MySQL server.
Port	Selection of the port for the database connection. If necessary, the port can be changed.
Data Source	Database on server to be used.
Windows authentication	Activate to use Windows authentication instead of username and Password. Local accounts, DCOM users a Windows domain users (NT authentication) are supported. To use Windows authentication, the user under which the OPC Router service is running needs access rights to the database server. By default, this is the system user. To be able to define connection, the user under which OPC Router Configuration is running, needs those rights (by default: User logged-on the Windows System). In this case, “Check connection” is valid only for the configuration. Observer carefully if transfers are executed correctly!
User	Username to log on MySQL
Password	Password to log on MySQL
Command time-out	Time (seconds) that the router waits for a command to complete. For long queries, it may be necessary to increase the value. Note that you also need to increase the value for the individual connections that initiate long queries.
Connection time-out	Time (seconds) that the Router may need to establish connection.
Parallel connections	Number of connections that the Router may establish parallely. The more connections the faster the Router the slower probably the database. Ask your database administrator how many connections the Router may establish. This depends on your project’s scale, of course.
Polling interval	Distance at which the database is queried.