activerecord-jdbc-adapter icon indicating copy to clipboard operation
activerecord-jdbc-adapter copied to clipboard

MySQL Connector/J multi-host helpers

Open kares opened this issue 10 years ago • 0 comments

... since multi-hosts might be used for replication/loadbalancing (besides fail-over).

so that users do not have to specify the full jdbc syntax we should introduce :

adapter: mysql
  host: host1,host2
  loadbalance: true # jdbc:mysql:replication://[master host][:port],[slave host 1][:port] ...
  # replication: true # jdbc:mysql:loadbalance://[host1][:port],[host2][:port][,[host3][:port]]...

http://dev.mysql.com/doc/connector-j/en/connector-j-master-slave-replication-connection.html http://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-j2ee-concepts-managing-load-balanced-connections.html

--- Want to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/23002422-mysql-connector-j-multi-host-helpers?utm_campaign=plugin&utm_content=tracker%2F136963&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F136963&utm_medium=issues&utm_source=github).

kares avatar Jun 25 '15 07:06 kares