{"id":573,"date":"2018-12-09T05:09:24","date_gmt":"2018-12-09T07:09:24","guid":{"rendered":"http:\/\/vejas.defas.lt\/?p=573"},"modified":"2018-12-10T04:37:15","modified_gmt":"2018-12-10T06:37:15","slug":"duomenu-replikavimas","status":"publish","type":"post","link":"http:\/\/vejas.defas.lt\/?p=573","title":{"rendered":"Duomen\u0173 replikavimas"},"content":{"rendered":"

Tikslas kaupti duomenis atsarginiame serveryje su tikslu pasiekti juos net ir tada, kai j\u0117gain\u0117s duomenys nepasiekiami. J\u0117gain\u0117s MySQL master serveris kaupia duomenis replikavimui. Juos pasiima centrinis slave serveris. Slave serveris bus defas.lt MySQL serveris. Patikrinkime abej\u0173 serveri\u0173 id. Jie turi b\u016bti skirtingi. Apra\u0161omas my.cnf faile MySQL serverio atveju.<\/p>\n

[mysqld]\r\nserver-id=2\r\n<\/pre>\n
ir MariaDB MySQL serverio versijos atveju server-id u\u017eduodamas serverio paleidimo komandin\u0117je eilut\u0117je:<\/p>\n
\/usr\/local\/mysql\/bin\/mysqld_safe --datadir=\/home\/mysql\/ --server-id=2<\/strong> --pid-file=\/var\/run\/mysql\/mysql.pid &<\/pre>\n
server-id su\u017einoti galima komanda:<\/p>\n
SELECT @@server_id<\/pre>\n
defas.lt serveris gr\u0105\u017eina reik\u0161m\u0119 2, j\u0117gain\u0117s serveris reik\u0161m\u0119 1.<\/p>\n
MySQL apra\u0161yme reikalauja, kad keli naudojami slave serveriai privalo tur\u0117ti skirtingus server-id. Galb\u016bt master ir slave gali tur\u0117ti tuos pa\u010dius? Reik\u0117t\u0173 pabandyti.<\/p>\n
Slave serveryje nurodome, master konfig\u016bracij\u0105 komanda:<\/p>\n
CHANGE MASTER TO \r\nMASTER_HOST='90.140.218.158', \r\nMASTER_USER='replika', \r\nMASTER_PASSWORD='replika', \r\nMASTER_LOG_FILE='recorded_log_file_name', \r\nMASTER_LOG_POS=recorded_log_position;<\/pre>\n
Pastaba: pasikeitus IP adresui, \u0161i\u0105 komand\u0105 tur\u0117sime pastoviai perleidin\u0117ti. Tai atliks ActivateFactory() funkcija:<\/p>\n
Function ActivateFactory() {\r\n\u2003if (isset($_REQUEST['AJIP'])) {\r\n\u2003\u2003$_SESSION['AJIP']=$_REQUEST['AJIP'];\r\n\u2003\u2003$this->server2=$_REQUEST['AJIP'];\r\n\u2003\u2003$this->query_to_res(\"stop slave\");\r\n\u2003\u2003$this->query_to_res(\"CHANGE MASTER TO \u2003\u2003MASTER_HOST='\".$_REQUEST['AJIP'].\"',MASTER_USER='replika',MASTER_PASSWORD='replika',MASTER_LOG_FILE='recorded_log_file_name',MASTER_LOG_POS=recorded_log_position;\");\r\n\u2003\u2003$this->query_to_res(\"start slave\");\r\n\u2003}\r\n}\r\n<\/pre>\n
Padarome DB vejojegaines duomen\u0173 kopij\u0105 slave serveryje: konfig\u016bracij\u0105 komanda:
\nmysqldump -u vejojegaines -p vejojegaines>20181209.sql<\/p>\n
FPT perduodame gaut\u0105 fail\u0105 \u012f defas.lt server\u012f. Po to sukuriame defas.lt serveryje DB Duomenys ir komandine eilute sukeliame duomenis i\u0161 sql failo.<\/p>\n
mysql -u arturas -p vejojegaines<20181209.sql<\/pre>\n
Taigi: j\u0117gain\u0117s serveryje redaguojame \/etc\/mysql\/mycnf fail\u0105:<\/p>\n
server-id               = 1\r\nlog_bin                 = \/var\/log\/mysql\/mysql-bin.log\r\nexpire_logs_days        = 10\r\nmax_binlog_size         = 100M\r\nbinlog_do_db            = vejojegaines<\/b>\r\n<\/pre>\n
Naujai paleid\u017eiame server\u012f: sudo service mysql restart<\/p>\n
Paleidus slave server\u012f gaunamas klaidos prane\u0161imas: Master command COM_REGISTER_SLAVE failed: Access denied for user ‘replika’@’%’ (using password: YES) (Errno: 1045). Taisome problem\u0105 resetindami slave server\u012f mysql’in\u0117mis komandomis: reset slave; stop slave; start slave;<\/p>\n
Taip pat suteikiame replikavimo teises replika vartotojui master serveryje. T\u0105 padaryti galima su root\/root mysql vartotoju:<\/p>\n
GRANT REPLICATION SLAVE ON *.* TO replika identified by 'replika';\r\nflush privileges;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
Tikslas kaupti duomenis atsarginiame serveryje su tikslu pasiekti juos net ir tada, kai j\u0117gain\u0117s duomenys nepasiekiami. J\u0117gain\u0117s MySQL master serveris kaupia duomenis replikavimui. Juos pasiima centrinis slave serveris. Slave serveris bus defas.lt MySQL serveris. Patikrinkime abej\u0173 serveri\u0173 id. Jie turi b\u016bti skirtingi. Apra\u0161omas my.cnf faile MySQL serverio atveju. [mysqld] server-id=2 ir MariaDB MySQL serverio versijos … Skaityti toliau: Duomen\u0173 replikavimas<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-573","post","type-post","status-publish","format-standard","hentry","category-be-kategorijos"],"acf":[],"_links":{"self":[{"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=\/wp\/v2\/posts\/573","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=573"}],"version-history":[{"count":17,"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=\/wp\/v2\/posts\/573\/revisions"}],"predecessor-version":[{"id":575,"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=\/wp\/v2\/posts\/573\/revisions\/575"}],"wp:attachment":[{"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=573"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=573"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}