{"action":"created","issue":{"url":"https://api.github.com/repos/openaustralia/infrastructure/issues/42","repository_url":"https://api.github.com/repos/openaustralia/infrastructure","labels_url":"https://api.github.com/repos/openaustralia/infrastructure/issues/42/labels{/name}","comments_url":"https://api.github.com/repos/openaustralia/infrastructure/issues/42/comments","events_url":"https://api.github.com/repos/openaustralia/infrastructure/issues/42/events","html_url":"https://github.com/openaustralia/infrastructure/issues/42","id":302035288,"number":42,"title":"Convert openaustralia myisam tables to innodb","user":{"login":"mlandauer","id":2221,"avatar_url":"https://avatars2.githubusercontent.com/u/2221?v=4","gravatar_id":"","url":"https://api.github.com/users/mlandauer","html_url":"https://github.com/mlandauer","followers_url":"https://api.github.com/users/mlandauer/followers","following_url":"https://api.github.com/users/mlandauer/following{/other_user}","gists_url":"https://api.github.com/users/mlandauer/gists{/gist_id}","starred_url":"https://api.github.com/users/mlandauer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mlandauer/subscriptions","organizations_url":"https://api.github.com/users/mlandauer/orgs","repos_url":"https://api.github.com/users/mlandauer/repos","events_url":"https://api.github.com/users/mlandauer/events{/privacy}","received_events_url":"https://api.github.com/users/mlandauer/received_events","type":"User","site_admin":false},"labels":[{"id":824431732,"url":"https://api.github.com/repos/openaustralia/infrastructure/labels/openaustralia","name":"openaustralia","color":"0052cc","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-03-03T21:50:58Z","updated_at":"2018-03-03T21:54:39Z","closed_at":null,"author_association":"OWNER","body":"After migrating to RDS:\r\n> DB Instance main-database contains MyISAM tables that have not been migrated to InnoDB. These \r\n> tables can impact your ability to perform point-in-time restores. Consider converting these tables to \r\n> InnoDB. Please refer to \r\n> http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.BackingUpAndRestoringAmazonRDSInstances.html#Overview.BackupDeviceRestrictions\""},"comment":{"url":"https://api.github.com/repos/openaustralia/infrastructure/issues/comments/370182863","html_url":"https://github.com/openaustralia/infrastructure/issues/42#issuecomment-370182863","issue_url":"https://api.github.com/repos/openaustralia/infrastructure/issues/42","id":370182863,"user":{"login":"mlandauer","id":2221,"avatar_url":"https://avatars2.githubusercontent.com/u/2221?v=4","gravatar_id":"","url":"https://api.github.com/users/mlandauer","html_url":"https://github.com/mlandauer","followers_url":"https://api.github.com/users/mlandauer/followers","following_url":"https://api.github.com/users/mlandauer/following{/other_user}","gists_url":"https://api.github.com/users/mlandauer/gists{/gist_id}","starred_url":"https://api.github.com/users/mlandauer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mlandauer/subscriptions","organizations_url":"https://api.github.com/users/mlandauer/orgs","repos_url":"https://api.github.com/users/mlandauer/repos","events_url":"https://api.github.com/users/mlandauer/events{/privacy}","received_events_url":"https://api.github.com/users/mlandauer/received_events","type":"User","site_admin":false},"created_at":"2018-03-03T21:54:39Z","updated_at":"2018-03-03T21:54:39Z","author_association":"OWNER","body":"In the very short term we should do logical backups (probably by hand). Then when everything is migrated to the new openaustralia server and is confirmed to be good and working we should do a test on staging where we convert all the tables from MyISAM to InnoDB. If that goes well we should do the same in production."}}
{"actor":{"display_login":"mlandauer"}}