Bug #59451 Please document the new URL format, and its relation to IPv6

• Submitted: 12 Jan 2011 16:35
• Modified: 19 Apr 2012 0:52
• Reporter: Mark Matthews
• Status: Closed
• Category: Connector / J Documentation
• Severity: S3 (Non-critical)
• OS: Any
• Assigned to: John Russell
• CPU Architecture: Any

[12 Jan 2011 16:35] Mark Matthews

Description:
In 5.1.14, we introduced a new URL format option, and it is required to use this with IPv6 addresses. This should probably go into the "" section.

Here's the relevant info from the changelog:

   Added support for hosts specified in the URL of the form:
     address=(key=value), supported keys are:

       (protocol=tcp or pipe (for named pipes on Windows))
       (path=[] for named pipes)
       (host=[]) for TCP connections
       (port=[]) for TCP connections

       An example would be:

       jdbc:mysql://address=(protocol=tcp)(host=localhost)(port=3306)(user=test)/db

      Any other parameters are treated as host-specific properties that follow
      the conventions of the JDBC URL properties. This now allows per-host
      overrides of any configuration property for multi-host connections
      (failover, loadbalance, replication). We do recommend that the overrides
      are limited to user, password, network timeouts and statement and
      metadata cache sizes. Unexpected behavior may be observed with other
      per-host overrides.

How to repeat:
n/a

[19 Apr 2012 0:52] John Russell

Added relevant info to:

http://dev.mysql.com/doc/refman/5.6/en/connector-j-reference-configuration-properties.html

The same info will also appear in the 5.5, and 5.1, and 5.0 manuals. It will probably take a couple of days to be posted.