Table of Contents master-slave replication Definition of master-slave replication The principle of master-slave replication Advantages of master-slave replication Master-slave replication form Master-slave replication mode Type of master-slave replication GTID mode The concept of GTID Advantages of GTID The principle of GTID GTID configuration Mysql main server ?edit Mysql slave server ?edit Master-slave replication Definition of […]
Tag: master-slave
MySQL single table is too large, master-slave mode, synchronization mode optimization principle
Article directory Is the performance of MYSQL severely degraded when the data in a single table reaches 20 million? Preface InnoDB index data structure B + tree Sharding Sphere sub-database and table Sharding-JDBC Sharding-JDBC related concept description logical table Broadcast table binding table Sharding-Sharding strategy in JDBC Automatic sharding algorithm Modulo sharding algorithm Hash modulo […]
Locust single-machine multi-core stress test, and data communication processing of master-slave nodes
Let me briefly explain the background first. Before the APP is launched, the login interface needs to be performance tested. After evaluation, I gave priority to locust for script development. This time I used locust’s single-machine multi-core running capability, but it also involves data communication between master and slave nodes. There are very few effective […]
[MySQL5.7 Kirin system, offline installation under ARM architecture, building master-slave cluster]
MySQL5.7 Master-Slave Cluster Deployment Manual 1. Check the local operating system #Be sure to check the operating system of the machine, whether it is amd (x86) or arm (aarch) architecture uname -a cat /etc/os-release Note: MsSQL8.0 has only supported arm architecture since then. We can go to a third party to download the compiled installation […]
“Understand in one article” Redis master-slave synchronization mechanism
Contents of this chapter Main functions The main functions of Redis master-slave synchronization are as follows: Data redundancy: Hot backup of data is achieved through master-slave synchronization, which is a data redundancy method in addition to persistence. Failure recovery: When a problem occurs on the master node, the slave node can continue to provide services […]
k8s builds MySQL master-slave synchronization
env k8s: v1.28.2 mysql: v8.0.34 Build nfs server 1. Execute the installation commands on 3 machines respectively yum install -y nfs-utils 2. Create 3 directories on the master node and write them to /etc/exports mkdir -p /data/nfs/{<!– –>mysql-master,mysql-slaver-01,mysql-slaver-01} cat >> /etc/exports << EOF /data/nfs/mysql-master *(rw,sync,no_root_squash) /data/nfs/mysql-slaver-01 *(rw,sync,no_root_squash) /data/nfs/mysql-slaver-02 *(rw,sync,no_root_squash) 3. Start the nfs server systemctl […]
CoDeSys series-4, build Profinet master-slave environment based on Ubuntu’s codesys runtime extension package
CoDeSys series-4, building Profinet master-slave environment based on Ubuntu’s codesys runtime extension package Article directory CoDeSys series-4, build Profinet master-slave environment based on Ubuntu’s codesys runtime extension package I. Introduction 2. Data collection 3. Ubuntu 18.04 from installation to replacement of real-time kernel 1. Download and install Ubuntu18.04 2. Download and install the real-time kernel […]
Locust single-machine multi-core stress test, and data communication processing of master-slave nodes
1. Background This is an interface performance test done 2 months ago, about the single-machine multi-core operation of the locust script, and the data communication between the master and slave nodes. Let me briefly explain the background first. Before the APP is launched, the login interface needs to be performance tested. After evaluation, I gave […]
Locust single-machine multi-core stress test, and data communication processing of master-slave nodes
1. Background This is an interface performance test done 2 months ago, about the single-machine multi-core operation of the locust script, and the data communication between the master and slave nodes. Let me briefly explain the background first. Before the APP is launched, the login interface needs to be performance tested. After evaluation, I gave […]
k8s mysql master-slave replication (with password) ubuntu arm kernel
Install NFS service ## Installation sudo apt install nfs-kernel-server ## start up sudo /etc/init.d/nfs-kernel-server start ## Create a directory mkdir /data/nfs sudo chmod -R 777 /data/nfs ## Share nano /etc/exports ## Add to end of file /var/nfs *(insecure,rw,sync,no_root_squash) ## Restart sudo /etc/init.d/nfs-kernel-server restart Install Helm ## Installation curl https://raw.githubusercontent.com/helm/helm/main/scripts/get-helm-3 | bash ## Add and modify […]