{"action":"created","issue":{"url":"https://api.github.com/repos/crate/crate-jdbc/issues/80","labels_url":"https://api.github.com/repos/crate/crate-jdbc/issues/80/labels{/name}","comments_url":"https://api.github.com/repos/crate/crate-jdbc/issues/80/comments","events_url":"https://api.github.com/repos/crate/crate-jdbc/issues/80/events","html_url":"https://github.com/crate/crate-jdbc/issues/80","id":109122954,"number":80,"title":"When multiple crate nodes are listed in the connection string, only one is actually used","user":{"login":"reversefold","id":100180,"avatar_url":"https://avatars.githubusercontent.com/u/100180?v=3","gravatar_id":"","url":"https://api.github.com/users/reversefold","html_url":"https://github.com/reversefold","followers_url":"https://api.github.com/users/reversefold/followers","following_url":"https://api.github.com/users/reversefold/following{/other_user}","gists_url":"https://api.github.com/users/reversefold/gists{/gist_id}","starred_url":"https://api.github.com/users/reversefold/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/reversefold/subscriptions","organizations_url":"https://api.github.com/users/reversefold/orgs","repos_url":"https://api.github.com/users/reversefold/repos","events_url":"https://api.github.com/users/reversefold/events{/privacy}","received_events_url":"https://api.github.com/users/reversefold/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2015-09-30T15:54:17Z","updated_at":"2015-10-05T18:48:39Z","closed_at":null,"body":"When checking the monitoring for our crate clusters (v0.49.4) I have noticed that only one of the crate nodes listed in the jdbc connection string is actually being utilized. We have nodes which only act as clients (no master and no data) and the heap usage for one of them shows lots of usage and GC and the others show a nearly constant level of usage. I suspect that only the first client listed is used unless it is down, then the next one is used. I would expect the jdbc driver to round-robin in order to spread the load across nodes.\r\n<img width=\"1366\" alt=\"screenshot 2015-09-30 08 54 00\" src=\"https://cloud.githubusercontent.com/assets/100180/10198432/d1cf44da-6750-11e5-99ec-eba374d7319a.png\">\r\n\r\n\r\n<bountysource-plugin>\r\n---\r\nWant to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/27063026-when-multiple-crate-nodes-are-listed-in-the-connection-string-only-one-is-actually-used?utm_campaign=plugin&utm_content=tracker%2F2398677&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F2398677&utm_medium=issues&utm_source=github).\r\n</bountysource-plugin>"},"comment":{"url":"https://api.github.com/repos/crate/crate-jdbc/issues/comments/145629384","html_url":"https://github.com/crate/crate-jdbc/issues/80#issuecomment-145629384","issue_url":"https://api.github.com/repos/crate/crate-jdbc/issues/80","id":145629384,"user":{"login":"jodok","id":158125,"avatar_url":"https://avatars.githubusercontent.com/u/158125?v=3","gravatar_id":"","url":"https://api.github.com/users/jodok","html_url":"https://github.com/jodok","followers_url":"https://api.github.com/users/jodok/followers","following_url":"https://api.github.com/users/jodok/following{/other_user}","gists_url":"https://api.github.com/users/jodok/gists{/gist_id}","starred_url":"https://api.github.com/users/jodok/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jodok/subscriptions","organizations_url":"https://api.github.com/users/jodok/orgs","repos_url":"https://api.github.com/users/jodok/repos","events_url":"https://api.github.com/users/jodok/events{/privacy}","received_events_url":"https://api.github.com/users/jodok/received_events","type":"User","site_admin":false},"created_at":"2015-10-05T18:48:39Z","updated_at":"2015-10-05T18:48:39Z","body":"we were asking for gc on the node that shows that behaviour. and just being curious, if you modify the connection string (e.g. removing that node from the connection string) another machine shows the same behaviour?"}}