{"id":54,"date":"2018-07-13T10:45:40","date_gmt":"2018-07-13T07:45:40","guid":{"rendered":"http:\/\/guwi.ru\/?p=48"},"modified":"2018-07-13T10:45:40","modified_gmt":"2018-07-13T07:45:40","slug":"%d0%ba%d0%b0%d0%ba-%d0%b2%d0%be%d1%81%d1%81%d1%82%d0%b0%d0%bd%d0%be%d0%b2%d0%b8%d1%82%d1%8c-%d1%80%d0%b5%d0%bf%d0%bb%d0%b8%d0%ba%d0%b0%d1%86%d0%b8%d1%8e-mysql-%d0%b8%d0%bb%d0%b8-mariadb","status":"publish","type":"post","link":"http:\/\/guwi.ru\/?p=54","title":{"rendered":"\u041d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0444\u043e\u0440\u043c\u0430\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435!!! \u041a\u0430\u043a \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u044e MySQL \u0438\u043b\u0438 MariaDB"},"content":{"rendered":"<p>\u0415\u0441\u043b\u0438 \u043a\u043b\u0430\u0441\u0442\u0435\u0440 \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u0432 \u0440\u0435\u0436\u0438\u043c\u0435 Master &#8211; Master, \u0441\u043d\u0430\u0447\u0430\u043b\u0430 \u043d\u0430\u0439\u0434\u0435\u043c \u043d\u043e\u0434\u0443, \u043d\u0430 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u043f\u0440\u043e\u0438\u0437\u043e\u0448\u0435\u043b \u0441\u0431\u043e\u0439 \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0438.\u00a0\u0414\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u0437\u0430\u0445\u043e\u0434\u0438\u043c \u043d\u0430 \u043a\u0430\u0436\u0434\u043e\u043c \u0441\u0435\u0440\u0432\u0435\u0440\u0435 \u0432 \u043e\u0431\u043e\u043b\u043e\u0447\u043a\u0443 mysql \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0439 \u043a\u043e\u043c\u0430\u043d\u0434\u043e\u0439:<\/p>\n<div class=\"console\">\n<blockquote><p># mysql -uroot -p<\/p><\/blockquote>\n<\/div>\n<p><em><small>* \u0432 \u0434\u0430\u043d\u043d\u043e\u043c \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u0437\u0430\u0445\u043e\u0434\u0438\u043c \u043e\u0442 \u0438\u043c\u0435\u043d\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f <strong>root<\/strong>.<\/small><\/em><\/p>\n<p>\u0418 \u0432\u044b\u0432\u043e\u0434\u0438\u043c \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u0435 \u043d\u043e\u0434\u044b \u0432 \u0440\u0435\u0436\u0438\u043c\u0435\u00a0Slave:<\/p>\n<div class=\"console\">\n<blockquote><p>mysql&gt;\u00a0SHOW SLAVE STATUS\\G<\/p><\/blockquote>\n<\/div>\n<p>\u0412 \u0441\u043b\u0443\u0447\u0430\u0435 \u043f\u0440\u043e\u0431\u043b\u0435\u043c \u0441 \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0435\u0439 \u043c\u044b \u0443\u0432\u0438\u0434\u0438\u043c\u00a0\u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f\u00a0<strong>Slave_IO_Running<\/strong> \u0438\u00a0<strong>Slave_SQL_Running <\/strong>\u0432 \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u0438 <strong>No<\/strong>, \u0430 \u0442\u0430\u043a\u0436\u0435 \u043e\u043f\u0438\u0441\u0430\u043d\u0438\u0435 \u043e\u0448\u0438\u0431\u043a\u0438:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-50 size-full\" src=\"http:\/\/guwi.ru\/wp-content\/uploads\/2018\/07\/mysql-replication-repair-01.jpg\" alt=\"\" width=\"600\" height=\"249\" \/><\/p>\n<h2>\u041d\u0430 \u0440\u0430\u0431\u043e\u0447\u0435\u0439 Master-\u043d\u043e\u0434\u0435<\/h2>\n<p>\u0411\u043b\u043e\u043a\u0438\u0440\u0443\u0435\u043c \u0432\u0441\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0432\u0441\u0435\u0445 \u0431\u0430\u0437\u00a0\u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f \u0438 \u0437\u0430\u043f\u0438\u0441\u0438:<\/p>\n<div class=\"console\">\n<blockquote><p>mysql&gt;\u00a0FLUSH TABLES WITH READ LOCK; SET GLOBAL read_only = ON;<\/p><\/blockquote>\n<\/div>\n<p>\u0418 \u0432\u044b\u0432\u043e\u0434\u0438\u043c\u00a0\u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u0435\u00a0\u0440\u0430\u0431\u043e\u0442\u044b \u0421\u0423\u0420\u0411\u0414:<\/p>\n<div class=\"console\">\n<blockquote><p>mysql&gt;\u00a0show master status\\G<\/p><\/blockquote>\n<\/div>\n<p>\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0431\u0443\u0434\u0435\u0442, \u043f\u0440\u0438\u043c\u0435\u0440\u043d\u043e, \u0442\u0430\u043a\u0438\u043c:<\/p>\n<div class=\"console\">\n<blockquote><p>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 File: mysql-bin.000015<br \/>\nPosition: 6315<br \/>\nBinlog_Do_DB:<br \/>\nBinlog_Ignore_DB: information_schema,mysql<\/p><\/blockquote>\n<\/div>\n<p>\u0417\u0430\u043f\u043e\u043c\u043d\u0438\u043c \u0438\u043b\u0438 \u0437\u0430\u043f\u0438\u0448\u0435\u043c\u00a0\u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u0434\u043b\u044f <strong>File <\/strong>\u0438\u00a0<strong>Position<\/strong>. \u041e\u043d\u0438 \u043f\u043e\u043d\u0430\u0434\u043e\u0431\u044f\u0442\u0441\u044f \u043f\u0440\u0438 \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0438\u00a0\u0432\u0442\u043e\u0440\u0438\u0447\u043d\u043e\u0439 \u043d\u043e\u0434\u044b \u043a\u043b\u0430\u0441\u0442\u0435\u0440\u0430.<\/p>\n<p>\u0422\u0435\u043f\u0435\u0440\u044c \u0432\u044b\u0445\u043e\u0434\u0438\u043c \u0438\u0437 \u043a\u043e\u043c\u0430\u043d\u0434\u043d\u043e\u0439 \u043e\u0431\u043e\u043b\u043e\u0447\u043a\u0438 \u0431\u0430\u0437\u044b:<\/p>\n<div class=\"console\">\n<blockquote><p>mysql&gt; \\q<\/p><\/blockquote>\n<\/div>\n<p>\u0438 \u0441\u043e\u0437\u0434\u0430\u0435\u043c \u0434\u0430\u043c\u043f \u0440\u0430\u0431\u043e\u0447\u0438\u0445 \u0431\u0430\u0437:<\/p>\n<div class=\"console\">\n<blockquote><p>#\u00a0mysqldump -uroot -p -v &#8211;databases db1 db2 &gt; \/tmp\/mydb_dump.sql<\/p><\/blockquote>\n<\/div>\n<p><em><small>* \u0434\u0430\u043d\u043d\u0430\u044f \u043a\u043e\u043c\u0430\u043d\u0434\u0430 \u0441\u0434\u0435\u043b\u0430\u0435\u0442 \u0434\u0430\u043c\u043f \u0431\u0430\u0437\u00a0<strong>db1<\/strong>,\u00a0<strong>db2\u00a0<\/strong>\u0438 \u0441\u043e\u0445\u0440\u0430\u043d\u0438\u0442 \u0435\u0433\u043e \u0432 \u0444\u0430\u0439\u043b\u00a0<strong>\/tmp\/mydb_dump.sql<\/strong>.<\/small><\/em><\/p>\n<p>\u041f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u044b\u0439 \u0444\u0430\u0439\u043b \u0441 \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u043e\u0439 \u043a\u043e\u043f\u0438\u0435\u0439 \u043f\u0435\u0440\u0435\u043d\u043e\u0441\u0438\u043c\u00a0\u043d\u0430 \u0432\u0442\u043e\u0440\u043e\u0439 \u0441\u0435\u0440\u0432\u0435\u0440\u00a0\u043f\u0440\u0438 \u043f\u043e\u043c\u043e\u0449\u0438 \u0442\u0430\u043a\u043e\u0439 \u043a\u043e\u043c\u0430\u043d\u0434\u044b:<\/p>\n<div class=\"console\">\n<blockquote><p>#\u00a0scp \/tmp\/mydb_dump.sql dmosk@192.168.166.156:\/tmp<\/p><\/blockquote>\n<\/div>\n<p><small><em>* \u0432 \u0434\u0430\u043d\u043d\u043e\u043c \u043f\u0440\u0438\u043c\u0435\u0440\u0435,\u00a0\u043c\u044b \u0441\u043a\u043e\u043f\u0438\u0440\u0443\u0435\u043c \u0441\u043e\u0437\u0434\u0430\u043d\u043d\u044b\u0439 \u043d\u0430\u043c\u0438 \u0434\u0430\u043c\u043f\u00a0<strong>\/tmp\/mydb_dump.sql<\/strong>\u00a0\u0432 \u043a\u0430\u0442\u0430\u043b\u043e\u0433 \/tmp\u00a0\u0441\u0435\u0440\u0432\u0435\u0440\u0430\u00a0<strong>192.168.166.156<\/strong>\u00a0\u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0438\u0432\u0448\u0438\u0441\u044c \u043f\u043e\u0434 \u0443\u0447\u0435\u0442\u043d\u043e\u0439 \u0437\u0430\u043f\u0438\u0441\u044c\u044e\u00a0<strong>dmosk<\/strong>.<\/em><\/small><\/p>\n<p>\u0422\u0435\u043f\u0435\u0440\u044c \u0441\u043d\u043e\u0432\u0430 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0430\u0435\u043c\u0441\u044f \u043a MySQL:<\/p>\n<div class=\"console\">\n<blockquote><p>#\u00a0mysql -uroot -p<\/p><\/blockquote>\n<\/div>\n<p>\u0438 \u0441\u043d\u0438\u043c\u0430\u0435\u043c \u0440\u0430\u043d\u0435\u0435 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u043d\u044b\u0435 \u0431\u043b\u043e\u043a\u0438\u0440\u043e\u0432\u043a\u0438:<\/p>\n<div class=\"console\">\n<blockquote><p>mysql&gt;\u00a0SET GLOBAL read_only = OFF;<\/p><\/blockquote>\n<\/div>\n<h2>\u041d\u0430 \u043d\u0435\u0440\u0430\u0431\u043e\u0447\u0435\u0439 \u043d\u043e\u0434\u0435<\/h2>\n<p>\u0421\u043e\u0437\u0434\u0430\u0435\u043c \u0434\u0430\u043c\u043f \u0431\u0430\u0437:<\/p>\n<div class=\"console\">\n<blockquote><p>#\u00a0mysqldump -uroot -p -v &#8211;databases db1 db2 &gt; \/tmp\/mydb_dump_slave.sql<\/p><\/blockquote>\n<\/div>\n<p>\u0417\u0430\u0445\u043e\u0434\u0438\u043c\u00a0\u0432 \u043e\u0431\u043e\u043b\u043e\u0447\u043a\u0443 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f MySQL:<\/p>\n<div class=\"console\">\n<blockquote><p>#\u00a0mysql -uroot -p<\/p><\/blockquote>\n<\/div>\n<p>\u041e\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u043c \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u044e:<\/p>\n<div class=\"console\">\n<blockquote><p>mysql&gt;\u00a0stop slave;<\/p><\/blockquote>\n<\/div>\n<p>\u0423\u0434\u0430\u043b\u044f\u0435\u043c\u00a0\u0441\u0442\u0430\u0440\u044b\u0435 \u0431\u0430\u0437\u044b:<\/p>\n<div class=\"console\">\n<blockquote><p>mysql&gt;\u00a0drop database db1;<\/p><\/blockquote>\n<\/div>\n<div class=\"console\">\n<blockquote><p>mysql&gt;\u00a0drop database db2;<\/p><\/blockquote>\n<\/div>\n<p><em><small>* \u0432 \u0434\u0430\u043d\u043d\u043e\u043c \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u0443\u0434\u0430\u043b\u044f\u044e\u0442\u0441\u044f \u0431\u0430\u0437\u044b, \u0434\u043b\u044f \u043a\u043e\u0442\u043e\u0440\u044b\u0445 \u043c\u044b \u0441\u0434\u0435\u043b\u0430\u043b\u0438 \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u044b\u0435 \u043a\u043e\u043f\u0438\u0438.<\/small><\/em><\/p>\n<p>\u0418 \u0441\u043e\u0437\u0434\u0430\u0435\u043c \u0438\u0445\u00a0\u0437\u0430\u043d\u043e\u0432\u043e:<\/p>\n<div class=\"console\">\n<blockquote><p>mysql&gt;\u00a0CREATE DATABASE db1\u00a0DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;<\/p><\/blockquote>\n<\/div>\n<div class=\"console\">\n<blockquote><p>mysql&gt;\u00a0CREATE DATABASE db2\u00a0DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;<\/p><\/blockquote>\n<\/div>\n<p>\u0412\u044b\u0445\u043e\u0434\u0438\u043c \u0438\u0437 \u043e\u0431\u043e\u043b\u043e\u0447\u043a\u0438:<\/p>\n<div class=\"console\">\n<blockquote><p>mysql&gt; \\q<\/p><\/blockquote>\n<\/div>\n<p>\u0422\u0435\u043f\u0435\u0440\u044c\u00a0\u0432\u043e\u0441\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u043c \u0431\u0430\u0437\u044b\u00a0\u0438\u0437 \u0440\u0430\u043d\u0435\u0435 \u0441\u043e\u0437\u0434\u0430\u043d\u043d\u043e\u0433\u043e \u0434\u0430\u043c\u043f\u0430:<\/p>\n<div class=\"console\">\n<blockquote><p>#\u00a0mysql -v -uroot -p\u00a0&lt; \/tmp\/mydb_dump.sql<\/p><\/blockquote>\n<\/div>\n<p>\u041e\u043f\u044f\u0442\u044c \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0430\u0435\u043c\u0441\u044f \u043a \u0421\u0423\u0411\u0414:<\/p>\n<div class=\"console\">\n<blockquote><p>#\u00a0mysql -uroot -p<\/p><\/blockquote>\n<\/div>\n<p>\u0438 \u0432\u0432\u043e\u0434\u0438\u043c \u0442\u0430\u043a\u0443\u044e \u043a\u043e\u043c\u0430\u043d\u0434\u0443:<\/p>\n<div class=\"console\">\n<blockquote><p>mysql&gt;\u00a0change master to master_host = &#8220;192.168.166.155&#8221;, master_user = &#8220;replmy&#8221;, master_password = &#8220;password&#8221;, master_log_file = &#8220;mysql-bin.000015&#8221;, master_log_pos = 6315;<\/p><\/blockquote>\n<\/div>\n<p><em><small>*\u00a0<strong>192.168.166.155:<\/strong>\u00a0IP-\u0430\u0434\u0440\u0435\u0441 \u043c\u043e\u0435\u0433\u043e \u043f\u0435\u0440\u0432\u043e\u0433\u043e \u0441\u0435\u0440\u0432\u0435\u0440\u0430.\u00a0<strong>replmy:<\/strong>\u00a0\u0443\u0447\u0435\u0442\u043d\u0430\u044f \u0437\u0430\u043f\u0438\u0441\u044c \u0434\u043b\u044f \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0438, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0431\u044b\u043b\u0430 \u0441\u043e\u0437\u0434\u0430\u043d\u0430 \u043f\u0440\u0438 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0438 \u043a\u043b\u0430\u0441\u0442\u0435\u0440\u0430.\u00a0<strong>password:<\/strong>\u00a0\u043f\u0430\u0440\u043e\u043b\u044c \u0434\u043b\u044f \u0443\u0447\u0435\u0442\u043d\u043e\u0439 \u0437\u0430\u043f\u0438\u0441\u0438\u00a0<strong>replmy<\/strong>.\u00a0<strong>mysql-bin.000015:<\/strong>\u00a0\u0438\u043c\u044f \u0444\u0430\u0439\u043b\u0430, \u043a\u043e\u0442\u043e\u0440\u043e\u0435 \u043c\u044b \u0434\u043e\u043b\u0436\u043d\u044b \u0431\u044b\u043b\u0438 \u0437\u0430\u043f\u0438\u0441\u0430\u0442\u044c \u0438\u043b\u0438 \u0437\u0430\u043f\u043e\u043c\u043d\u0438\u0442\u044c (\u0443 \u0432\u0430\u0441 \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c\u00a0\u0434\u0440\u0443\u0433\u0438\u043c).\u00a0<strong>6315:<\/strong>\u00a0\u043d\u043e\u043c\u0435\u0440 \u043f\u043e\u0437\u0438\u0446\u0438\u0438, \u0441 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u043d\u0430\u0447\u0430\u0442\u044c \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u044e (\u0442\u0430\u043a\u0436\u0435 \u0434\u043e\u043b\u0436\u043d\u044b \u0431\u044b\u043b\u0438 \u0437\u0430\u043f\u0438\u0441\u0430\u0442\u044c \u0438\u043b\u0438 \u0437\u0430\u043f\u043e\u043c\u043d\u0438\u0442\u044c \u0440\u0430\u043d\u0435\u0435).<\/small><\/em><\/p>\n<p>\u0417\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u044e \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0439 \u043a\u043e\u043c\u0430\u043d\u0434\u043e\u0439:<\/p>\n<div class=\"console\">\n<blockquote><p>mysql&gt;\u00a0start slave;<\/p><\/blockquote>\n<\/div>\n<p>\u0418 \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u0435 \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0438:<\/p>\n<div class=\"console\">\n<blockquote><p>mysql&gt;\u00a0SHOW SLAVE STATUS\\G<\/p><\/blockquote>\n<\/div>\n<p>\u0421\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u0435\u00a0<strong>Slave_IO_Running <\/strong>\u0438\u00a0<strong>Slave_SQL_Running <\/strong>\u0434\u043e\u043b\u0436\u043d\u043e \u0431\u044b\u0442\u044c <strong>Yes<\/strong>, \u0430 \u043e\u0448\u0438\u0431\u043a\u0438 \u0434\u043e\u043b\u0436\u043d\u044b \u0438\u0441\u0447\u0435\u0437\u043d\u0443\u0442\u044c:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-52 size-full\" src=\"http:\/\/guwi.ru\/wp-content\/uploads\/2018\/07\/mysql-replication-repair-02.jpg\" alt=\"\" width=\"477\" height=\"244\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0415\u0441\u043b\u0438 \u043a\u043b\u0430\u0441\u0442\u0435\u0440 \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u0432 \u0440\u0435\u0436\u0438\u043c\u0435 Master &#8211; Master, \u0441\u043d\u0430\u0447\u0430\u043b\u0430 \u043d\u0430\u0439\u0434\u0435\u043c \u043d\u043e\u0434\u0443, \u043d\u0430 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u043f\u0440\u043e\u0438\u0437\u043e\u0448\u0435\u043b \u0441\u0431\u043e\u0439 \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0438.\u00a0\u0414\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u0437\u0430\u0445\u043e\u0434\u0438\u043c \u043d\u0430 \u043a\u0430\u0436\u0434\u043e\u043c \u0441\u0435\u0440\u0432\u0435\u0440\u0435 \u0432 \u043e\u0431\u043e\u043b\u043e\u0447\u043a\u0443 mysql \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0439 \u043a\u043e\u043c\u0430\u043d\u0434\u043e\u0439: # mysql -uroot -p * \u0432 \u0434\u0430\u043d\u043d\u043e\u043c \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u0437\u0430\u0445\u043e\u0434\u0438\u043c \u043e\u0442 \u0438\u043c\u0435\u043d\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f root. \u0418 \u0432\u044b\u0432\u043e\u0434\u0438\u043c \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u0435 \u043d\u043e\u0434\u044b \u0432 \u0440\u0435\u0436\u0438\u043c\u0435\u00a0Slave: mysql&gt;\u00a0SHOW SLAVE STATUS\\G \u0412 \u0441\u043b\u0443\u0447\u0430\u0435 \u043f\u0440\u043e\u0431\u043b\u0435\u043c \u0441 \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0435\u0439 \u043c\u044b \u0443\u0432\u0438\u0434\u0438\u043c\u00a0\u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f\u00a0Slave_IO_Running\u2026 <span class=\"read-more\"><a href=\"http:\/\/guwi.ru\/?p=54\">\u0427\u0438\u0442\u0430\u0442\u044c \u0434\u0430\u043b\u0435\u0435 &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-54","post","type-post","status-publish","format-standard","hentry","category-centos-7"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>\u041d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0444\u043e\u0440\u043c\u0430\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435!!! \u041a\u0430\u043a \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u044e MySQL \u0438\u043b\u0438 MariaDB - \u0418\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0439 \u043f\u043e\u0440\u0442\u0430\u043b GUWi.ru<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"http:\/\/guwi.ru\/?p=54\" \/>\r\n<meta property=\"og:locale\" content=\"ru_RU\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"\u041d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0444\u043e\u0440\u043c\u0430\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435!!! \u041a\u0430\u043a \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u044e MySQL \u0438\u043b\u0438 MariaDB - \u0418\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0439 \u043f\u043e\u0440\u0442\u0430\u043b GUWi.ru\" \/>\r\n<meta property=\"og:description\" content=\"\u0415\u0441\u043b\u0438 \u043a\u043b\u0430\u0441\u0442\u0435\u0440 \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u0432 \u0440\u0435\u0436\u0438\u043c\u0435 Master &#8211; Master, \u0441\u043d\u0430\u0447\u0430\u043b\u0430 \u043d\u0430\u0439\u0434\u0435\u043c \u043d\u043e\u0434\u0443, \u043d\u0430 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u043f\u0440\u043e\u0438\u0437\u043e\u0448\u0435\u043b \u0441\u0431\u043e\u0439 \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0438.\u00a0\u0414\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u0437\u0430\u0445\u043e\u0434\u0438\u043c \u043d\u0430 \u043a\u0430\u0436\u0434\u043e\u043c \u0441\u0435\u0440\u0432\u0435\u0440\u0435 \u0432 \u043e\u0431\u043e\u043b\u043e\u0447\u043a\u0443 mysql \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0439 \u043a\u043e\u043c\u0430\u043d\u0434\u043e\u0439: # mysql -uroot -p * \u0432 \u0434\u0430\u043d\u043d\u043e\u043c \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u0437\u0430\u0445\u043e\u0434\u0438\u043c \u043e\u0442 \u0438\u043c\u0435\u043d\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f root. \u0418 \u0432\u044b\u0432\u043e\u0434\u0438\u043c \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u0435 \u043d\u043e\u0434\u044b \u0432 \u0440\u0435\u0436\u0438\u043c\u0435\u00a0Slave: mysql&gt;\u00a0SHOW SLAVE STATUSG \u0412 \u0441\u043b\u0443\u0447\u0430\u0435 \u043f\u0440\u043e\u0431\u043b\u0435\u043c \u0441 \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0435\u0439 \u043c\u044b \u0443\u0432\u0438\u0434\u0438\u043c\u00a0\u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f\u00a0Slave_IO_Running\u2026 \u0427\u0438\u0442\u0430\u0442\u044c \u0434\u0430\u043b\u0435\u0435 &raquo;\" \/>\r\n<meta property=\"og:url\" content=\"http:\/\/guwi.ru\/?p=54\" \/>\r\n<meta property=\"og:site_name\" content=\"\u0418\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0439 \u043f\u043e\u0440\u0442\u0430\u043b GUWi.ru\" \/>\r\n<meta property=\"article:published_time\" content=\"2018-07-13T07:45:40+00:00\" \/>\r\n<meta property=\"og:image\" content=\"http:\/\/guwi.ru\/wp-content\/uploads\/2018\/07\/mysql-replication-repair-01.jpg\" \/>\r\n<meta name=\"author\" content=\"admin\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"\u041d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0430\u0432\u0442\u043e\u0440\u043e\u043c\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \u043c\u0438\u043d\u0443\u0442\u0430\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/guwi.ru\/?p=54\",\"url\":\"http:\/\/guwi.ru\/?p=54\",\"name\":\"\u041d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0444\u043e\u0440\u043c\u0430\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435!!! \u041a\u0430\u043a \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u044e MySQL \u0438\u043b\u0438 MariaDB - \u0418\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0439 \u043f\u043e\u0440\u0442\u0430\u043b GUWi.ru\",\"isPartOf\":{\"@id\":\"http:\/\/guwi.ru\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/guwi.ru\/?p=54#primaryimage\"},\"image\":{\"@id\":\"http:\/\/guwi.ru\/?p=54#primaryimage\"},\"thumbnailUrl\":\"http:\/\/guwi.ru\/wp-content\/uploads\/2018\/07\/mysql-replication-repair-01.jpg\",\"datePublished\":\"2018-07-13T07:45:40+00:00\",\"dateModified\":\"2018-07-13T07:45:40+00:00\",\"author\":{\"@id\":\"http:\/\/guwi.ru\/#\/schema\/person\/8389c039a09ca9a7a03b90d05f430762\"},\"breadcrumb\":{\"@id\":\"http:\/\/guwi.ru\/?p=54#breadcrumb\"},\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/guwi.ru\/?p=54\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"http:\/\/guwi.ru\/?p=54#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/guwi.ru\/?p=54#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430\",\"item\":\"http:\/\/guwi.ru\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u041d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0444\u043e\u0440\u043c\u0430\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435!!! \u041a\u0430\u043a \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u044e MySQL \u0438\u043b\u0438 MariaDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/guwi.ru\/#website\",\"url\":\"http:\/\/guwi.ru\/\",\"name\":\"\u0418\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0439 \u043f\u043e\u0440\u0442\u0430\u043b GUWi.ru\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/guwi.ru\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"ru-RU\"},{\"@type\":\"Person\",\"@id\":\"http:\/\/guwi.ru\/#\/schema\/person\/8389c039a09ca9a7a03b90d05f430762\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"http:\/\/guwi.ru\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/119031a5dc09b470495f25546952bbd6788e8c489add738a2afe18ab63de8267?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/119031a5dc09b470495f25546952bbd6788e8c489add738a2afe18ab63de8267?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/guwi.ru\"],\"url\":\"http:\/\/guwi.ru\/?author=1\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u041d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0444\u043e\u0440\u043c\u0430\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435!!! \u041a\u0430\u043a \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u044e MySQL \u0438\u043b\u0438 MariaDB - \u0418\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0439 \u043f\u043e\u0440\u0442\u0430\u043b GUWi.ru","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":"http:\/\/guwi.ru\/?p=54","og_locale":"ru_RU","og_type":"article","og_title":"\u041d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0444\u043e\u0440\u043c\u0430\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435!!! \u041a\u0430\u043a \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u044e MySQL \u0438\u043b\u0438 MariaDB - \u0418\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0439 \u043f\u043e\u0440\u0442\u0430\u043b GUWi.ru","og_description":"\u0415\u0441\u043b\u0438 \u043a\u043b\u0430\u0441\u0442\u0435\u0440 \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u0432 \u0440\u0435\u0436\u0438\u043c\u0435 Master &#8211; Master, \u0441\u043d\u0430\u0447\u0430\u043b\u0430 \u043d\u0430\u0439\u0434\u0435\u043c \u043d\u043e\u0434\u0443, \u043d\u0430 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u043f\u0440\u043e\u0438\u0437\u043e\u0448\u0435\u043b \u0441\u0431\u043e\u0439 \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0438.\u00a0\u0414\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u0437\u0430\u0445\u043e\u0434\u0438\u043c \u043d\u0430 \u043a\u0430\u0436\u0434\u043e\u043c \u0441\u0435\u0440\u0432\u0435\u0440\u0435 \u0432 \u043e\u0431\u043e\u043b\u043e\u0447\u043a\u0443 mysql \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0439 \u043a\u043e\u043c\u0430\u043d\u0434\u043e\u0439: # mysql -uroot -p * \u0432 \u0434\u0430\u043d\u043d\u043e\u043c \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u0437\u0430\u0445\u043e\u0434\u0438\u043c \u043e\u0442 \u0438\u043c\u0435\u043d\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f root. \u0418 \u0432\u044b\u0432\u043e\u0434\u0438\u043c \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u0435 \u043d\u043e\u0434\u044b \u0432 \u0440\u0435\u0436\u0438\u043c\u0435\u00a0Slave: mysql&gt;\u00a0SHOW SLAVE STATUSG \u0412 \u0441\u043b\u0443\u0447\u0430\u0435 \u043f\u0440\u043e\u0431\u043b\u0435\u043c \u0441 \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0435\u0439 \u043c\u044b \u0443\u0432\u0438\u0434\u0438\u043c\u00a0\u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f\u00a0Slave_IO_Running\u2026 \u0427\u0438\u0442\u0430\u0442\u044c \u0434\u0430\u043b\u0435\u0435 &raquo;","og_url":"http:\/\/guwi.ru\/?p=54","og_site_name":"\u0418\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0439 \u043f\u043e\u0440\u0442\u0430\u043b GUWi.ru","article_published_time":"2018-07-13T07:45:40+00:00","og_image":[{"url":"http:\/\/guwi.ru\/wp-content\/uploads\/2018\/07\/mysql-replication-repair-01.jpg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u041d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0430\u0432\u0442\u043e\u0440\u043e\u043c":"admin","\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f":"1 \u043c\u0438\u043d\u0443\u0442\u0430"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/guwi.ru\/?p=54","url":"http:\/\/guwi.ru\/?p=54","name":"\u041d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0444\u043e\u0440\u043c\u0430\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435!!! \u041a\u0430\u043a \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u044e MySQL \u0438\u043b\u0438 MariaDB - \u0418\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0439 \u043f\u043e\u0440\u0442\u0430\u043b GUWi.ru","isPartOf":{"@id":"http:\/\/guwi.ru\/#website"},"primaryImageOfPage":{"@id":"http:\/\/guwi.ru\/?p=54#primaryimage"},"image":{"@id":"http:\/\/guwi.ru\/?p=54#primaryimage"},"thumbnailUrl":"http:\/\/guwi.ru\/wp-content\/uploads\/2018\/07\/mysql-replication-repair-01.jpg","datePublished":"2018-07-13T07:45:40+00:00","dateModified":"2018-07-13T07:45:40+00:00","author":{"@id":"http:\/\/guwi.ru\/#\/schema\/person\/8389c039a09ca9a7a03b90d05f430762"},"breadcrumb":{"@id":"http:\/\/guwi.ru\/?p=54#breadcrumb"},"inLanguage":"ru-RU","potentialAction":[{"@type":"ReadAction","target":["http:\/\/guwi.ru\/?p=54"]}]},{"@type":"ImageObject","inLanguage":"ru-RU","@id":"http:\/\/guwi.ru\/?p=54#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"http:\/\/guwi.ru\/?p=54#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","item":"http:\/\/guwi.ru\/"},{"@type":"ListItem","position":2,"name":"\u041d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0444\u043e\u0440\u043c\u0430\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435!!! \u041a\u0430\u043a \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u044e MySQL \u0438\u043b\u0438 MariaDB"}]},{"@type":"WebSite","@id":"http:\/\/guwi.ru\/#website","url":"http:\/\/guwi.ru\/","name":"\u0418\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0439 \u043f\u043e\u0440\u0442\u0430\u043b GUWi.ru","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/guwi.ru\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"ru-RU"},{"@type":"Person","@id":"http:\/\/guwi.ru\/#\/schema\/person\/8389c039a09ca9a7a03b90d05f430762","name":"admin","image":{"@type":"ImageObject","inLanguage":"ru-RU","@id":"http:\/\/guwi.ru\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/119031a5dc09b470495f25546952bbd6788e8c489add738a2afe18ab63de8267?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/119031a5dc09b470495f25546952bbd6788e8c489add738a2afe18ab63de8267?s=96&d=mm&r=g","caption":"admin"},"sameAs":["http:\/\/guwi.ru"],"url":"http:\/\/guwi.ru\/?author=1"}]}},"_links":{"self":[{"href":"http:\/\/guwi.ru\/index.php?rest_route=\/wp\/v2\/posts\/54","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/guwi.ru\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/guwi.ru\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/guwi.ru\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/guwi.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=54"}],"version-history":[{"count":0,"href":"http:\/\/guwi.ru\/index.php?rest_route=\/wp\/v2\/posts\/54\/revisions"}],"wp:attachment":[{"href":"http:\/\/guwi.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=54"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/guwi.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=54"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/guwi.ru\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}