Yadda ake Saita MySQL Jagora-Bawa akan Ubuntu 18.04

MySQL master-bawa kwafi hanya ce da ke ba da damar yin kwafi ko kwafe fayilolin bayanai a ƙetaren ɗaya ko fiye a cikin hanyar sadarwa. Wannan saitin yana ba da aiki tare da haƙurin kuskure kamar yadda idan har aka sami gazawa a cikin ƙirar Jagora, ana iya samun bayanan bayanan a cikin kumburin Slave. Wannan yana ba masu amfani kwanciyar hankali cewa duk ba za a rasa su ba a kowane yanayi kamar yadda za a iya dawo da kwatancen bayanan bayanan daga wata sabar ta daban.

A cikin wannan jagorar, zaku koyi yadda ake yin MySQL bayanan Babbar-bawa a kan tsarin Ubuntu 18.04.

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

Master server: 10.128.0.28
Slave server: 10.128.0.29

Yanzu bari mu nutse a ciki mu ga yadda za mu iya saita saitin kwafin-bawa a Ubuntu.

Mataki 1: Sanya MySQL akan Babbar Jagora da Bayi

Wuraren Ubuntu sun ƙunshi sigar 5.7 na MySQL. Don amfani da kowane sabon fasali kuma kauce wa matsaloli, zai kamata ka shigar da sabon tsarin MySQL. Amma da farko, bari mu sabunta nodes biyu ta amfani da umarnin da ya dace.

$ sudo apt update

Don shigar MySQL a kan dukkanin nodes, aiwatar da umarnin.

$ sudo apt install mysql-server mysql-client

Gaba, Bude fayil din mysql.

$ sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

A kan kumburin Jagora, gungura kuma gano alamar daure-adireshin kamar yadda aka nuna a ƙasa.

bind-address 	 =127.0.0.1

Canja adireshin madauki don dacewa da adireshin IP na ƙirar Jagora.

bind-address  	=10.128.0.28

Na gaba, saka takamaiman darajar uwar garken-id sifa a cikin [mysqld] sashe. Lambar da kuka zaɓa bai dace da kowane lambar id-server ba. Bari mu sanya darajar 1 .

server-id	 =1

A ƙarshen fayil ɗin sanyi, kwafa da liƙa layukan da ke ƙasa.

log_bin = /var/log/mysql/mysql-bin.log
log_bin_index =/var/log/mysql/mysql-bin.log.index
relay_log = /var/log/mysql/mysql-relay-bin
relay_log_index = /var/log/mysql/mysql-relay-bin.index

Fita fayil ɗin sanyi kuma sake farawa sabis na MySQL don canje-canje don aiwatar da ƙirar Jagora.

$ sudo systemctl restart mysql

Don tabbatar da cewa sabar MySQL tana gudana kamar yadda ake tsammani, ba da umarnin.

$ sudo systemctl status mysql

Cikakke! MySQL uwar garken yana gudana kamar yadda ake tsammani!

Mataki 2: Createirƙiri Sabon Mai Amfani don Sakewa akan Babbar Jagora

A wannan ɓangaren, zamu ƙirƙiri mai amfani dashi a cikin babban kumburi. Don cimma wannan, shiga cikin sabar MySQL kamar yadda aka nuna.

$ sudo mysql -u root -p

Na gaba, ci gaba da aiwatar da tambayoyin da ke ƙasa don ƙirƙirar mai amfani da shi kuma ba da dama ga bawa. Ka tuna ka yi amfani da adireshin IP naka.

mysql> CREATE USER 'replication_user'@'10.128.0.29' IDENTIFIED BY 'replica_password';
mysql> GRANT REPLICATION SLAVE ON *.* TO 'replication_user '@'10.128.0.29';

Na gaba, gudanar da umarni mai zuwa.

mysql> SHOW MASTER STATUS\G

Kayan aikin ya zama daidai da abin da zaku iya gani a ƙasa.

