Freaks City

Prerequisites: Three servers, MySQL 5.7-glibc installation, master-slave configuration using GTID mode. MySQL Installation Prepare installation package Download MySQL from: https://pan.baidu.com/s/14w-oNT-oeTUujhFAnqjkSAExtract code: g8tk [root@db-node1 install]# ll mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz -rw-r--r-- 1 root root 661214270 ...

Scenario 1: Identical Binlog Filename with Misaligned Offsets When utilizing a Virtual IP (VIP) for high availability, if the current primary and standby nodes share the exact same binary log filename, but the recorded position on the original primary is smaller than the actual position on the newly promoted primary, Canal throws an error resem ...

MySQL Proxy is an official middleware solution from MySQL that provides load balancing, read-write splitting, and failover capabilities. It acts as a connection pool between the application and the data base servers, forwarding frontend requests to the appropriate backend databases. By using Lua scripts, it can implement complex connection cont ...

Redis master-slave replication enables data from one Redis server (the master) to be copied to one or more other Redis servers (slaves). Data flows unidirectionallly—from master to slave. By default, every Redis instance starts as a master. A master can have multiple slaves, but each slave can only replicate from a single master. Key Benefits o ...