{"id":722,"date":"2013-05-11T15:55:42","date_gmt":"2013-05-11T13:55:42","guid":{"rendered":"https:\/\/zz-indigo.mavipet.sk\/?page_id=722"},"modified":"2013-05-11T15:55:42","modified_gmt":"2013-05-11T13:55:42","slug":"mysql","status":"publish","type":"page","link":"https:\/\/zz-indigo.mavipet.sk\/?page_id=722","title":{"rendered":"mysql"},"content":{"rendered":"

Z d\u00f4vodu HA rie\u0161enia mana\u017ementu je treba ako podkladov\u00fa DB pou\u017ei\u0165 MySQL. Na oboch serveroch sa \u0161tandardne nain\u0161taluje Mysql-Server a na oboch nastav\u00edme rovnak\u00e9 root hesl\u00e1.<\/p>\n

apt-get install mysql-server mysql-client<\/pre>\n
Nasleduj\u00faca konfigur\u00e1cia vyu\u017e\u00edva faktu ze obe DB s\u00fa pr\u00e1zdne preto nebudeme robi\u0165 \u00favodn\u00fa synchroniz\u00e1ciu DB!!!<\/strong><\/p>\n
Vytvor\u00edme u\u017e\u00edvate\u013eov pre synchroniz\u00e1ciu. Pripom\u00ednam \u017ee na tak\u00e9to veci tu m\u00e1me \u0161peci\u00e1lnu sie\u0165 172.16.2.0\/24<\/p>\n
Na oboch serveroch vytvorime u\u017e\u00edvate\u013eov. Ke\u010f\u017ee sa aj datab\u00e1za mysql bude synchronizova\u0165 musia byt u\u017e\u00edvatelia v oboch datab\u00e1zach.<\/p>\n
CREATE USER 'replynfs02'@'172.16.2.12' IDENTIFIED BY 'coool_dlhe_heslo';\nGRANT REPLICATION SLAVE ON *.* TO 'replynfs02'@'172.16.2.12';\nCREATE USER 'replynfs02'@'172.16.2.11' IDENTIFIED BY 'coool_dlhe_heslo';\nGRANT REPLICATION SLAVE ON *.* TO 'replynfs02'@'172.16.2.11';\nflush privileges;<\/pre>\n
N\u00e1sledne uprav\u00edme konfigur\u00e1ciu mysql serverov.<\/p>\n
Ako prve zmen\u00edme bind adresu na 0.0.0.0. A to na oboch serveroch.<\/p>\n
...\n# Instead of skip-networking the default is now to listen only on\n# localhost which is more compatible and is not less secure.\nbind-address\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 0.0.0.0<\/strong>\n#\n# * Fine Tuning\n#\n...<\/pre>\n
N\u00e1sledne nakonfigurujeme synchroniz\u00e1ciu:<\/p>\n
...\n# The following can be used as easy to replay backup logs or for replication.\n# note: if you are setting up a replication slave, see README.Debian about\n#\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 other settings you may need to change.\nserver-id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 1\n\nlog-bin\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = \/var\/log\/mysql\/mysql-bin.log\nlog-slave-updates\nlog-bin-index\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = \/var\/log\/mysql\/mysql-log-bin.index\nlog-error\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = \/var\/log\/mysql\/mysql-error.log\n\nrelay-log\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = \/var\/log\/mysql\/mysql-relay.log\nrelay-log-info-file\u00a0\u00a0\u00a0\u00a0 = \/var\/log\/mysql\/mysql-relay-log.info\nrelay-log-index\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = \/var\/log\/mysql\/mysql-relay-log.index\n\nauto_increment_increment\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 10\nauto_increment_offset\u00a0\u00a0 = 1\n\nexpire_logs_days\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 10\nmax_binlog_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 100M\n#binlog_do_db\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = include_database_name\n#binlog_ignore_db\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = include_database_name\n#\n# * InnoDB\n...<\/pre>\n
Na druhom servery nahrad\u00edme nfs02.sync.mavipet.sk<\/strong> za nfs01.sync.mavipet.sk<\/strong> a u\u017e\u00edvate\u013ea z replynfs01<\/strong> za replynfs02<\/strong>. Pokial sme dali rozdielne hesla tak zmenime aj to. Ako \u010fa\u013e\u0161ie zmen\u00edme server-id<\/strong> na 2 rovnako ako auto_increment_offset.\u00a0<\/strong><\/p>\n
Teraz sta\u010d\u00ed myslq servery re\u0161tartn\u00fa\u0165 a prihl\u00e1si\u0165 sa na ne. Aby sme eventu\u00e1lne spustili \u00favodn\u00fa synchroniz\u00e1ciu.<\/p>\n
# mysql mysql -p<\/pre>\n
Teraz sa m\u00f4\u017eeme pozrie\u0165 \u010di sa synchroniz\u00e1cia rozbehla, kontrolujeme na oboch n\u00f3doch. Uk\u00e1\u017eka z n\u00f3du nfs01. Na n\u00f3de nfs02 n\u00e1le\u017eite vymen\u00edme hosta a login:<\/p>\n
mysql> CHANGE MASTER TO MASTER_HOST='nfs02.sync.mavipet.sk', MASTER_USER='replynfs01', MASTER_PASSWORD='coool_dlhe_heslo', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=0;\nmysql> SHOW SLAVE STATUSG;\n*************************** 1. row ***************************\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Slave_IO_State: Waiting for master to send event\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Master_Host: nfs02.sync.mavipet.sk\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Master_User: replynfs01\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Master_Port: 3306\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Connect_Retry: 60\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Master_Log_File: mysql-bin.000008\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Read_Master_Log_Pos: 106\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Relay_Log_File: mysql-relay.000115\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Relay_Log_Pos: 251\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Relay_Master_Log_File: mysql-bin.000008\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Slave_IO_Running: Yes\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Slave_SQL_Running: Yes\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Replicate_Do_DB:\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Replicate_Ignore_DB:\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Replicate_Do_Table:\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Replicate_Ignore_Table:\n\u00a0\u00a0\u00a0\u00a0\u00a0 Replicate_Wild_Do_Table:\n\u00a0 Replicate_Wild_Ignore_Table:\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Last_Errno: 0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Last_Error:\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Skip_Counter: 0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Exec_Master_Log_Pos: 106\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Relay_Log_Space: 547\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Until_Condition: None\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Until_Log_File:\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Until_Log_Pos: 0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Master_SSL_Allowed: No\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Master_SSL_CA_File:\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Master_SSL_CA_Path:\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Master_SSL_Cert:\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Master_SSL_Cipher:\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Master_SSL_Key:\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Seconds_Behind_Master: 0\nMaster_SSL_Verify_Server_Cert: No\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Last_IO_Errno: 0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Last_IO_Error:\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Last_SQL_Errno: 0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Last_SQL_Error:\n1 row in set (0.00 sec)\n\nERROR:\nNo query specified<\/pre>\n
Ako odpove\u010f by sme dostali tabu\u013eku zo stavom synchroniz\u00e1cie. V na\u0161om nasaden\u00ed pou\u017e\u00edvame na synchroniz\u00e1ciu priamy prepoj medzi n\u00f3dmi a preto nebudeme rie\u0161i\u0165 \u0161ifrovanie komunik\u00e1cie.<\/p>\n
Ako test m\u00f4\u017eeme vytvori\u0165 na jednom n\u00f3de Datab\u00e1zu a na druhom ju skontrolova\u0165.<\/p>\n","protected":false},"excerpt":{"rendered":"
Z d\u00f4vodu HA rie\u0161enia mana\u017ementu je treba ako podkladov\u00fa DB pou\u017ei\u0165 MySQL. Na oboch serveroch sa \u0161tandardne nain\u0161taluje Mysql-Server a na oboch nastav\u00edme rovnak\u00e9 root hesl\u00e1. apt-get install mysql-server mysql-client Nasleduj\u00faca konfigur\u00e1cia vyu\u017e\u00edva faktu ze obe DB s\u00fa pr\u00e1zdne preto … Pokra\u010dova\u0165 v \u010d\u00edtan\u00ed →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":491,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-722","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/zz-indigo.mavipet.sk\/index.php?rest_route=\/wp\/v2\/pages\/722","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zz-indigo.mavipet.sk\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/zz-indigo.mavipet.sk\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/zz-indigo.mavipet.sk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zz-indigo.mavipet.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=722"}],"version-history":[{"count":0,"href":"https:\/\/zz-indigo.mavipet.sk\/index.php?rest_route=\/wp\/v2\/pages\/722\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/zz-indigo.mavipet.sk\/index.php?rest_route=\/wp\/v2\/pages\/491"}],"wp:attachment":[{"href":"https:\/\/zz-indigo.mavipet.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}