Connect to a MySQL server, addr can be ip:port, or a unix socket domain like /var/sock.

ConnectWithContext to a MySQL addr using the provided context.

ConnectWithDialer to a MySQL server using the given Dialer.

NewClientTLSConfig: generate TLS config for client side if insecureSkipVerify is set to true, serverName will not be validated.

NewPool initializes new connection pool and uses params: addr, user, password, dbName and options.

NewPoolWithOptions initializes new connection pool and uses params: addr, user, password, dbName and options.

WithNewPoolPingTimeout enables connect & ping to DB during the pool initialization.

WithPoolLimits sets pool limits: - minAlive specifies the minimum number of open connections that the pool will try to maintain.

DefaultIdleTimeout - If the connection has been idle for more than this time, we can close it (but we should remember about Pool.minAlive).

MaxIdleTimeoutWithoutPing - If the connection has been idle for more than this time, then ping will be performed before use to check if it alive.

MaxNewConnectionAtOnce - If we need to create new connections, then we will create no more than this number of connections at a time.

Dialer connects to the address on the named network using the provided context.

This function will be called once per result from ExecuteMultiple.

This function will be called once per result from ExecuteSelectStreaming.

This function will be called for every row in resultset from ExecuteSelectStreaming.