centos7 installs docker, docker-compose, and mysql master-slave replication 1. Install docker # Install dependencies yum install -y yum-utils #Set the docker warehouse image address yum-config-manager –add-repo http://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo # View all available docker-ce versions yum list docker-ce –showduplicates | sort -r # Select a docker-ce version to install yum -y install docker-ce-23.0.6-1.el7 # Set docker to […]
Tag: replication
Redis-3 persistence and master-slave replication
Redis persistence files are divided into two types: dump.rdb and appendonly.aof 1. Redis persistence RDB Redis provides 2 different forms of persistence methods RDB (Redis DataBase) AOF (Append Of File) 1. What is RDB Write a snapshot of the data set in memory to disk within a specified time interval, which is also known as […]
Redis master-slave mode (2) topology and replication process
Table of Contents 1. Replication topology in Redis master-slave mode 1.1 One master and one slave structure 1.2 One master and multiple slaves structure 1.3 Tree master-slave structure 2. Master-slave replication process 2.1 Master-slave replication establishment replication flow chart 2.2 Data synchronization (psyc) 1.replicationid/replid (replication id) 2.offset(offset) 2.3 psync running process 2.4 Full copy 2.5 […]
PostgreSQL Replication Slot Analysis and Research
PostgreSQL 9.4 begins to support the new feature of Replication Slot. Regarding Replication Slot, there is not much introduction in the document, and it is difficult to understand what it does at first glance. In fact, the emergence of Replication Slot mainly paves the way for the eventual realization of logical replication and bidirectional replication […]
Docker: Create a Redis cluster with master-slave replication
1. Redis cluster In actual projects, it is generally not possible to simply deploy the Redis server on only one server, because a single Redis server cannot meet the pressure of high concurrency. In addition, if the server or the Redis server fails, the entire system may collapse. Projects generally use master-slave replication mode to […]
Mendelian randomization (literature replication)
Two-sample Mendelian randomization – literature replication Article directory Preface 1. Writing ideas 2. Data source 3. MR code 1. Read exposed data 2. Read the ending data 3. Reconcile data 4. Perform mr analysis 5. Heterogeneity test 6. Horizontal pleiotropy test 7. Single snp effect value + leave one out Summarize Foreword About the reproduction […]
Master-slave replication is interrupted due to changing the MySQL replication account password.
Author | JiekeXu Source | Public account JiekeXu DBA road (ID: JiekeXu_IT) If you need to reprint, please contact us for authorization | (Personal WeChat ID: JiekeXu_DBA) Hello everyone, I am JiekeXu. I am very happy to meet you again. Today I will take a look at the master-slave replication exception caused by changing the […]
Use Docker to quickly build Redis master-slave replication
Directory I. Introduction 2. Pull the Redis image 3. Create the mounting directory and add the configuration file 3.1. Master node (6379) 3.2. Slave node (6380) 3.3. Slave node (6381) 4. Start the Redis container 4.1. Master node (6379) 4.2. Slave node (6380) 4.3. Slave node (6381) 4.4. Introduction to startup command parameters 5. Check […]
A brief discussion on ClickHouse data sharding and replication
ClickHouse data sharding and replication: in-depth understanding of data sharding and replication mechanisms ClickHouse is a high-performance columnar database management system suitable for real-time analysis and big data processing. In order to achieve high availability, load balancing and horizontal expansion, ClickHouse provides data sharding and replication mechanisms, and supports cluster configuration, distributed table creation and […]
02. MySQL——-master-slave replication
Directory 7. MySql master-slave replication Start master-slave replication: principle: accomplish: 1. Create nodes 2. Create database 3. Master-slave configuration 1. Master node 2. Slave node 4. Test: 5. Question: 1. uuid modification 2.service_id 3. Reading and writing are not synchronized method 1: Method 2: 7. MySql master-slave replication Start master-slave replication: 1. Open virtual machines […]