*Note: In the fourth specific operation, it is recommended to allocate IP independently, so that the redis IP will not change after the server is restarted, otherwise the host IP in your slave conf will become invalid 1. Create a custom network type docker network create –subnet=172.10.0.0/16 haveyb-network 2. Create redis-master container docker run -itd […]
Tag: master-slave
Redis persistence RDB + master-slave replication principle + Redis persistence AOF
1. RDB for redis persistence Redis provides 2 different forms of persistence. RDB (Redis DataBase) AOF (Append Of File) 1.What is RDB Write a snapshot of the data set in the memory to the disk within a specified time interval, which is also called a Snapshot in the jargon. When it is restored, the snapshot […]
K8s deploys Mysql master-slave cluster
K8s deploys Mysql master-slave cluster 1. Create namespace.yaml file 2. Create namespace 3. Create a Secret for Mysql password 4. Install the MySQL master node 5. Deploy the MySQL master node 6. Install the first slave node Slave 7. Create a second Slave node 8. Test 9. Test the master-slave cluster 1. Create namespace.yaml file […]
CentOS7.5MySQL5.7 master-slave replication
1. Introduction to master-slave replication 1.1. Advantages of master-slave replication Separation of reading and writing. In a system with complex business, there is a scenario where a SQL statement requires a table lock, resulting in the temporary inability to use the read service, which greatly affects the running business. Use master-slave replication to let the […]
[EI Recurrence] Dynamic pricing and energy management of multi-virtual power plants in master-slave game based on meta-model optimization algorithm (Matlab code implementation)
Welcome to this blog Advantages of bloggers:Blog content should be as thoughtful and logical as possible for the convenience of readers. Motto:He who travels a hundred miles is half as good as ninety. The directory of this article is as follows: Table of Contents 1 Overview 2 Operation results 3 References 4 Matlab code, data, […]
MySQL master-slave synchronization-Gtid
【A Hundred Refinements to Become a Demon】MySQL master-slave synchronization-Gtid Server preparation IP Node Configuration System version 191.168.117.143 master 2c2g40g centos 7.9 192.168.117.142 slave 2c2g40g centos 7.9 Environment preparation The following operations need to be performed on both machines Turn off firewall systemctl stop firewalld & amp; & amp; systemctl disable firewalld setenforce 0 & amp; […]
Mysql database-master-slave
Installation and deployment 1.1 Download Official website download address: https://dev.mysql.com/downloads/mysql/ Current time: 2023-10-24. The latest version is the innovative version of 8.1. Here, choose the stable version 8.0 [root@localhost opt]# uname -a Linux localhost.localdomain 3.10.0-1160.el7.x86_64 #1 SMP Mon Oct 19 16:18:59 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux Select the corresponding version Mysql After the download […]
MySQL master-slave replication (based on GTID–transaction ID method)
Directory 1. GTID related concepts 1.What is GTID? 2. Concept of GTID master-slave replication method 3. Advantages and disadvantages of GTID 2. Working principle of GTID 3. Deploy master-slave replication 4. Test synchronization 1. Create a new database on the main database 2. Check whether the synchronization is successful from the library 5. Reset the […]
MySQL master-slave synchronization-binlog
MySQL master-slave synchronization-binlog Server preparation IP Node Configuration System version 191.168.117.143 master 2c2g40g centos 7.9 192.168.117.142 slave 2c2g40g centos 7.9 Environment preparation The following operations need to be performed on both machines Turn off firewall systemctl stop firewalld & amp; & amp; systemctl disable firewalld setenforce 0 & amp; & amp; sed -i ‘s/SELINUX=.*/SELINUX=disabled/g’ /etc/selinux/config […]
centos7 installs docker, docker-compose, mysql master-slave replication
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 […]