Kasance mai hankali kuma ka lura da ƙimar mysql-bin.000002 da Matsayin ID 1643 . Wadannan dabi'u zasu zama masu mahimmanci yayin kafa sabar bawa.

Mataki na 3: Sanya Server na MySQL

Fita zuwa uwar garken bawa kuma kamar yadda mukayi tare da uwar garken Master, buɗe fayil ɗin sanyi na MySQL.

$ sudo vim  /etc/mysql/mysql.conf.d/mysqld.cnf

Kamar dai sabar uwar garke, ci gaba da shirya waɗannan layi.

bind-address           = 10.128.0.29

Kamar yadda ya gabata, saka ƙima don uwar garken-id sifa a cikin [mysqld] sashe. Wannan lokacin zaɓi wani darajar daban. Bari mu tafi tare da 2 .

server-id		=2 

Sake, liƙa layukan da ke ƙasa a ƙarshen ƙarshen fayil ɗin daidaitawa.

log_bin = /var/log/mysql/mysql-bin.log
log_bin_index =/var/log/mysql/mysql-bin.log.index
relay_log = /var/log/mysql/mysql-relay-bin
relay_log_index = /var/log/mysql/mysql-relay-bin.index

Sake farawa MySQL uwar garken kan kumburin bawa.

$ sudo systemctl restart mysql

Da zarar an gama, adana da fita daga editan rubutu

Na gaba, shiga cikin harsashin MySQL kamar yadda aka nuna.

$ sudo mysql -u root -p

A wannan matakin, kuna buƙatar yin wasu daidaitattun abubuwa waɗanda zasu ba uwar garken bawa damar haɗi zuwa sabar uwar garken. Amma da farko, dakatar da zaren bawan kamar yadda aka nuna.

mysql> STOP SLAVE; 

Don bawa uwar garken bawa damar maimaita sabar uwar garken, kunna umarnin.

mysql> CHANGE MASTER TO MASTER_HOST ='10.128.0.28', MASTER_USER ='replication_user', MASTER_PASSWORD ='[email ', MASTER_LOG_FILE = 'mysql-bin.000002', MASTER_LOG_POS = 1643;

Idan kuna da sha'awar isa, za ku lura cewa mun yi amfani da mysql-bin.00002 ƙima da matsayin ID 1643 da aka nuna a baya bayan ƙirƙirar mai amfani da bawan bayi.

Bugu da ƙari, an yi amfani da adireshin IP na uwar garken Babbar Jagora, mai amfani da kwafi da kalmar wucewa.

Daga baya, fara zaren da kuka tsayar da farko.

mysql> START SLAVE;

Mataki na 4: Tabbatar da Maimaita MySQL Master-Slave

Don bincika idan saitin yana aiki kamar yadda ake tsammani, zamu ƙirƙiri sabon rumbun adana bayanai akan maigidan sannan mu duba inga an sake yin sa a sabar bawa ta MySQL.

Shiga cikin MySQL a cikin uwar garken Master.

$ sudo mysql -u root -p

Bari mu kirkiro bayanan gwaji. A wannan yanayin, zamu ƙirƙiri wani matattarar bayanai da ake kira replication_db.

mysql> CREATE DATABASE replication_db;

Yanzu, shiga cikin misalin MySQL a cikin sabar bawa.

$ sudo mysql -u root -p

Yanzu jera bayanan bayanan ta amfani da tambaya.

mysql> SHOW DATABASES;

Za ku lura da bayanan bayanan da kuka ƙirƙira akan maigidan an maimaita shi akan bawa. Madalla! Saƙonku na MySQL Master-bawa yana aiki kamar yadda aka zata! Yanzu zaku iya tabbatar da cewa idan aka sami matsala, za'a sake buga kwafin fayilolin bayanai zuwa sabar bawa.

A cikin wannan jagorar, kun koyi yadda ake saita saitin kwafin MySQL Master-bawa akan Ubuntu 18.04.