{"version":"1.0","provider_name":"Jui-Nan Lin&#039;s Blog","provider_url":"https:\/\/jnlin.org","author_name":"jnlin","author_url":"https:\/\/jnlin.org\/author\/jnlin\/","title":"MySQL (MyISAM) \u7684\u5099\u4efd","html":"<p>\u7576\u7cfb\u7d71\u5c0f\u7684\u6642\u5019\uff0c\u7528 mysqldump \u5728\u96e2\u5cf0\u6642\u9593\u628a\u8cc7\u6599 dump \u51fa\u4f86\u9084\u7b97\u53ef\u884c\u3002<br \/>\u96d6\u7136 Table \u6703\u66ab\u6642 Lock \u4f4f\uff0c\u4f46\u662f\u56e0\u70ba\u5c0f\uff0c\u6240\u4ee5\u901f\u5ea6\u53ef\u4ee5\u5f88\u5feb\uff0c\u9396\u4f4f\u7684\u6642\u9593\u53ef\u4ee5\u4e0d\u8a08\u3002<br \/>\u4f46\u7576\u7cfb\u7d71\u5927\u7684\u6642\u5019\u5c31\u4e0d\u80fd\u9019\u6a23\u505a\u4e86\u3002<\/p> <p>\u597d\u5728\u5df2\u7d93\u6709\u8a31\u591a\u8655\u7406\u9019\u500b\u554f\u984c\u7684\u7d93\u9a57\u8005\u3002<br \/>\u89e3\u6c7a\u9019\u500b\u554f\u984c\u7684 Key Point \u662f\u300c\u6e1b\u5c11\u9396 Table \u7684\u6642\u9593\u300d\uff0c\u56e0\u6b64\u5982\u679c\u63a1\u7528\u7684 File System \u6216\u662f Volume Manager \u6709\u652f\u63f4\u5feb\u901f\u7684 snapshot \u529f\u80fd\u7684\u8a71\uff0c\u6574\u500b\u554f\u984c\u5c31\u7c21\u55ae\u5f88\u591a\u3002\u6b65\u9a5f\u5982\u4ee5\u4e0b\u6240\u793a\uff1a<\/p> <ol> <li>SLAVE STOP;<\/li> <li>FLUSH TABLE WITH READ LOCK;<\/li> <li>\u4f5c snapshot <\/li> <li>UNLOCK TABLES;<\/li> <li>SLAVE START;<\/li><\/ol> <p>\u5982\u679c\u63a1\u7528 LVM (Linux), ZFS (FreeBSD, Solaris) \u6216\u662f NetApp \u7684\u8a71\uff0c\u6574\u500b\u5099\u4efd\u904e\u7a0b\u53ef\u4ee5\u5c0f\u65bc 5 \u79d2\u9418\uff0c\u56e0\u6b64\u53ef\u4ee5\u505a\u5230\u6bcf\u500b\u5c0f\u6642\u5099\u4efd\u4e00\u6b21\u800c\u4e0d\u5f71\u97ff\u6b63\u5e38\u4f7f\u7528\u3002\u5982\u679c\u5728 Slave \u4e0a\u505a snapshot \u5099\u4efd\uff0c\u5247\u5b8c\u5168\u4e0d\u6703\u5f71\u97ff\u5230\u5beb\u5165\uff08READ LOCK\u6642\u9084\u662f\u53ef\u4ee5\u8b80\uff09\u3002<\/p>","type":"rich"}