Freaks City

Installation MongoDB 5.0 Installation Refer to the official documentation: https://docs.mongodb.com/manual/tutorial/install-mongodb-on-red-hat/ MongoDB 3.4 Installation (Tarball Method) The yum repository for 3.4 is no longer available, so manual installation via tarball is required. sudo groupadd mongod sudo useradd -r -g mongod -s /sbin/nolog ...

Understanding MySQL Binary Logs The binary log (often called binlog) is a set of files that stores details about data modifications and potentially data-changing events. It captures operations like INSERT, UPDATE, and DELETE, along with timestamps and execution details. Queries that do not alter data, such as SELECT or SHOW, are omitted. These ...

Delete Operation Failure on Replica When a record is deleted on the primary but doesn't exist on the replica, replication halts with an error. Last_SQL_Error: Could not execute Delete_rows event on table app.users; Can't find record in 'users', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000008, end_lo ...

Configuring permissions for Alibaba Canal involves standard replication grants, specifically REPLICATION SLAVE and REPLICATION CLIENT. However, the requirement for the SELECT privilege often leads to confusion regarding its necessary scope—whether it must be applied at the database level or if table-level access suffices. Initial testing in loc ...

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