{"action":"opened","issue":{"url":"https://api.github.com/repos/adelaideecoinformatics/aekos-api/issues/35","repository_url":"https://api.github.com/repos/adelaideecoinformatics/aekos-api","labels_url":"https://api.github.com/repos/adelaideecoinformatics/aekos-api/issues/35/labels{/name}","comments_url":"https://api.github.com/repos/adelaideecoinformatics/aekos-api/issues/35/comments","events_url":"https://api.github.com/repos/adelaideecoinformatics/aekos-api/issues/35/events","html_url":"https://github.com/adelaideecoinformatics/aekos-api/issues/35","id":179953346,"number":35,"title":"Backup metrics and auth DBs","user":{"login":"tomsaleeba","id":1773838,"avatar_url":"https://avatars.githubusercontent.com/u/1773838?v=3","gravatar_id":"","url":"https://api.github.com/users/tomsaleeba","html_url":"https://github.com/tomsaleeba","followers_url":"https://api.github.com/users/tomsaleeba/followers","following_url":"https://api.github.com/users/tomsaleeba/following{/other_user}","gists_url":"https://api.github.com/users/tomsaleeba/gists{/gist_id}","starred_url":"https://api.github.com/users/tomsaleeba/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tomsaleeba/subscriptions","organizations_url":"https://api.github.com/users/tomsaleeba/orgs","repos_url":"https://api.github.com/users/tomsaleeba/repos","events_url":"https://api.github.com/users/tomsaleeba/events{/privacy}","received_events_url":"https://api.github.com/users/tomsaleeba/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"tomsaleeba","id":1773838,"avatar_url":"https://avatars.githubusercontent.com/u/1773838?v=3","gravatar_id":"","url":"https://api.github.com/users/tomsaleeba","html_url":"https://github.com/tomsaleeba","followers_url":"https://api.github.com/users/tomsaleeba/followers","following_url":"https://api.github.com/users/tomsaleeba/following{/other_user}","gists_url":"https://api.github.com/users/tomsaleeba/gists{/gist_id}","starred_url":"https://api.github.com/users/tomsaleeba/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tomsaleeba/subscriptions","organizations_url":"https://api.github.com/users/tomsaleeba/orgs","repos_url":"https://api.github.com/users/tomsaleeba/repos","events_url":"https://api.github.com/users/tomsaleeba/events{/privacy}","received_events_url":"https://api.github.com/users/tomsaleeba/received_events","type":"User","site_admin":false},"assignees":[{"login":"tomsaleeba","id":1773838,"avatar_url":"https://avatars.githubusercontent.com/u/1773838?v=3","gravatar_id":"","url":"https://api.github.com/users/tomsaleeba","html_url":"https://github.com/tomsaleeba","followers_url":"https://api.github.com/users/tomsaleeba/followers","following_url":"https://api.github.com/users/tomsaleeba/following{/other_user}","gists_url":"https://api.github.com/users/tomsaleeba/gists{/gist_id}","starred_url":"https://api.github.com/users/tomsaleeba/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tomsaleeba/subscriptions","organizations_url":"https://api.github.com/users/tomsaleeba/orgs","repos_url":"https://api.github.com/users/tomsaleeba/repos","events_url":"https://api.github.com/users/tomsaleeba/events{/privacy}","received_events_url":"https://api.github.com/users/tomsaleeba/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2016-09-29T05:02:57Z","updated_at":"2016-09-29T05:02:57Z","closed_at":null,"body":"Steps:\r\n-destroy the prod instance without saving anything\r\n\r\nExpected behaviour:\r\nWe have (recent) a backup of the metrics and auth DBs that we can use to create a new instance.\r\n\r\nActual behaviour:\r\nWe have nothing :cry: \r\n\r\nNotes:\r\nIn yesterday's power outage, my local metrics DB got destroyed. I've wrapped writing to it in transactions but still, I can't read that DB any more. The easiest way to do the backup would be to tar the dir, encrypt and push to swift. We could consider dumping to a turtle file and pushing that, which gives us better portability but with more complexity. The problem with the dump approach is that you can only access the TDB instance with one VM so we'll have to make something inside the API that makes periodic dumps."}}
{"actor":{"display_login":"tomsaleeba"}}