Would it work with SRV records?

[gaurav517]

Question

Would it work with srv schemas in MySQL connector/j8?:

These new schemas in the connection URLs enable DNS SRV record support:
jdbc:mysql+srv: For ordinary and basic failover JDBC connections that make use of DNS SRV records.
jdbc:mysql+srv:loadbalance: For load-balancing JDBC connections that make use of DNS SRV records.
jdbc:mysql+srv:replication: For replication JDBC connections that make use of DNS SRV records.
mysqlx+srv: For X DevAPI connections that make use of DNS SRV records.

https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-dns-srv.html

Code

No response

Additional Details

No response

[enocom]

The Java Connector resolves an instance connection name to a single IP address. Currently, we don't have any support for load balancing across multiple instances.

There's a feature request for that here: #124. If you'd like to add additional information there, please do. We're working on a v2 of the Java Connector and along with other improvements in Cloud SQL, we might be able to revisit this work in the future.