Kuberekana MySQL. A pfupi digression

Nokufamba kwenguva, anotarisira pamberi chero dambudziko kunoitika apo simba servers rayo hazvikwani kuti mabasa, uye kutenga michina mitsva zvisingaiti nemhaka matambudziko emari, kana chete kwakadaro kutenga ari mubvunzo payback yaro yemberi.

In chiedza zviitiko zvakadaro hakusi okushamisira kuziva mafungiro aya sezvo kuberekana Database pamusoro. ruzivo kwakadaro yekudyidzana kurerutsa upenyu munhu mubasa rinorema basa mugadziriro uye basa achasika chinhu Zvakanyanya Kunaka Panguva Yepamuviri kushanda Hardware configuration. Kazhinji mashoko, kuti Database kuberekana zvinoreva pamwe kugona kuisa makombiyuta kuvandudza coefficient maitiro wegadziriro yayo nepo. Wokutanga zvinogona kuitwa nokukanda kubva zvikumbiro kuna negadziriro yeparutivi Server, uye yechipiri - paakasika munhu yomunzvimbo kopi Database, iyo ichatsiva huru chawo kana zvakakodzera.

Nyore uye inonyanya nzira kutevedzera sangano - iri kudzokororwa MySQL. Uye MySQL inotsigira functionality ichi pamwe 3.23.15 shanduro uye chete chete-nzira kuberekana. Muchiitiko chino, chaiyo configuration pakati «tenzi-nhapwa», sezvamakaropafadzwa huru Server (tenzi) kunogonawo kuva panguva uye muranda Server (muranda).

MySQL kuberekana pane imwe nguva iri rakatangwa sezvinotevera. Gadzira tenzi Server, riri basa kutevera kuchinja ari binary faira, izvo zvinoratidza zvose Database kuchinja uye muranda muchina kana michina kuverenga nokukuitira ichi mubvunzo faira. Naizvozvo, nhapwa dzose anokurukura huru, kuchinja zvose akaita kuti tenzi, anozodzidza muranda, uye hakuna kusiyana uku kunoita kuti mamiriro ezvinhu uye kururama mashoko.

MySQL kuberekana akagadzawo matanho akawanda.

1. mutarisiri Hurongwa anofanira nechokwadi chokuti michina yayo yose kumhanya ichangobva shanduro MySQL.
2. Unofanira kusika munhu rokushandisa idzva pamusoro tenzi Server, mumwe Login iyo ichava MySQL kuberekana (zvinofanira kuva FILE ropafadzo sandara uye kodzero kukurukurirana muranda-michina).
3. Next unofanira kumisa MySQL pamusoro mukuru mukuru uye muranda servers uye kutevedzera zvose Data chokuita kuberekana. On Unix anotsanangura hurongwa zvinokwanisika kuti tara murayiro, izvo zvinoita negadziriro yeparutivi yose katarogu. Windows vanozvishandisa tichaswedera WinZip.
4. Muchikamu mysqld kuwedzera zvinotevera: Server-id = rakasiyana nhamba, danda-remarara. kuchinja zvose zviitike mune My.conf faira pamusoro tenzi Server, pashure pacho tinofanira hazvo kuva migweje.
5. On muranda-michina iri chete faira unofanira kuwedzera zvinotevera code:

tenzi-hondo =

tenzi-mushandisi =

tenzi-pasiwedhi =

tenzi-Chiteshi =

Server-id =

* In angled mumabhuraketi kupinda mashoko ako, pane pamusoro wenyaya.

Panoperera zvose kutevedzera zviri Database muranda server restart michina zvose.

Pashure Zviito izvi zvinogona sechinoitika kuberekana akagadzawo uye configured, izvo zvinoreva kuti ikozvino rako chairo Server haazobvumira kubva kumusoro mutoro uye kana kukundikana tafura pariri payo nyore unogona kudzorerwa pamusoro perimwe pakombiyuta. Zvinogona makore mashomanana kuti kukanganwa pamusoro kutenga itsva Hardware nokuda rinorema basa mugadziriro uye vanogutsikana ane basa isingachinji aripo michina.