Yadda zaka saita MySQL Master-Slava Replic akan RHEL 8


MySQL Replication tsari ne wanda za'a kwafa bayanai ta atomatik ko kwafe su ta wata hanyar sabuwa a ainihin lokacin. Sauyawa yana ba da aiki da haƙuri kuma yana ba mai amfani kwanciyar hankali cewa koda bayan rashin nasara a cikin sabar uwar garke, ana iya dawo da bayanai.

A cikin wannan darasin, zaku koyi yadda ake saitawa da saita kwafin MySQL na bawan-bawa akan RHEL 8 Linux.

A cikin saitin, zamu sami sabobin biyu masu gudana RHEL 8 tare da adiresoshin IP masu zuwa.

Master = 173.82.120.14
Slave  = 173.82.115.165

Yanzu bari mu ci gaba mu ga yadda za mu iya saita saitin kwafin MySQL Master-bawa akan RHEL 8 Linux.

Mataki na 1: Sanya MySQL akan Babbar Jagora da Bawa

1. Sabuwar sigar MySQL 8.x an riga an haɗa ta a cikin tsoffin wurin ajiyar RHEL 8 kuma zaka iya shigar dashi ta amfani da umarnin yum mai zuwa.

# yum -y install @mysql

Mataki na 2: Amintaccen MySQL akan Jagora da Bawan Server

Bayan shigarwa, yanzu yakamata ku fara aikin MySQL ɗin da kuka girka kuma sa shi farawa ta atomatik duk lokacin da kuka fara sabar. Sabili da haka, yi amfani da umarni mai zuwa.

# systemctl enable mysqld
# systemctl start mysqld

Na gaba, kuna buƙatar tabbatar da shigarwar MySQL ɗinku ta hanyar tafiyar da rubutun tsaro wanda ya zo tare da ayyukan tsaro da yawa kamar saita kalmar sirri, cire masu amfani da ba a sansu ba, hana izinin shiga tushen nesa, cire bayanan gwaji da sake loda gata.

# mysql_secure_installation

Ci gaba tare da sauran saurin kuma amsa Ee ga duk tambayoyin don haka saita sabar zuwa mafi kyawun ayyukan tsaro.

Mataki 3: Harhadawa cikin MySQL Master Server

Don farawa tare da daidaitawar uwar garken Jagora, ci gaba da buɗe fayil ɗin sanyi na MySQL ta hanyar buga umarnin mai zuwa.

$ sudo vim /etc/my.cnf

A cikin sashin mysqld , sanya layin kamar yadda aka nuna a ƙasa.

bind-address =173.82.120.14
server-id = 1
log_bin =mysql-bin

A ƙarshe, sake kunna sabis ɗin MySQL.

$ sudo systemctl restart mysqld

Yanzu zamu kirkiro mai amfani dashi. Sabili da haka, shiga cikin sabar uwar garken MySQL azaman tushen mai amfani kuma samar da kalmar sirri.

$ sudo mysql -u root -p

Yanzu gudanar da waɗannan umarnin don ƙirƙirar mai amfani mai amfani yayin lokaci guda bawa bawa damar zuwa mai amfani. Ka tuna amfani da adireshin IP na injunan ka.

mysql> CREATE USER 'replica'@'173.82.115.165' IDENTIFIED BY 'strong_password';
mysql> GRANT REPLICATION SLAVE ON *.*TO 'replica'@'173.82.115.165';

Yanzu, zaku rubuta umarni mai zuwa wanda zai buga sunan binary da matsayi.

mysql> SHOW MASTER STATUS\G

Ka tuna ka lura da sakamakon sunan fayil din msql-bin.000002 da matsayinta 939 .

Mataki na 4: Harhadawa cikin Server na MySQL

Kamar dai tsarin kafa maigidan, yakamata kuyi canje-canje masu zuwa ga fayil ɗin mysql bawa.

$ sudo vim  /etc/my.cnf

Endara layuka masu zuwa a cikin fayil ɗin sanyi a ƙarƙashin sashin mysqld .

bind-address =173.82.115.165
server-id = 2
log_bin =mysql-bin

Sake kunna sabar.

$ sudo systemctl restart mysqld

Yanzu mataki na gaba shine saita sabar bawa don yin aiki daga sabar Master. Shiga cikin sabar MySQL.

$ sudo mysql -u root -p

Na farko, dakatar da zaren maimaitawa.

mysql> STOP SLAVE;

Yanzu, gudanar da tambaya mai zuwa wacce zata saita bawan don yin kwatankwacin sabar Jagora.

mysql> CHANGE MASTER TO
    -> MASTER_HOST='173.82.120.14' ,
    -> MASTER_USER='replica' ,
    -> MASTER_PASSWORD='[email ' ,
    -> MASTER_LOG_FILE='mysql-bin.000002' ,
    -> MASTER_LOG_POS=939;

Tabbatar kana amfani da madaidaicin sunan mai amfani da kalmar wucewa ta IP. Hakanan, yi amfani da sunan sunan da matsayin da kuka samo daga babban sabar.

A ƙarshe, rubuta umarni mai zuwa don fara zaren bawa.

mysql> START SLAVE;

Mataki na 5: Gwajin MySQL Jagora-Bawa

A wannan lokacin, kun kammala daidaitawar duka maigidan da kuma sabobin bawa. Yanzu muna buƙatar tabbatarwa idan daidaitawar tana aiki kuma idan kwafin zai iya faruwa.

Don yin wannan, fita zuwa babban uwar garken kuma shiga cikin uwar garken bayanan MySQL.

$ sudo mysql -u root -p

Createirƙiri samfurin bayanai.

mysql> CREATE DATABASE replication_database;

Yanzu fita zuwa sabar Slave kuma sake, shiga cikin sabar bayanan MySQL.

$ sudo mysql -u root -p

Yanzu jera duk bayanan bayanan ta amfani da umarni mai zuwa.

mysql> SHOW DATABASES;

Idan ka ga bayanan da aka kirkira, to saitin Maimaita MySQL Master-Slave yana aiki.

Sauyawa tsari ne mai sauki wanda za'a iya aiwatar dashi cikin sauki. A cikin wannan jagorar, kun koyi yadda zaku iya ƙirƙirar maimaita mashawarcin MySQL don bawa a cikin RHEL 8 Linux.