Replication MySQL. Ib tug nyuag digression

Tam sim no los yog yav tom ntej, ib tug neeg khiav dej num ua ntej tej teeb meem no tshwm sim thaum lub hwj chim ntawm nws cov servers yog tsis txaus rau cov kev pab raws qib, thiab cov purchase ntawm tshiab cov khoom yog suab tsis yooj yim sua vim hais tias ntawm cov nyiaj txiag teeb meem, los yog cia li xws li ib tug purchase yog nyob rau hauv tsis ntseeg txog nws payback nyob rau hauv lub neej yav tom ntej.

Nyob rau hauv lub teeb ntawm tej txheej xwm no yog tsis superfluous paub txog xws li ib tug lub tswv yim raws li lub replication database. Tej kev txawj ntse yog ho piv lub neej ntawm txhua tus neeg koom nyob rau hauv hnyav luag hauj lwm systems thiab cov kev pab yuav tsim ib qho kev pom ua hauj lwm kho vajtse configuration. Nyob rau hauv nqe lus dav dav, lub database replication implies union ntawv Tuition Waiver teem ntawm computers los txhim kho lub coefficient ntawm kev ua tau zoo ntawm lub cev thiab nws cov resiliency. Tus thawj cov nyhuv yuav ua tau tiav los ntawm ntuav tawm ntawm cov kev thov mus rau lub backup neeg rau zaub mov, thiab lub thib ob - los ntawm kev tsim ib lub zos daim ntawv ntawm lub database, uas yuav hloov lub ntsiab puag yog tias tsim nyog.

Qhov yooj yim thiab feem ntau txoj kev uas yuav replicate lub koom haum - yog replicated MySQL. Thiab MySQL txhawb no functionality nrog lub 3.23.15 version thiab tsuas yog ib-txoj kev replication. Nyob rau hauv cov ntaub ntawv no, ib tug tshwj xeeb configuration ntawm lub «tswv-qhev», nyob rau lub ntsiab zaub mov (master) kuj yuav ib txhij thiab qhev neeg rau zaub mov (qhev).

MySQL replication ntawm ib lub sij hawm yog siv raws li nram qab no. Tsim ib tug tswv neeg rau zaub mov, uas yog lub luag hauj lwm ua raws li cov kev hloov ntawm lub binary cov ntaub ntawv, uas qhia txog tag nrho cov database hloov thiab tus qhev lub tshuab los yog cov cav tov los nyeem thiab ua no cov lus nug ntaub ntawv. Leejtwg lossi communicates nrog lub ntsiab, yog li ntawd, tag nrho cov kev hloov ua rau tus tswv, tsiv mus nyob rau rau tus qhev, thiab tsis muaj divergence ntawm qhov teeb meem no thiab tsis yog cov ntaub ntawv.

MySQL replication ntsia tau rau hauv ob peb kauj ruam.

1. Lub system administrator yuav tsum ua kom paub tseeb tias tag nrho nws cov cav tov khiav qhov tseeb version ntawm MySQL.
2. Koj yuav tsum tsim ib tug tshiab neeg siv nyob rau hauv tus tswv neeg rau zaub mov, ib tus ID nkag mus uas yuav MySQL replication (nws yuav tsum muaj NTAUB NTAWV cib fim theem thiab txoj cai rau kev sib txuas lus nrog tus qhev-machine).
3. Tom ntej no koj yuav tau nres lub MySQL rau hauv lub commander nyob rau hauv Hmoob thiab qhev servers thiab luam tag nrho cov ntaub ntawv hais txog replication. Nyob rau Unix-raws li systems nws yog ua tau kom ib hais kom ua, uas ua rau ib tug thaub qab ntawm lub tag nrho catalog. Lub qhov rais neeg siv yuav txoj kev WinZip.
4. Nyob rau hauv seem mysqld ntxiv hauv qab no: neeg rau zaub mov-id = cim tooj, teev rau hauv. Txhua yam kev hloov tau qhov chaw nyob rau hauv My.conf cov ntaub ntawv rau tus tswv neeg rau zaub mov, tom qab uas nws yuav tsum tau yuav overloaded.
5. Nyob rau hauv qhev machines nyob rau hauv lub tib cov ntaub ntawv uas koj xav tau ntxiv cov cai nram qab no:

tswv-party =

tswv-neeg siv =

tswv-lo lus zais =

tswv-chaw nres nkoj =

neeg rau zaub mov-id =

* Nyob rau hauv lub nkhaus tau nkag mus rau koj cov ntaub ntawv, es tsis txhob ntawm lub saum toj no cov ntawv nyeem.

Qhov kawg ntawm tag nrho cov luam cov database rau tus qhev neeg rau zaub mov thiab pib dua tag nrho cov cav tov.

Tom qab no cov kev ua yuav ntshai li replication ntsia thiab configured, uas txhais tau tias nws yog tam sim no koj lub ntsiab neeg rau zaub mov yuav tsis raug kev txom nyem los ntawm lub siab load thiab nyob rau hauv cov ntaub ntawv ntawm tsis ua hauj lwm ntawm ib lub rooj nyob rau hauv nws yooj yim yuav tsum tau rov qab rau lwm lub computer. Cov yuav ua tau ib tug ob peb xyoos mus tsis nco qab txog yuav khoom tshiab kho vajtse rau hnyav luag hauj lwm systems thiab cov ntsiab lus nrog ib tug tsim ua hauj lwm uas twb muaj lawm cov khoom.