Otu esi edozi MySQL Master-Slave Replication na RHEL 8

MySQL replication bụ usoro ebe data sitere na otu ihe nkesa na-akpaghị aka na-eṅomi ma ọ bụ na-emegharị na ọzọ ndabere nkesa na ozugbo. Ntugharị na-enye redundancy na mmegide mmejọ ma na-enye onye ọrụ udo nke uche na ọbụna mgbe ọdịda na nna ukwu nkesa, data ka nwere ike nwetaghachi.

N'ime nkuzi a, ị ga-amụta ka esi ahazi na melite MySQL master-ohu replication na RHEL 8 Linux.

Na nhazi ahụ, anyị ga-enwe sava abụọ na-agba RHEL 8 nwere adreesị IP ndị a.

Master = 173.82.120.14
Slave  = 173.82.115.165

Ka anyị gaa n'ihu hụ ka anyị nwere ike isi hazie MySQL Master-ohu replication setup na RHEL 8 Linux.

Kwụpụ 1: Wụnye MySQL na Master na Server Server

1. Ụdị MySQL 8.x kachasị ọhụrụ abanyelarị na ebe nchekwa ndabere nke RHEL 8 ma ị nwere ike ịwụnye ya site na iji iwu yum na-esonụ.

# yum -y install @mysql

Kwụpụ 2: Chekwaa MySQL na Master na Server Server

Mgbe echichi ahụ gasịrị, ị ga-amalite ugbu a ọrụ MySQL ị rụnyere ma mee ka ọ malite na-akpaghị aka mgbe ọ bụla ịmalitere ihe nkesa ahụ. Ya mere, jiri iwu na-esonụ.

# systemctl enable mysqld
# systemctl start mysqld

Na-esote, ịkwesịrị idobe nrụnye MySQL gị site na iji edemede nchekwa nke na-abịa na ọtụtụ ọrụ dabere na nchekwa dị ka ịtọ ntọala paswọọdụ mgbọrọgwụ, wepụ ndị ọrụ na-amaghị aha, ekwe ka nbanye mgbọrọgwụ n'ime ime, wepụ nchekwa data ule na ibugharị ihe ùgwù.

# mysql_secure_installation

Gaa n'ihu na ngwa ngwa ndị ọzọ wee zaa Ee ajụjụ niile wee guzobe sava ahụ ka ọ bụrụ usoro nchekwa kacha mma.

Kwụpụ 3: Ịhazi MySQL Master Server

Iji malite na nhazi ihe nkesa Master, gaa n'ihu ma mepee faịlụ nhazi MySQL site na ịpị iwu a.

$ sudo vim /etc/my.cnf

Na ngalaba mysqld, tinye ahịrị dị ka egosiri n'okpuru.

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

N'ikpeazụ, malitegharịa ọrụ MySQL.

$ sudo systemctl restart mysqld

Ugbu a, anyị ga-emepụta onye na-emegharị ihe. Ya mere, banye na MySQL nna ukwu nkesa dị ka mgbọrọgwụ ọrụ ma nye paswọọdụ.

$ sudo mysql -u root -p

Ugbu a, mee iwu ndị a ka ịmepụta onye ọrụ oyiri ma n'otu oge ahụ na-enye ohu ohere ịnweta onye ọrụ. Cheta iji adreesị IP igwe gị.

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

Ugbu a, ị ga-apịnye iwu na-esonụ nke ga-ebipụta aha faịlụ ọnụọgụ abụọ na ọnọdụ.

mysql> SHOW MASTER STATUS\G

Cheta ideba aha faịlụ msql-bin.000002 gapụtara na ọnọdụ ya 939.

Kwụpụ 4: Ịhazi sava MySQL

Dịka usoro nke ịtọlite nna ukwu, ị kwesịrị ime mgbanwe ndị a na faịlụ nhazi ohu mysql.

$ sudo vim  /etc/my.cnf

Tinye ahịrị ndị a na faịlụ nhazi n'okpuru ngalaba mysqld.

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

Malitegharịa ihe nkesa ahụ.

$ sudo systemctl restart mysqld

Ugbu a nzọụkwụ ọzọ bụ ịhazi ihe nkesa ohu ka ọ megharịa site na ihe nkesa Master. Banye na ihe nkesa MySQL.

$ sudo mysql -u root -p

Nke mbụ, kwụsị eriri mmegharị ahụ.

mysql> STOP SLAVE;

Ugbu a, gbaa ajụjụ na-esonụ nke ga-ahazi ohu ahụ ka ọ megharịa site na sava Master.

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;

Gbaa mbọ hụ na ị na-eji aha njirimara na paswọọdụ IP ziri ezi. Ọzọkwa, jiri aha faịlụ na ọnọdụ ị nwetara site na sava ukwu.

N'ikpeazụ, pịnye iwu na-esonụ ka ịmalite eriri ohu.

mysql> START SLAVE;

Kwụpụ 5: Na-anwale nsụgharị MySQL Master-Slave

N'ebe a, ị dechara nhazi nke ma nna ukwu na ohu ohu. Ugbu a, anyị kwesịrị iji nyochaa ma ọ bụrụ na nhazi ahụ na-arụ ọrụ ma ọ bụrụ na mmegharị ahụ nwere ike ime.

Iji mee nke a, gaa na ihe nkesa nna ukwu wee banye na ihe nkesa nchekwa data MySQL.

$ sudo mysql -u root -p

Mepụta ihe atụ nchekwa data.

mysql> CREATE DATABASE replication_database;

Ugbu a gaa na nkesa ohu ọzọ, banye na sava nchekwa data MySQL.

$ sudo mysql -u root -p

Ugbu a depụta ọdụ data niile site na iji iwu a.

mysql> SHOW DATABASES;

Ọ bụrụ na ị na-ahụ nchekwa data emepụtara, mgbe ahụ MySQL Master-Slave Replication setup na-arụ ọrụ.

Ntugharị bụ usoro dị mfe nke enwere ike ịme ngwa ngwa. N'ime ntuziaka a, ị mụtala otu ị ga-esi mepụta mmegharị nke onye nwe MySQL ka ọ bụrụ ohu na RHEL 8 Linux.