{"action":"created","issue":{"url":"https://api.github.com/repos/sidorares/node-mysql2/issues/373","repository_url":"https://api.github.com/repos/sidorares/node-mysql2","labels_url":"https://api.github.com/repos/sidorares/node-mysql2/issues/373/labels{/name}","comments_url":"https://api.github.com/repos/sidorares/node-mysql2/issues/373/comments","events_url":"https://api.github.com/repos/sidorares/node-mysql2/issues/373/events","html_url":"https://github.com/sidorares/node-mysql2/issues/373","id":171182182,"number":373,"title":"How to implement mysql proxy?","user":{"login":"puzrin","id":319465,"avatar_url":"https://avatars.githubusercontent.com/u/319465?v=3","gravatar_id":"","url":"https://api.github.com/users/puzrin","html_url":"https://github.com/puzrin","followers_url":"https://api.github.com/users/puzrin/followers","following_url":"https://api.github.com/users/puzrin/following{/other_user}","gists_url":"https://api.github.com/users/puzrin/gists{/gist_id}","starred_url":"https://api.github.com/users/puzrin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/puzrin/subscriptions","organizations_url":"https://api.github.com/users/puzrin/orgs","repos_url":"https://api.github.com/users/puzrin/repos","events_url":"https://api.github.com/users/puzrin/events{/privacy}","received_events_url":"https://api.github.com/users/puzrin/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/sidorares/node-mysql2/labels/question","name":"question","color":"cc317c"}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2016-08-15T14:32:30Z","updated_at":"2016-08-17T13:02:21Z","closed_at":"2016-08-16T00:45:40Z","body":"This is not a feature request, just a question. I have [sphinxsearch](https://github.com/sphinxsearch/sphinx) with sql interface, and need to do transparent search index rebuild on configs change. Idea is to create second daemon  for pushing new data, but use old one for search request until reindexing complete. Then reroute all \"read\" requests to new daemon.\r\n\r\nAs far as i understand, it would be convenient to have proxy, that can properly route sql requests and hide details from application.\r\n\r\nIs it possible to do something like this with `mysql2`? I mean, it would be nice to serialize sql requests to some intermediate format (~ like AST in DOM) instead of binary protocol. Or can such task (proxy with intelligent routing) be implemented with different approach?"},"comment":{"url":"https://api.github.com/repos/sidorares/node-mysql2/issues/comments/240403863","html_url":"https://github.com/sidorares/node-mysql2/issues/373#issuecomment-240403863","issue_url":"https://api.github.com/repos/sidorares/node-mysql2/issues/373","id":240403863,"user":{"login":"puzrin","id":319465,"avatar_url":"https://avatars.githubusercontent.com/u/319465?v=3","gravatar_id":"","url":"https://api.github.com/users/puzrin","html_url":"https://github.com/puzrin","followers_url":"https://api.github.com/users/puzrin/followers","following_url":"https://api.github.com/users/puzrin/following{/other_user}","gists_url":"https://api.github.com/users/puzrin/gists{/gist_id}","starred_url":"https://api.github.com/users/puzrin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/puzrin/subscriptions","organizations_url":"https://api.github.com/users/puzrin/orgs","repos_url":"https://api.github.com/users/puzrin/repos","events_url":"https://api.github.com/users/puzrin/events{/privacy}","received_events_url":"https://api.github.com/users/puzrin/received_events","type":"User","site_admin":false},"created_at":"2016-08-17T13:02:21Z","updated_at":"2016-08-17T13:02:21Z","body":"One more quick question - how stable is `mysql2` 1.0.0 RC11 for production? It would be interesting to migrate `mysql` -> `mysql2`. I've checked \"known issues\" in doc and ticket about encoding. Anything else i should know?"}}
{"actor":{"display_login":"puzrin"}}