Freaks City

Core Mechanisms of Dameng Data WatchDameng (DM) database high availability clusters are established through the Data Watch framework. The foundational mechanism involves transmitting Redo logs from the primary instance to standby instances, which then apply these logs to maintain data synchronization. By manipulating specific parameters and int ...

1. Core Concepts MongoDB is a distributed, document-oriented NoSQL database system written in C++. It stores data in flexible, JSON-like documents where data structures consist of key-value pairs. This design allows for dynamic schemas, making it highly adaptable to evolving application requirements. 2. Comparison: Relational vs. Document While ...

A business system recently experienced significant lag on its replica databases, failing to catch up with the primary database, posing considerable operational risks. Despite low CPU, IO, and network usage on the replica servers, indicating no resource bottlenecks, parallel replay was enibled. The SHOW PROCESSLIST command showed continuous repl ...

Before configuring MySQL master-slave replication, ensure both servers run the same MySQL version and have compatible system configurations. Configure the Master Server Edit the MySQL configuration file /etc/my.cnf on the master node: [mysqld] log-bin=mysql-bin server-id=101 log-bin enables binary logging, required for replication. server-id ...

Installing Redis and Enabling Auto-start Install Redis and configure it to start automatically at system boot. Deploying Multiple Redis Instances Set up multiple Redis servers for redundancy and high availability. Configuring Redis Password Authentication Secure Redis instances using password-based authentication. Setting Up Redis Persistence C ...

Redis delivers high-speed read/write performance but can face heavy read loads under production traffic. To distribute this load, Redis supports master-slave replication, enabling one-to-many or cascading topologies. Replication operates via full synchronization (during initialization) or incremental synchronization (for ongoing updates). Benef ...

The primary tables used for this purpose are: replication_group_members replication_group_member_stats replication_group_members Table This table displays network and status information for replication group members. The network addresses shown are the ones used to connect clients to the group. mysql> SELECT * FROM performance_schema.re ...

Cluster Configuration Overview Hostname IP Address Installed Components Service Port centf8118.sharding1.db 192.168.81.18 clickhouse-server, clickhouse-client 9000 centf8119.sharding2.db 192.168.81.19 clickhouse-server, clickhouse-client 9000 centf8120.sharding3.db 192.168.81.20 clickhouse-server, clickhouse-client 9000 Cluster De ...

Introduction In traditional MySQL master-slave replication architectures, the slave database primarily serves as a backup of the master data. When the master database fails, the entire system becomes unavailable until manual failover procedure are completed. To address this limitation, we can implement a MySQL dual-master configuration where on ...

Environment Setup Required components: Ubuntu 22.04.3 LTS (four virtual machines) MySQL 8.0.35 ProxySQL 2.5.5 MySQL Master-Slave Replication Configuration Installing MySQL on All Servers Update package index and install MySQL server: sudo apt update sudo apt install mysql-server Master Server Configuration Edit MySQL configuration file: sudo ...