Khó Chịu Trong Lòng

Theory : The method based on global transaction identifiers (GTIDs) is transactional and therefore does not require working with log files or positions within these files, which greatly simplifies many common replication tasks.  Replication using GTIDs guarantees consistency between source and replica as long as all transactions committed on the source have also been applied on the replica. Enabling log-slave-updates on a replica means, the replica writes updates that are received from a master to its own binary logs. So a replica can become a intermediate master of another replica. This option is a stepping stone for various simple to complex level replication setups and new technologies like Group Replication. 1. General information Master Node 01 IP : 192.168.56.59 Hostname : edb-saigon.taolaoxibup.com OS : Red Hat Enterprise Linux release 9.4 (Plow) MySQL version : Ver 8.0.37-commercial for Linux on x86_64 (MySQL Enterprise Server - Commercial) mysql> show databases; +----...

Theory : The traditional method is based on replicating events from the source's binary log, and requires the log files and positions in them to be synchronized between source and replica. 1. General information Master Node IP: 192.168.56.59 Hostname: edb-saigon.taolaoxibup.com OS: Red Hat Enterprise Linux release 9.4 (Plow) MySQL version: Ver 8.0.37-commercial for Linux on x86_64 (MySQL Enterprise Server - Commercial) Slave Node IP: 192.168.56.29 Hostname: edb-hanoi.taolaoxibup.com OS: Red Hat Enterprise Linux release 9.4 (Plow) MySQL version: Ver 8.0.37-commercial for Linux on x86_64 (MySQL Enterprise Server - Commercial) 2. Preparation on Master/Slave Node Turn off Firewall Disable SELinux Configuring /etc/hosts 192.168.56.59   edb-saigon.taolaoxibup.com     edb-saigon 192.168.56.29   edb-hanoi.taolaoxibup.com       edb-hanoi 3. Update Master/Slave Server config file Master Node [root@mysql-saig...

1. Download MySQL packages from Oracle eDelivery (Server, Shell, ...) [root@mysql-saigon mysql8]# ls -l total 961092 -rw-r--r--. 1 root root   4010566 Mar 31 16:46 mysql-commercial-backup-8.0.37-1.1.el9.x86_64.rpm -rw-r--r--. 1 root root  20388471 Mar 31 16:46 mysql-commercial-backup-debuginfo-8.0.37-1.1.el9.x86_64.rpm -rw-r--r--. 1 root root   4105053 Mar 31 16:46 mysql-commercial-client-8.0.37-1.1.el9.x86_64.rpm -rw-r--r--. 1 root root  27305094 Mar 31 16:46 mysql-commercial-client-debuginfo-8.0.37-1.1.el9.x86_64.rpm -rw-r--r--. 1 root root   1457867 Mar 31 16:46 mysql-commercial-client-plugins-8.0.37-1.1.el9.x86_64.rpm -rw-r--r--. 1 root root   2052547 Mar 31 16:46 mysql-commercial-client-plugins-debuginfo-8.0.37-1.1.el9.x86_64.rpm -rw-r--r--. 1 root root    570629 Mar 31 16:46 mysql-commercial-common-8.0.37-1.1.el9.x86_64.rpm -rw-r--r--. 1 root root   7680309 Mar 31 16:46 mysql-commercial-debuginfo-8.0.37-1.1.el9....