MySQL/MariaDB Driver

MySQL/MariaDB Driver

Driver Name: mysql

Driver Connection String Options:

• db: Required. Database Name.
• socketpath: Conditional. If using Unix Domain Sockets to connect to MySQL, this is the path to the Unix Domain Socket. Use the keyword of 'search' to search for the socket based on standard known paths. Cannot be used with host.
• host: Conditional. If using IP or SSL/TLS to connect to MySQL, this is the hostname or IP address of the server. If not using the default port of 3306, may append a ":port#" to the end of the host. For specifying multiple hosts in a pool, hosts should be comma delimited. Cannot be used with socketpath.

  host=10.40.30.2,10.50.30.2:13306  

• aurora: Optional. Defaults to false. If true, enables the MariaDB Aurora Connection handler plugin.
• ssl: Optional. Defaults to false, if true enables SSL/TLS to the server.
• mysql_engine: Optional. Used during table creation, defaults to INNODB. The default data storage engine to use with mysql. Typically it is recommended to leave this at the default.
• mysql_charset: Optional. Used during table creation, defaults to utfmb4.
• max_isolation: Optional. Sets the maximum isolation level used for transactions. This is used to overwrite requests for SERIALIZABLE isolation levels, useful with Galera-based clusters that do not truly support Serializable isolation. Should use "SELECT ... FOR UPDATE" type syntax for row locking. Available settings: "REPEATABLE READ", READ COMMITTED"