Configuration

Connection URL

mysql://[[user][:password]@][host][:port]/[schema] [?propertyName1][=propertyValue1] [&propertyName2][=propertyValue2]...

• user: User connecting to the server.
• password: Password to use when connecting to the server.
• host: It is the host name of the machine runing MySQL/MariaDB server. (default: 127.0.0.1)
• port: Port number the MySQL/MariaDB server is listening to. (default: 3306)
• schema: Name of the schema to connect to. The valid values are mysql and file.
• propertyName=propertyValue: It represents an optional, ampersand-separated list of properties.

eg. "mysql://root:pass@localhost:3306/test?Socket=/tmp/mysql.sock"

Reference : http://docs.oracle.com/javase/tutorial/jdbc/basics/connecting.html

Properties

• BinlogDumpNonBlock: Terminate connection when there are no more binary log events.
• BinlogSlaveId: Slave Id to use when connecting to a master server.
• BinlogVerifyChecksum: Calculate & verify checksum of replication binary log events. (Default: false)
• Compress: Compress protocol network packets using zlib.
• LocalInfile: Enable 'LOAD DATA LOCAL INFILE' support. (Default: false)
• MaxAllowedPacket: Maximum client packet size. (Default: 16MB)
• ReportWarnings: Report warnings from the execution of last statement as error. The warnings are ignored by default.
• Socket: Unix socket to connect to the server.
• SSLCA: File containing a list of SSL CAs.
• SSLCert: SSL certificate file.
• SSLKey: SSL key file.

Note: A property name is in Pascal case (or upper Camel case) and case-sensitive.