{"id":300,"date":"2014-03-27T16:52:51","date_gmt":"2014-03-27T15:52:51","guid":{"rendered":"http:\/\/zsteva.info\/?p=300"},"modified":"2014-03-27T16:52:51","modified_gmt":"2014-03-27T15:52:51","slug":"lvm-snapshot-mysql-data-dir","status":"publish","type":"post","link":"http:\/\/zsteva.info\/blog\/2014\/03\/lvm-snapshot-mysql-data-dir\/","title":{"rendered":"lvm snapshot mysql data dir"},"content":{"rendered":"<pre lang=\"bash\">\r\n#!\/bin\/bash\r\n\r\n(\r\necho \"FLUSH TABLES WITH READ LOCK;\"\r\necho \"\\! lvcreate -L +10G -s -n snap_userdata \/dev\/vol01\/userdata\"\r\necho \"UNLOCK TABLES;\"\r\n) | mysql -u root\r\n\r\nif [ -e \/dev\/vol01\/snap_userdata ]; then\r\n        mount \/dev\/vol01\/snap_userdata \/mnt\/snap_userdata\/\r\nfi\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>#!\/bin\/bash ( echo &#8220;FLUSH TABLES WITH READ LOCK;&#8221; echo &#8220;\\! lvcreate -L +10G -s -n snap_userdata \/dev\/vol01\/userdata&#8221; echo &#8220;UNLOCK TABLES;&#8221; ) | mysql -u root if [ -e \/dev\/vol01\/snap_userdata ]; then mount \/dev\/vol01\/snap_userdata \/mnt\/snap_userdata\/ fi<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[136,119],"tags":[],"_links":{"self":[{"href":"http:\/\/zsteva.info\/blog\/wp-json\/wp\/v2\/posts\/300"}],"collection":[{"href":"http:\/\/zsteva.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/zsteva.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/zsteva.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/zsteva.info\/blog\/wp-json\/wp\/v2\/comments?post=300"}],"version-history":[{"count":8,"href":"http:\/\/zsteva.info\/blog\/wp-json\/wp\/v2\/posts\/300\/revisions"}],"predecessor-version":[{"id":308,"href":"http:\/\/zsteva.info\/blog\/wp-json\/wp\/v2\/posts\/300\/revisions\/308"}],"wp:attachment":[{"href":"http:\/\/zsteva.info\/blog\/wp-json\/wp\/v2\/media?parent=300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zsteva.info\/blog\/wp-json\/wp\/v2\/categories?post=300"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zsteva.info\/blog\/wp-json\/wp\/v2\/tags?post=300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}