Freaks City

This guide outlines the implementation of a highly available MySQL dual-master replication cluster protected by Keepalived for automatic VIP failover. The setup ensures continuous database service despite node failures. Prerequisites Two Linux servers: 192.168.199.49 (Node A) and 192.168.199.50 (Node B) Shared virtual IP (VIP): 192.168.199.52 ...

Core Concepts of Sharding Elasticsearch achieves horizontal scalability and fault tolerance through a dual-layer architecture built on shards and replicas. Understanding how data is partitioned and duplicated across cluster nodes is fundamental to deploying robust search infrastructures. A shard functions as an independant Lucene instance that ...

Redis Replication Fundamentals Redis replication enables automatic data synchronization from a primary node (master) to replica nodes (slaves). The master handles write operations while replicas serve read requests. Replicatino Mechanism Replicas initiate synchronization by sending a SYNC command to the master The master starts a background sa ...

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 ...