{"action":"created","issue":{"url":"https://api.github.com/repos/drud/mariadb-local/issues/42","repository_url":"https://api.github.com/repos/drud/mariadb-local","labels_url":"https://api.github.com/repos/drud/mariadb-local/issues/42/labels{/name}","comments_url":"https://api.github.com/repos/drud/mariadb-local/issues/42/comments","events_url":"https://api.github.com/repos/drud/mariadb-local/issues/42/events","html_url":"https://github.com/drud/mariadb-local/pull/42","id":300842826,"number":42,"title":"Build mariadb starter database from tarball instead of manually, fixes #39, fixes #41","user":{"login":"rfay","id":112444,"avatar_url":"https://avatars2.githubusercontent.com/u/112444?v=4","gravatar_id":"","url":"https://api.github.com/users/rfay","html_url":"https://github.com/rfay","followers_url":"https://api.github.com/users/rfay/followers","following_url":"https://api.github.com/users/rfay/following{/other_user}","gists_url":"https://api.github.com/users/rfay/gists{/gist_id}","starred_url":"https://api.github.com/users/rfay/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rfay/subscriptions","organizations_url":"https://api.github.com/users/rfay/orgs","repos_url":"https://api.github.com/users/rfay/repos","events_url":"https://api.github.com/users/rfay/events{/privacy}","received_events_url":"https://api.github.com/users/rfay/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"rfay","id":112444,"avatar_url":"https://avatars2.githubusercontent.com/u/112444?v=4","gravatar_id":"","url":"https://api.github.com/users/rfay","html_url":"https://github.com/rfay","followers_url":"https://api.github.com/users/rfay/followers","following_url":"https://api.github.com/users/rfay/following{/other_user}","gists_url":"https://api.github.com/users/rfay/gists{/gist_id}","starred_url":"https://api.github.com/users/rfay/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rfay/subscriptions","organizations_url":"https://api.github.com/users/rfay/orgs","repos_url":"https://api.github.com/users/rfay/repos","events_url":"https://api.github.com/users/rfay/events{/privacy}","received_events_url":"https://api.github.com/users/rfay/received_events","type":"User","site_admin":false},"assignees":[{"login":"rfay","id":112444,"avatar_url":"https://avatars2.githubusercontent.com/u/112444?v=4","gravatar_id":"","url":"https://api.github.com/users/rfay","html_url":"https://github.com/rfay","followers_url":"https://api.github.com/users/rfay/followers","following_url":"https://api.github.com/users/rfay/following{/other_user}","gists_url":"https://api.github.com/users/rfay/gists{/gist_id}","starred_url":"https://api.github.com/users/rfay/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rfay/subscriptions","organizations_url":"https://api.github.com/users/rfay/orgs","repos_url":"https://api.github.com/users/rfay/repos","events_url":"https://api.github.com/users/rfay/events{/privacy}","received_events_url":"https://api.github.com/users/rfay/received_events","type":"User","site_admin":false}],"milestone":null,"comments":1,"created_at":"2018-02-28T00:13:35Z","updated_at":"2018-03-02T20:27:23Z","closed_at":null,"author_association":"OWNER","pull_request":{"url":"https://api.github.com/repos/drud/mariadb-local/pulls/42","html_url":"https://github.com/drud/mariadb-local/pull/42","diff_url":"https://github.com/drud/mariadb-local/pull/42.diff","patch_url":"https://github.com/drud/mariadb-local/pull/42.patch"},"body":"## The Problem:\r\n\r\nThe ddev database container was taking 30 seconds and even more to come up, due to static same-every-time initialization procedures. \r\n\r\n## The Fix:\r\n\r\n* Capture the built database files and just untar them, since the procedure was the same every time.\r\n* Provide a script (create_base_db.sh) and README to explain how to change the tarball when needed in the future.\r\n\r\nThis significantly simplifies the startup script.\r\n\r\nThis reduces initial ddev startup time on a newly-configured project from 26 seconds to 11 seconds on my 2013 Macbook Air.\r\n\r\n## The Test:\r\n\r\nUse this with ddev.  All you have to do is update .ddev/config.yaml with\r\n`dbimage: drud/mariadb-local:20180227_load_db_to_start`\r\nand `ddev start`.\r\n\r\nIt doesn't make a difference on an existing project, so try it on both existing and new projects.\r\n\r\nYou can try this out with https://github.com/drud/ddev/pull/690, but remember that you have to comment out the dbimage line in .ddev/config.yaml (or delete the config.yaml)\r\n\r\n## Automation Overview:\r\n<!-- Please provide an overview of tests introduced by this PR, or an explanation for why no tests are needed. -->\r\n\r\n## Related Issue Link(s):\r\n\r\nOP #39\r\nAlso fixes #41 with README update.\r\n\r\n## Release/Deployment notes:\r\n<!-- Does this affect anything else, or are there ramifications for other code? Does anything have to be done on deployment? -->\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/drud/mariadb-local/issues/comments/370042955","html_url":"https://github.com/drud/mariadb-local/pull/42#issuecomment-370042955","issue_url":"https://api.github.com/repos/drud/mariadb-local/issues/42","id":370042955,"user":{"login":"rfay","id":112444,"avatar_url":"https://avatars2.githubusercontent.com/u/112444?v=4","gravatar_id":"","url":"https://api.github.com/users/rfay","html_url":"https://github.com/rfay","followers_url":"https://api.github.com/users/rfay/followers","following_url":"https://api.github.com/users/rfay/following{/other_user}","gists_url":"https://api.github.com/users/rfay/gists{/gist_id}","starred_url":"https://api.github.com/users/rfay/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rfay/subscriptions","organizations_url":"https://api.github.com/users/rfay/orgs","repos_url":"https://api.github.com/users/rfay/repos","events_url":"https://api.github.com/users/rfay/events{/privacy}","received_events_url":"https://api.github.com/users/rfay/received_events","type":"User","site_admin":false},"created_at":"2018-03-02T20:27:23Z","updated_at":"2018-03-02T20:27:23Z","author_association":"OWNER","body":"I'm very excited about this one, but very reluctant to pull it without technical review. @tannerjfco you have loads of history with this container, and I'd love it if you could see if you can give the go-ahead. It reduces complexity yet again."}}
{"actor":{"display_login":"rfay"}}