{"id":40192,"date":"2025-05-28T09:07:56","date_gmt":"2025-05-28T01:07:56","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/40192.html"},"modified":"2025-05-28T09:07:56","modified_gmt":"2025-05-28T01:07:56","slug":"vmware-mysql%e4%b8%bb%e4%bb%8e","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/40192.html","title":{"rendered":"VMware-MySQL\u4e3b\u4ece"},"content":{"rendered":"<h2>MySQL\u4e3b\u4ece<\/h2>\n<h3>\u670d\u52a1\u5668\u4fe1\u606f<\/h3>\n<table>\n<tr>\u670d\u52a1\u5668\u7c7b\u578b\u89d2\u8272\u4e3b\u673a\u5730\u5740\u4e3b\u673a\u540d\u79f0<\/tr>\n<tbody>\n<tr>\n<td>\u865a\u62df\u673a<\/td>\n<td>master<\/td>\n<td>192.168.40.128<\/td>\n<td>test-1<\/td>\n<\/tr>\n<tr>\n<td>\u865a\u62df\u673a<\/td>\n<td>slave<\/td>\n<td>192.168.40.129<\/td>\n<td>test-2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Master \u914d\u7f6e&#xff08;192.168.40.128&#xff09;<\/h3>\n<h4>\u5220\u9664\u81ea\u52a8\u751f\u6210\u7684\u914d\u7f6e<\/h4>\n<p>\/var\/lib\/mysql\/auto.cnf<\/p>\n<p><span class=\"token punctuation\">[<\/span>root&#064;test-1 ~<span class=\"token punctuation\">]<\/span><span class=\"token comment\"># rm -rf  \/var\/lib\/mysql\/auto.cnf<\/span><br \/>\n<span class=\"token punctuation\">[<\/span>root&#064;test-1 ~<span class=\"token punctuation\">]<\/span><span class=\"token comment\">#<\/span><\/p>\n<h4>\u4e3b\u5e93\u914d\u7f6e<\/h4>\n<p>\/etc\/my.cnf<\/p>\n<p><span class=\"token punctuation\">[<\/span>root&#064;test-1 ~<span class=\"token punctuation\">]<\/span><span class=\"token comment\"># cat \/etc\/my.cnf<\/span><br \/>\n<span class=\"token comment\"># For advice on how to change settings please see<\/span><br \/>\n<span class=\"token comment\"># http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/server-configuration-defaults.html<\/span><\/p>\n<p><span class=\"token punctuation\">[<\/span>mysqld<span class=\"token punctuation\">]<\/span><br \/>\n<span class=\"token comment\">#<\/span><br \/>\n<span class=\"token comment\"># Remove leading # and set to the amount of RAM for the most important data<\/span><br \/>\n<span class=\"token comment\"># cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.<\/span><br \/>\n<span class=\"token comment\"># innodb_buffer_pool_size &#061; 128M<\/span><br \/>\n<span class=\"token comment\">#<\/span><br \/>\n<span class=\"token comment\"># Remove leading # to turn on a very important data integrity option: logging<\/span><br \/>\n<span class=\"token comment\"># changes to the binary log between backups.<\/span><br \/>\n<span class=\"token comment\"># log_bin<\/span><br \/>\n<span class=\"token comment\">#<\/span><br \/>\n<span class=\"token comment\"># Remove leading # to set options mainly useful for reporting servers.<\/span><br \/>\n<span class=\"token comment\"># The server defaults are faster for transactions and fast SELECTs.<\/span><br \/>\n<span class=\"token comment\"># Adjust sizes as needed, experiment to find the optimal values.<\/span><br \/>\n<span class=\"token comment\"># join_buffer_size &#061; 128M<\/span><br \/>\n<span class=\"token comment\"># sort_buffer_size &#061; 2M<\/span><br \/>\n<span class=\"token comment\"># read_rnd_buffer_size &#061; 2M<\/span><br \/>\n<span class=\"token assign-left variable\">datadir<\/span><span class=\"token operator\">&#061;<\/span>\/var\/lib\/mysql<br \/>\n<span class=\"token assign-left variable\">socket<\/span><span class=\"token operator\">&#061;<\/span>\/var\/lib\/mysql\/mysql.sock<\/p>\n<p><span class=\"token comment\"># Disabling symbolic-links is recommended to prevent assorted security risks<\/span><br \/>\nsymbolic-links<span class=\"token operator\">&#061;<\/span><span class=\"token number\">0<\/span><\/p>\n<p>log-error<span class=\"token operator\">&#061;<\/span>\/var\/log\/mysqld.log<br \/>\npid-file<span class=\"token operator\">&#061;<\/span>\/var\/run\/mysqld\/mysqld.pid<\/p>\n<p><span class=\"token comment\"># \u4e3b\u4ece\u914d\u7f6e<\/span><br \/>\n<span class=\"token comment\"># \u4e3b\u5e93\u548c\u4ece\u5e93\u9700\u8981\u4e0d\u4e00\u81f4&#xff0c;\u5206\u522b\u914d\u4e00\u4e2a\u552f\u4e00\u7684ID\u7f16\u53f7<\/span><br \/>\nserver_id <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span><br \/>\n<span class=\"token comment\"># \u4e8c\u8fdb\u5236\u6587\u4ef6\u5b58\u653e\u8def\u5f84,\u5b58\u653e\u5728\u6839\u76ee\u5f55data\u6587\u4ef6\u5939\u4e0b<\/span><br \/>\n<span class=\"token assign-left variable\">log_bin<\/span><span class=\"token operator\">&#061;<\/span>master-bin<br \/>\n<span class=\"token comment\"># \u8bbe\u7f6e\u9700\u8981\u540c\u6b65\u7684\u6570\u636e\u5e93<\/span><br \/>\n<span class=\"token assign-left variable\">binlog_do_db<\/span><span class=\"token operator\">&#061;<\/span>db_demo<br \/>\n<span class=\"token comment\"># \u5ffd\u7565\u7cfb\u7edf\u5e93\u540c\u6b65<\/span><br \/>\n<span class=\"token assign-left variable\">binlog_ignore_db<\/span><span class=\"token operator\">&#061;<\/span>mysql<br \/>\n<span class=\"token assign-left variable\">binlog_ignore_db<\/span><span class=\"token operator\">&#061;<\/span>information_schema<br \/>\n<span class=\"token assign-left variable\">binlog_ignore_db<\/span><span class=\"token operator\">&#061;<\/span>performance_schema<br \/>\n<span class=\"token punctuation\">[<\/span>root&#064;test-1 ~<span class=\"token punctuation\">]<\/span><span class=\"token comment\"># <\/span><\/p>\n<h4>\u91cd\u542fMySQL\u670d\u52a1<\/h4>\n<p><span class=\"token punctuation\">[<\/span>root&#064;test-1 ~<span class=\"token punctuation\">]<\/span><span class=\"token comment\"># systemctl restart mysqld<\/span><br \/>\n<span class=\"token punctuation\">[<\/span>root&#064;test-1 ~<span class=\"token punctuation\">]<\/span><span class=\"token comment\"># <\/span><br \/>\n<span class=\"token punctuation\">[<\/span>root&#064;test-1 ~<span class=\"token punctuation\">]<\/span><span class=\"token comment\"># systemctl status mysqld<\/span><br \/>\n\u25cf mysqld.service &#8211; MySQL Server<br \/>\n   Loaded: loaded <span class=\"token punctuation\">(<\/span>\/usr\/lib\/systemd\/system\/mysqld.service<span class=\"token punctuation\">;<\/span> enabled<span class=\"token punctuation\">;<\/span> vendor preset: disabled<span class=\"token punctuation\">)<\/span><br \/>\n   Active: active <span class=\"token punctuation\">(<\/span>running<span class=\"token punctuation\">)<\/span> since \u4e8c <span class=\"token number\">2025<\/span>-05-27 <span class=\"token number\">16<\/span>:49:40 CST<span class=\"token punctuation\">;<\/span> 11s ago<br \/>\n     Docs: man:mysqld<span class=\"token punctuation\">(<\/span><span class=\"token number\">8<\/span><span class=\"token punctuation\">)<\/span><br \/>\n           http:\/\/dev.mysql.com\/doc\/refman\/en\/using-systemd.html<br \/>\n  Process: <span class=\"token number\">3279<\/span> <span class=\"token assign-left variable\">ExecStart<\/span><span class=\"token operator\">&#061;<\/span>\/usr\/sbin\/mysqld <span class=\"token parameter variable\">&#8211;daemonize<\/span> &#8211;pid-file<span class=\"token operator\">&#061;<\/span>\/var\/run\/mysqld\/mysqld.pid <span class=\"token variable\">$MYSQLD_OPTS<\/span> <span class=\"token punctuation\">(<\/span>code<span class=\"token operator\">&#061;<\/span>exited, <span class=\"token assign-left variable\">status<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token number\">0<\/span>\/SUCCESS<span class=\"token punctuation\">)<\/span><br \/>\n  Process: <span class=\"token number\">3258<\/span> <span class=\"token assign-left variable\">ExecStartPre<\/span><span class=\"token operator\">&#061;<\/span>\/usr\/bin\/mysqld_pre_systemd <span class=\"token punctuation\">(<\/span>code<span class=\"token operator\">&#061;<\/span>exited, <span class=\"token assign-left variable\">status<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token number\">0<\/span>\/SUCCESS<span class=\"token punctuation\">)<\/span><br \/>\n Main PID: <span class=\"token number\">3282<\/span> <span class=\"token punctuation\">(<\/span>mysqld<span class=\"token punctuation\">)<\/span><br \/>\n   CGroup: \/system.slice\/mysqld.service<br \/>\n           \u2514\u25003282 \/usr\/sbin\/mysqld <span class=\"token parameter variable\">&#8211;daemonize<\/span> &#8211;pid-file<span class=\"token operator\">&#061;<\/span>\/var\/run\/mysqld\/mysqld.pid<\/p>\n<p><span class=\"token number\">5<\/span>\u6708 <span class=\"token number\">27<\/span> <span class=\"token number\">16<\/span>:49:38 test-1 systemd<span class=\"token punctuation\">[<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">]<\/span>: Starting MySQL Server<span class=\"token punctuation\">..<\/span>.<br \/>\n<span class=\"token number\">5<\/span>\u6708 <span class=\"token number\">27<\/span> <span class=\"token number\">16<\/span>:49:40 test-1 systemd<span class=\"token punctuation\">[<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">]<\/span>: Started MySQL Server.<br \/>\n<span class=\"token punctuation\">[<\/span>root&#064;test-1 ~<span class=\"token punctuation\">]<\/span><span class=\"token comment\"># <\/span><\/p>\n<h4>\u6d4b\u8bd5\u662f\u5426\u6b63\u5e38<\/h4>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/05\/20250528010749-683661e5e47cc.jpg\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h3>Slave \u914d\u7f6e&#xff08;192.168.40.129&#xff09;<\/h3>\n<h4>\u5220\u9664\u81ea\u52a8\u751f\u6210\u7684\u914d\u7f6e<\/h4>\n<p>\/var\/lib\/mysql\/auto.cnf<\/p>\n<p><span class=\"token punctuation\">[<\/span>root&#064;test-2 ~<span class=\"token punctuation\">]<\/span><span class=\"token comment\"># rm -rf  \/var\/lib\/mysql\/auto.cnf<\/span><br \/>\n<span class=\"token punctuation\">[<\/span>root&#064;test-2 ~<span class=\"token punctuation\">]<\/span><span class=\"token comment\">#<\/span><\/p>\n<h4>\u4ece\u5e93\u914d\u7f6e<\/h4>\n<p><span class=\"token punctuation\">[<\/span>root&#064;test-2 ~<span class=\"token punctuation\">]<\/span><span class=\"token comment\"># cat \/etc\/my.cnf<\/span><br \/>\n<span class=\"token comment\"># For advice on how to change settings please see<\/span><br \/>\n<span class=\"token comment\"># http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/server-configuration-defaults.html<\/span><\/p>\n<p><span class=\"token punctuation\">[<\/span>mysqld<span class=\"token punctuation\">]<\/span><br \/>\n<span class=\"token comment\">#<\/span><br \/>\n<span class=\"token comment\"># Remove leading # and set to the amount of RAM for the most important data<\/span><br \/>\n<span class=\"token comment\"># cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.<\/span><br \/>\n<span class=\"token comment\"># innodb_buffer_pool_size &#061; 128M<\/span><br \/>\n<span class=\"token comment\">#<\/span><br \/>\n<span class=\"token comment\"># Remove leading # to turn on a very important data integrity option: logging<\/span><br \/>\n<span class=\"token comment\"># changes to the binary log between backups.<\/span><br \/>\n<span class=\"token comment\"># log_bin<\/span><br \/>\n<span class=\"token comment\">#<\/span><br \/>\n<span class=\"token comment\"># Remove leading # to set options mainly useful for reporting servers.<\/span><br \/>\n<span class=\"token comment\"># The server defaults are faster for transactions and fast SELECTs.<\/span><br \/>\n<span class=\"token comment\"># Adjust sizes as needed, experiment to find the optimal values.<\/span><br \/>\n<span class=\"token comment\"># join_buffer_size &#061; 128M<\/span><br \/>\n<span class=\"token comment\"># sort_buffer_size &#061; 2M<\/span><br \/>\n<span class=\"token comment\"># read_rnd_buffer_size &#061; 2M<\/span><br \/>\n<span class=\"token assign-left variable\">datadir<\/span><span class=\"token operator\">&#061;<\/span>\/var\/lib\/mysql<br \/>\n<span class=\"token assign-left variable\">socket<\/span><span class=\"token operator\">&#061;<\/span>\/var\/lib\/mysql\/mysql.sock<\/p>\n<p><span class=\"token comment\"># Disabling symbolic-links is recommended to prevent assorted security risks<\/span><br \/>\nsymbolic-links<span class=\"token operator\">&#061;<\/span><span class=\"token number\">0<\/span><\/p>\n<p>log-error<span class=\"token operator\">&#061;<\/span>\/var\/log\/mysqld.log<br \/>\npid-file<span class=\"token operator\">&#061;<\/span>\/var\/run\/mysqld\/mysqld.pid<\/p>\n<p><span class=\"token comment\"># \u4e3b\u4ece\u914d\u7f6e<\/span><br \/>\n<span class=\"token assign-left variable\">server_id<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token number\">2<\/span><br \/>\n<span class=\"token comment\"># \u4e8c\u8fdb\u5236\u6587\u4ef6\u5b58\u653e\u8def\u5f84,\u5b58\u653e\u5728\u6839\u76ee\u5f55data\u6587\u4ef6\u5939\u4e0b<\/span><br \/>\n<span class=\"token assign-left variable\">log_bin<\/span><span class=\"token operator\">&#061;<\/span>slave-bin<br \/>\n<span class=\"token comment\"># \u8bbe\u7f6e\u9700\u8981\u540c\u6b65\u7684\u6570\u636e\u5e93<\/span><br \/>\n<span class=\"token assign-left variable\">replicate_wild_do_table<\/span><span class=\"token operator\">&#061;<\/span>db_demo.%<br \/>\n<span class=\"token comment\">#\u5c4f\u853d\u7cfb\u7edf\u5e93\u540c\u6b65<\/span><br \/>\n<span class=\"token assign-left variable\">replicate_wild_ignore_table<\/span><span class=\"token operator\">&#061;<\/span>mysql.%<br \/>\n<span class=\"token assign-left variable\">replicate_wild_ignore_table<\/span><span class=\"token operator\">&#061;<\/span>information_schema.%<br \/>\n<span class=\"token assign-left variable\">replicate_wild_ignore_table<\/span><span class=\"token operator\">&#061;<\/span>performance_schema.%<br \/>\n<span class=\"token punctuation\">[<\/span>root&#064;test-2 ~<span class=\"token punctuation\">]<\/span><span class=\"token comment\"># <\/span><\/p>\n<h4>\u91cd\u542fMySQL\u670d\u52a1<\/h4>\n<p><span class=\"token punctuation\">[<\/span>root&#064;test-2 ~<span class=\"token punctuation\">]<\/span><span class=\"token comment\"># systemctl restart mysqld<\/span><br \/>\n<span class=\"token punctuation\">[<\/span>root&#064;test-2 ~<span class=\"token punctuation\">]<\/span><span class=\"token comment\"># <\/span><br \/>\n<span class=\"token punctuation\">[<\/span>root&#064;test-2 ~<span class=\"token punctuation\">]<\/span><span class=\"token comment\"># systemctl status mysqld<\/span><br \/>\n\u25cf mysqld.service &#8211; MySQL Server<br \/>\n   Loaded: loaded <span class=\"token punctuation\">(<\/span>\/usr\/lib\/systemd\/system\/mysqld.service<span class=\"token punctuation\">;<\/span> enabled<span class=\"token punctuation\">;<\/span> vendor preset: disabled<span class=\"token punctuation\">)<\/span><br \/>\n   Active: active <span class=\"token punctuation\">(<\/span>running<span class=\"token punctuation\">)<\/span> since \u4e8c <span class=\"token number\">2025<\/span>-05-27 <span class=\"token number\">17<\/span>:00:52 CST<span class=\"token punctuation\">;<\/span> 7s ago<br \/>\n     Docs: man:mysqld<span class=\"token punctuation\">(<\/span><span class=\"token number\">8<\/span><span class=\"token punctuation\">)<\/span><br \/>\n           http:\/\/dev.mysql.com\/doc\/refman\/en\/using-systemd.html<br \/>\n  Process: <span class=\"token number\">3177<\/span> <span class=\"token assign-left variable\">ExecStart<\/span><span class=\"token operator\">&#061;<\/span>\/usr\/sbin\/mysqld <span class=\"token parameter variable\">&#8211;daemonize<\/span> &#8211;pid-file<span class=\"token operator\">&#061;<\/span>\/var\/run\/mysqld\/mysqld.pid <span class=\"token variable\">$MYSQLD_OPTS<\/span> <span class=\"token punctuation\">(<\/span>code<span class=\"token operator\">&#061;<\/span>exited, <span class=\"token assign-left variable\">status<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token number\">0<\/span>\/SUCCESS<span class=\"token punctuation\">)<\/span><br \/>\n  Process: <span class=\"token number\">3155<\/span> <span class=\"token assign-left variable\">ExecStartPre<\/span><span class=\"token operator\">&#061;<\/span>\/usr\/bin\/mysqld_pre_systemd <span class=\"token punctuation\">(<\/span>code<span class=\"token operator\">&#061;<\/span>exited, <span class=\"token assign-left variable\">status<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token number\">0<\/span>\/SUCCESS<span class=\"token punctuation\">)<\/span><br \/>\n Main PID: <span class=\"token number\">3180<\/span> <span class=\"token punctuation\">(<\/span>mysqld<span class=\"token punctuation\">)<\/span><br \/>\n   CGroup: \/system.slice\/mysqld.service<br \/>\n           \u2514\u25003180 \/usr\/sbin\/mysqld <span class=\"token parameter variable\">&#8211;daemonize<\/span> &#8211;pid-file<span class=\"token operator\">&#061;<\/span>\/var\/run\/mysqld\/mysqld.pid<\/p>\n<p><span class=\"token number\">5<\/span>\u6708 <span class=\"token number\">27<\/span> <span class=\"token number\">17<\/span>:00:49 test-2 systemd<span class=\"token punctuation\">[<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">]<\/span>: Starting MySQL Server<span class=\"token punctuation\">..<\/span>.<br \/>\n<span class=\"token number\">5<\/span>\u6708 <span class=\"token number\">27<\/span> <span class=\"token number\">17<\/span>:00:52 test-2 systemd<span class=\"token punctuation\">[<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">]<\/span>: Started MySQL Server.<br \/>\n<span class=\"token punctuation\">[<\/span>root&#064;test-2 ~<span class=\"token punctuation\">]<\/span><span class=\"token comment\"># <\/span><\/p>\n<h4>\u6d4b\u8bd5\u662f\u5426\u6b63\u5e38<\/h4>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/05\/20250528010750-683661e628bcf.jpg\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h3>\u4e3b\u4ece\u540c\u6b65\u914d\u7f6e<\/h3>\n<h4>\u67e5\u770bMaster\u72b6\u6001<\/h4>\n<p>show master status;<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/05\/20250528010750-683661e670dce.jpg\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h4>\u4e3b\u4ece\u8282\u70b9\u5747\u521b\u5efa\u5e93 db_demo<\/h4>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/05\/20250528010750-683661e6c0ebe.jpg\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h4>\u4ece\u8282\u70b9\u914d\u7f6e\u540c\u6b65\u76f8\u5173\u4fe1\u606f<\/h4>\n<h4>\u505c\u6b62\u4ece\u8282\u70b9<\/h4>\n<p>stop slave;<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/05\/20250528010751-683661e74238d.jpg\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h4>\u914d\u7f6e\u590d\u5236\u4e3b\u673a\u7684\u4fe1\u606f<\/h4>\n<p>change master to<br \/>\n<span class=\"token assign-left variable\">master_host<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#039;192.168.40.128&#039;<\/span>,<br \/>\n<span class=\"token assign-left variable\">master_user<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#039;root&#039;<\/span>,<br \/>\n<span class=\"token assign-left variable\">master_password<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#039;Root&#064;123456&#039;<\/span>,<br \/>\n<span class=\"token assign-left variable\">master_log_file<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#039;master-bin.000001&#039;<\/span>,<br \/>\n<span class=\"token assign-left variable\">master_log_pos<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token number\">154<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/05\/20250528010751-683661e7cc6a3.jpg\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h4>\u542f\u52a8\u4ece\u8282\u70b9<\/h4>\n<p>start slave;<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/05\/20250528010752-683661e83a013.jpg\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h4>\u67e5\u770b\u4ece\u8282\u70b9\u72b6\u6001<\/h4>\n<p>show slave status;<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/05\/20250528010752-683661e8b2968.jpg\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<p>\u8bf4\u660e<\/p>\n<li>Slave_IO_Running \u3001Slave_SQL_Running \u4e3aYES\u5219\u4e3a\u6b63\u5e38<\/li>\n<li>\u82e5\u4e0d\u662f YES&#xff0c;\u5219\u53ef\u67e5\u770b\u4ece\u8282\u70b9\u7684\u6570\u636e\u5e93\u65e5\u5fd7 \/var\/log\/mysqld.log \u8fdb\u884c\u6392\u67e5\u5904\u7406<\/li>\n<h3>\u4e3b\u4ece\u540c\u6b65\u9a8c\u8bc1<\/h3>\n<h4>\u4e3b\u5e93\u521b\u5efa\u8868 student<\/h4>\n<ul>\n<li>\u6570\u636e\u5e93&#xff1a; db_demo<\/li>\n<li>\u8868&#xff1a;student<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/05\/20250528010753-683661e93125d.jpg\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h4>\u67e5\u770b\u4ece\u5e93<\/h4>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/05\/20250528010753-683661e986335.jpg\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h4>\u4e3b\u5e93\u63d2\u5165\u6570\u636e<\/h4>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/05\/20250528010754-683661ea021bc.jpg\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h4>\u4ece\u5e93\u67e5\u770b\u6570\u636e<\/h4>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/05\/20250528010754-683661ea61791.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb238\u6b21\u3002VMware-MySQL\u4e3b\u4ece\u96c6\u7fa4\u914d\u7f6e\u8be6\u89e3\u4ee5\u53ca\u642d\u5efa\u6559\u7a0b<\/p>\n","protected":false},"author":2,"featured_media":40180,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[114,765,3671,3670],"topic":[],"class_list":["post-40192","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-mysql","tag-vmware","tag-3671","tag-3670"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VMware-MySQL\u4e3b\u4ece - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/40192.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VMware-MySQL\u4e3b\u4ece - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb238\u6b21\u3002VMware-MySQL\u4e3b\u4ece\u96c6\u7fa4\u914d\u7f6e\u8be6\u89e3\u4ee5\u53ca\u642d\u5efa\u6559\u7a0b\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/40192.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2025-05-28T01:07:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/05\/20250528010749-683661e5e47cc.jpg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/40192.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/40192.html\",\"name\":\"VMware-MySQL\u4e3b\u4ece - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2025-05-28T01:07:56+00:00\",\"dateModified\":\"2025-05-28T01:07:56+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/40192.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/40192.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/40192.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"VMware-MySQL\u4e3b\u4ece\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VMware-MySQL\u4e3b\u4ece - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/40192.html","og_locale":"zh_CN","og_type":"article","og_title":"VMware-MySQL\u4e3b\u4ece - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb238\u6b21\u3002VMware-MySQL\u4e3b\u4ece\u96c6\u7fa4\u914d\u7f6e\u8be6\u89e3\u4ee5\u53ca\u642d\u5efa\u6559\u7a0b","og_url":"https:\/\/www.wsisp.com\/helps\/40192.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2025-05-28T01:07:56+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/05\/20250528010749-683661e5e47cc.jpg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"3 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/40192.html","url":"https:\/\/www.wsisp.com\/helps\/40192.html","name":"VMware-MySQL\u4e3b\u4ece - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2025-05-28T01:07:56+00:00","dateModified":"2025-05-28T01:07:56+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/40192.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/40192.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/40192.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"VMware-MySQL\u4e3b\u4ece"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/40192","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=40192"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/40192\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/40180"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=40192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=40192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=40192"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=40192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}