Freaks City

pt-table-checksum Prerequisites (Must Verify Before Running Checks) Only a single host can be specified, and it must be the IP address of the primary database. The tool adds S (shared) locks on tables during the check. If the binary log format on the primary or replica is not STATEMENT, you must use the --no-check-binlog-format option. Before ...

Pub/Sub Messaging In Redis, channels decouple producers from consumers. A publisher broadcasts to a channel without knowledge of its audience, while subscribers receive only the channels they follow. This topology eliminates polling: the server pushes messages to all connected clients as soon as they arrive. Every push notification is an array ...

Implementing a robust read-write splitting architecture can significantly enhance database performance and availability by distributing query loads across multiple servers. This setup ensures that write operations are hendled by a dedicated primary server, while read requests are served by one or more secondary servers. This document outlines t ...

Implementing Redis Master-Slave Replication Redis master-slave replicaiton enables data redundancy and read scalability by allowing one Redis server (master) to replicate its data to one or more replica servers (slaves). The master handles write operations while slaves serve read requests, creating a one-to-many replication topology. Cofnigurin ...

This procedure assumes that binary logging (bin-log) is already enabled on the master server, as it is a prerequisite for replication recovery.First, create a dedicated user with appropriate privileges to facilitate the data backup process:[root@server]# mysql -uroot -p mysql> GRANT ALL PRIVILEGES ON *.* TO 'backup_admin'@'192.168.10.5' IDENTIF ...

Table of Contents Introduction to Replication Replication Configuration Establishing Replication Terminating Replication Topology Structures Replication Process Data Synchronization Internals Components Required for PSYNC PSYNC Command Full Synchronization Partial Synchronization Master-Replica Heartbeat Full Sync Triggers Common Configu ...

Redis stands as an open-source, high-performance in-memory data store. Often referred to as a data structure server, it supports various data types including strings, hashes, lists, sets, and sorted sets. These data types allow for atomic operations such as appending to strings, incrementing hash values, adding elements to lists, and performing ...

Multi-Version Concurrency Control (MVCC) 1. What is MVCC? MVCC stands for Multi-Version Concurrency Control. It allows concurrency control by managing multiple versions of data rows. This technology makes consistent reads possible under InnoDB transaction isolation levels. It allows reading rows that are being updated by another transaction, se ...