ãã¹ã¿ã¼ãµã¼ãã®è¨å® â ã¬ããªã±ã¼ã·ã§ã³ç¨ã¦ã¼ã¶ã®ä½æ GRANT REPLICATION SLAVE ON *.* to âreplicationâ@â10.10.0.20â IDENTIFIED BY âreplicationâ; â¡my.cnfã®è¨å® [mysqld] # ãã¤ããªãã°ãåºåãã log-bin # èå¥ç¨IDã server-id=10 ã¹ã¬ã¼ããµã¼ãã®è¨å® â my.cnfã®è¨å® server-id=20 ãã¼ã¿ç§»è¡ ï¼ ã¬ããªã±ã¼ã·ã§ã³è¨å® â ãã¹ã¿ã¼ãµã¼ãã«å¯¾ãã¦æ´æ°ãããããªãããã«ããã¯ãããã¾ã mysql > FLUSH TABLES WITH READ LOCK; â¡ãã¹ã¿ã¼ãµã¼ãã®ãã¼ã¿ãã¹ã¬ã¼ããµã¼ãã«ã³ãã¼ãã ã»/var/lib/mysqlé ä¸ã®ãã¼ã¿ãã¡ã¤ã«ãã³ãã¼ãã¾ã â¢ãã¹ã¿ã¼ãµã¼ãã®ãã¤ããªãã°ã®ç¶æ ã確èªãã¾ã mysql > SH
{{#tags}}- {{label}}
{{/tags}}