{"action":"closed","issue":{"url":"https://api.github.com/repos/felixge/node-mysql/issues/1344","repository_url":"https://api.github.com/repos/felixge/node-mysql","labels_url":"https://api.github.com/repos/felixge/node-mysql/issues/1344/labels{/name}","comments_url":"https://api.github.com/repos/felixge/node-mysql/issues/1344/comments","events_url":"https://api.github.com/repos/felixge/node-mysql/issues/1344/events","html_url":"https://github.com/felixge/node-mysql/issues/1344","id":131820009,"number":1344,"title":"Fallback when mysql goes down","user":{"login":"astutesoftware","id":5484181,"avatar_url":"https://avatars.githubusercontent.com/u/5484181?v=3","gravatar_id":"","url":"https://api.github.com/users/astutesoftware","html_url":"https://github.com/astutesoftware","followers_url":"https://api.github.com/users/astutesoftware/followers","following_url":"https://api.github.com/users/astutesoftware/following{/other_user}","gists_url":"https://api.github.com/users/astutesoftware/gists{/gist_id}","starred_url":"https://api.github.com/users/astutesoftware/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/astutesoftware/subscriptions","organizations_url":"https://api.github.com/users/astutesoftware/orgs","repos_url":"https://api.github.com/users/astutesoftware/repos","events_url":"https://api.github.com/users/astutesoftware/events{/privacy}","received_events_url":"https://api.github.com/users/astutesoftware/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/felixge/node-mysql/labels/question","name":"question","color":"d4c5f9"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-02-06T05:01:10Z","updated_at":"2016-02-18T22:07:39Z","closed_at":"2016-02-18T22:07:39Z","body":"Has anyone figured out a logic that takes care of operations when MYSQL goes down.\r\nIdeally if mysql is not available and we have data, we would write to a log file and then when mysql is available we would push things from the log file back to the database.\r\nWhat would be the right way to do it?\r\nIf we write to a log file with all the queries and when mysql connection is restored - how do we remove the entries from the log file which got successfully fired?"}}