Ukuphindaphindeka MySQL. A kuphambuko emfutshane

Maxa wambi, umlawuli phambi kokuba nayiphi na ingxaki kwenzeka xa amandla abancedisi ayo akwanelanga ukuba imisebenzi, kunye nokuthengwa kwezixhobo ezitsha cishe kungenakwenzeka ngenxa iingxaki zemali, okanye ukuthenga nje onjalo ethandabuza malunga payback yayo kwixesha elizayo.

Xa ukukhanya iziganeko ezinjalo akukho akufuneki ukwazi ngayo ingqiqo njengoko iziko ledatha ukuphindaphindeka enjalo. ulwazi olunjalo kakhulu lula ubomi nawuphi na umntu obandakanyeka kwiinkqubo umsebenzi onzima kunye nenkonzo qamba kangangoko ukusebenza uqwalaselo zekhompyutha. Ngokubanzi, i-phindana database kuthetha umthamo union ibekwe lweekhompyutha ukuphucula 'ngumlingani ka yokusebenza kwenkqubo kunye nokuqina kwayo. Isiphumo wokuqala emaziphunyezwe basikhupha wezicelo kumncedisi yogcino, kwaye eyesibini - ngokudala ikopi yasekuhlaleni database, nto leyo eya kuthatha indawo isiseko iphambili xa kuyimfuneko.

Eyona ndlela ilula kakhulu eqhelekileyo ukwenza umbutho - beluphindwe I SQL. Kwaye I SQL yam ixhasa olusebenziso kunye 3.23.15 version kanye kuphela indlela enye-phindana. Kulo mzekelo, loqwalaselo eyodwa «inkosi-slave», apho umncedisi engundoqo (master) nako kuba ngaxeshanye kunye neseva ngamakhoboka (khoboka).

I SQL yam ukuphindaphindeka ngexesha elinikiweyo kuphunyezwa ngale ndlela ilandelayo. Yenza master umncedisi, nenoxanduva ukulandela utshintsho kwifayile yokubini, ebonisa zonke iinguqu ledatha kunye umatshini ikhoboka okanye oomatshini ukufunda nokwenza le fayile lombuzo. Slave njalo inxibelelane ephambili, ngoko, lonke utshintsho lwenziwayo inkosi, ugqithele ikhoboka, yaye akukho divergence le meko kunye data ezingachanekanga.

MySQL ukuphindaphindeka ifakwe kwi amanyathelo aliqela.

1. Umlawuli nkqubo kufuneka aqinisekise ukuba zonke iimatshini yawo usebenzisa uguqulelo lwe SQL yam entsha.
2. Kufuneka wenze umsebenzisi entsha inkosi kumncedisi, igama elithile apho kuya kubakho I SQL yam phindana (kufuneka ube kumgangatho lungelo IFAYILI kunye nelungelo ukunxibelelana ikhoboka-oomatshini).
3. Okulandelayo kufuneka uyeke kwi SQL yam phezu umphathi kwi abaziintloko ikhoboka iiseva ze ukope yonke idatha enxulumene ukuphindaphindeka. Kwindlela yokusebenza ye Unix-based sinako ukwenza umyalelo tar, nto leyo yenza umva we yonke khathalogu. abasebenzisi Windows uya kusondela WinZip.
4. Kwicandelo mysqld ukongeza kulandelayo: server-id = unique number, log-bin. Zonke iinguqu ezenzeka ifayile My.conf kwi inkosi kumncedisi, emva koko kufuneka nakanjani isindwe.
5. Kwi ikhoboka elithembekileyo-ukuba koomatshini kwifayile enye ufuna ukudibanisa ikhowudi ilandelayo:

master-host =

master-umsebenzisi =

master-password =

master-port =

server-id =

* Xa izibiyeli ezineekona kufuneka ukuba ufake iinkcukacha zakho, endaweni umbhalo ngasentla.

Ekupheleni bonke kukhuphela iziko ledatha kwiseva ngamakhoboka ze uqale kwakhona zonke oomatshini.

Emva kwezi zenzo zingathathwa ngokuba phindana efakiweyo wazilungisa, nto leyo ithetha ukuba ngoku engundoqo umncedisi wakho akayi ubunzima kumthwalo ophezulu kwaye kwimeko yokusilela itafile phezu kwaso kube lula nga kubuyiselwa kwenye ikhompyutha. Umphumo sinokuba kwiminyaka embalwa ukulibala malunga ukuthenga ezintsha hardware for iinkqubo umsebenzi onzima kunye nomxholo kunye nomsebenzi emiselwe kwezixhobo ezikhoyo.