{"action":"created","issue":{"url":"https://api.github.com/repos/cakephp/phinx/issues/207","repository_url":"https://api.github.com/repos/cakephp/phinx","labels_url":"https://api.github.com/repos/cakephp/phinx/issues/207/labels{/name}","comments_url":"https://api.github.com/repos/cakephp/phinx/issues/207/comments","events_url":"https://api.github.com/repos/cakephp/phinx/issues/207/events","html_url":"https://github.com/cakephp/phinx/issues/207","id":30543879,"number":207,"title":"Add database locking","user":{"login":"martinssipenko","id":598744,"avatar_url":"https://avatars1.githubusercontent.com/u/598744?v=4","gravatar_id":"","url":"https://api.github.com/users/martinssipenko","html_url":"https://github.com/martinssipenko","followers_url":"https://api.github.com/users/martinssipenko/followers","following_url":"https://api.github.com/users/martinssipenko/following{/other_user}","gists_url":"https://api.github.com/users/martinssipenko/gists{/gist_id}","starred_url":"https://api.github.com/users/martinssipenko/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/martinssipenko/subscriptions","organizations_url":"https://api.github.com/users/martinssipenko/orgs","repos_url":"https://api.github.com/users/martinssipenko/repos","events_url":"https://api.github.com/users/martinssipenko/events{/privacy}","received_events_url":"https://api.github.com/users/martinssipenko/received_events","type":"User","site_admin":false},"labels":[{"id":205574,"url":"https://api.github.com/repos/cakephp/phinx/labels/feature","name":"feature","color":"02e10c","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2014-03-31T19:58:05Z","updated_at":"2018-03-14T14:52:29Z","closed_at":"2014-04-01T09:24:16Z","author_association":"CONTRIBUTOR","body":"Would it be possible to add a database locking feature, so that in case migration is ran from two instances, that share same database, only one process is ran, other should either exit or wait while first one completes.\n\nI image this could be done by locking sql table, but now all database systems will support that. Another option would be to insert some row in migration table before running first migration, and remove after last one is complete, then we could check for existence of this entry, in case two processes are ran at the same time.\n"},"comment":{"url":"https://api.github.com/repos/cakephp/phinx/issues/comments/373049402","html_url":"https://github.com/cakephp/phinx/issues/207#issuecomment-373049402","issue_url":"https://api.github.com/repos/cakephp/phinx/issues/207","id":373049402,"user":{"login":"lgandras","id":746677,"avatar_url":"https://avatars3.githubusercontent.com/u/746677?v=4","gravatar_id":"","url":"https://api.github.com/users/lgandras","html_url":"https://github.com/lgandras","followers_url":"https://api.github.com/users/lgandras/followers","following_url":"https://api.github.com/users/lgandras/following{/other_user}","gists_url":"https://api.github.com/users/lgandras/gists{/gist_id}","starred_url":"https://api.github.com/users/lgandras/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lgandras/subscriptions","organizations_url":"https://api.github.com/users/lgandras/orgs","repos_url":"https://api.github.com/users/lgandras/repos","events_url":"https://api.github.com/users/lgandras/events{/privacy}","received_events_url":"https://api.github.com/users/lgandras/received_events","type":"User","site_admin":false},"created_at":"2018-03-14T14:52:29Z","updated_at":"2018-03-14T14:52:29Z","author_association":"NONE","body":"@robmorgan Hi, a bit late, but did you try with https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html#function_get-lock?"}}
{"actor":{"display_login":"lgandras"}}