{"action":"created","issue":{"url":"https://api.github.com/repos/twindb/proxysql-tools/issues/31","repository_url":"https://api.github.com/repos/twindb/proxysql-tools","labels_url":"https://api.github.com/repos/twindb/proxysql-tools/issues/31/labels{/name}","comments_url":"https://api.github.com/repos/twindb/proxysql-tools/issues/31/comments","events_url":"https://api.github.com/repos/twindb/proxysql-tools/issues/31/events","html_url":"https://github.com/twindb/proxysql-tools/issues/31","id":238028151,"number":31,"title":"make a donor node available during SST if there are no other nodes.","user":{"login":"akuzminsky","id":1763754,"avatar_url":"https://avatars2.githubusercontent.com/u/1763754?v=4","gravatar_id":"","url":"https://api.github.com/users/akuzminsky","html_url":"https://github.com/akuzminsky","followers_url":"https://api.github.com/users/akuzminsky/followers","following_url":"https://api.github.com/users/akuzminsky/following{/other_user}","gists_url":"https://api.github.com/users/akuzminsky/gists{/gist_id}","starred_url":"https://api.github.com/users/akuzminsky/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/akuzminsky/subscriptions","organizations_url":"https://api.github.com/users/akuzminsky/orgs","repos_url":"https://api.github.com/users/akuzminsky/repos","events_url":"https://api.github.com/users/akuzminsky/events{/privacy}","received_events_url":"https://api.github.com/users/akuzminsky/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"mkryva","id":22367860,"avatar_url":"https://avatars0.githubusercontent.com/u/22367860?v=4","gravatar_id":"","url":"https://api.github.com/users/mkryva","html_url":"https://github.com/mkryva","followers_url":"https://api.github.com/users/mkryva/followers","following_url":"https://api.github.com/users/mkryva/following{/other_user}","gists_url":"https://api.github.com/users/mkryva/gists{/gist_id}","starred_url":"https://api.github.com/users/mkryva/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mkryva/subscriptions","organizations_url":"https://api.github.com/users/mkryva/orgs","repos_url":"https://api.github.com/users/mkryva/repos","events_url":"https://api.github.com/users/mkryva/events{/privacy}","received_events_url":"https://api.github.com/users/mkryva/received_events","type":"User","site_admin":false},"assignees":[{"login":"mkryva","id":22367860,"avatar_url":"https://avatars0.githubusercontent.com/u/22367860?v=4","gravatar_id":"","url":"https://api.github.com/users/mkryva","html_url":"https://github.com/mkryva","followers_url":"https://api.github.com/users/mkryva/followers","following_url":"https://api.github.com/users/mkryva/following{/other_user}","gists_url":"https://api.github.com/users/mkryva/gists{/gist_id}","starred_url":"https://api.github.com/users/mkryva/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mkryva/subscriptions","organizations_url":"https://api.github.com/users/mkryva/orgs","repos_url":"https://api.github.com/users/mkryva/repos","events_url":"https://api.github.com/users/mkryva/events{/privacy}","received_events_url":"https://api.github.com/users/mkryva/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2017-06-23T03:02:38Z","updated_at":"2017-08-24T12:20:47Z","closed_at":null,"body":"* ProxySQL Tools version: 0.3.4\r\n* Python version: Python 2.7.5\r\n\r\n### Description\r\n\r\nIf only one node available it becomes `OFFLINE_SOFT` when the second node triggers SST.\r\nIn this case the first node should be still available.\r\n\r\n### What I Did\r\n\r\nTwo nodes out of three are down. When starting a second node the donor becomes `OFFLINE_SOFT` and doesn't server incoming requests.\r\n```\r\nmysql> select * from mysql_servers\\G\r\n*************************** 1. row ***************************\r\n       hostgroup_id: 10\r\n           hostname: a.b.c.d\r\n               port: 3306\r\n             status: OFFLINE_SOFT\r\n             weight: 1\r\n        compression: 0\r\n    max_connections: 10000\r\nmax_replication_lag: 0\r\n            use_ssl: 0\r\n     max_latency_ms: 0\r\n            comment: Writer\r\n*************************** 3. row ***************************\r\n       hostgroup_id: 11\r\n           hostname: a.b.c.d\r\n               port: 3306\r\n             status: OFFLINE_SOFT\r\n             weight: 1\r\n        compression: 0\r\n    max_connections: 10000\r\nmax_replication_lag: 0\r\n            use_ssl: 0\r\n     max_latency_ms: 0\r\n            comment: Reader\r\n3 rows in set (0.00 sec)\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/twindb/proxysql-tools/issues/comments/324619203","html_url":"https://github.com/twindb/proxysql-tools/issues/31#issuecomment-324619203","issue_url":"https://api.github.com/repos/twindb/proxysql-tools/issues/31","id":324619203,"user":{"login":"mkryva","id":22367860,"avatar_url":"https://avatars0.githubusercontent.com/u/22367860?v=4","gravatar_id":"","url":"https://api.github.com/users/mkryva","html_url":"https://github.com/mkryva","followers_url":"https://api.github.com/users/mkryva/followers","following_url":"https://api.github.com/users/mkryva/following{/other_user}","gists_url":"https://api.github.com/users/mkryva/gists{/gist_id}","starred_url":"https://api.github.com/users/mkryva/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mkryva/subscriptions","organizations_url":"https://api.github.com/users/mkryva/orgs","repos_url":"https://api.github.com/users/mkryva/repos","events_url":"https://api.github.com/users/mkryva/events{/privacy}","received_events_url":"https://api.github.com/users/mkryva/received_events","type":"User","site_admin":false},"created_at":"2017-08-24T12:20:47Z","updated_at":"2017-08-24T12:20:47Z","body":"https://github.com/twindb/proxysql-tools/pull/53"}}
{"actor":{"display_login":"mkryva"}}