Welcome to follow the public account: Yijie IT The blog posts on this site are published on the public account first. Article directory 1 Environment preparation 2. Mysql8.0 installation 2.2.1 Obtain rpm package 2.2.2 Install and configure MySQL Server 2.2.1 Install database 2.2.2 Initialize database 2.2.3 Remote login 2.2.4 Compatible with old version verification 3 […]
Tag: replication
Advancement of postgresql logical replication slots
Why should the logical replication slot be advanced? We know that the logical replication slot has two functions, one is to protect the system table from being vacuumed, and the other is to protect the xlog and prevent the xlog that needs to be decoded from being recycled. If the system table does not advance […]
Mysql configuration master-slave replication-GTID mode
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 […]
Do you know how to integrate MySQL 8 innodb replication?
Let me introduce the group at the beginning. If you are interested in PolarDB, MongoDB, MySQL, PostgreSQL, Redis, Oceanbase, Sql Server, etc. and have questions, you can join the group if you have any needs. There are big names and CTOs in the major database industry in the group, who can solve your problems. . […]
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 […]
Redis cluster construction – master-slave replication mode
*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 […]
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 […]
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 […]
52.MongoDB replication (copy) set actual combat and analysis of its principles
MongoDB replica set architecture High availability In a production environment, it is not recommended to use a stand-alone version of the MongoDB server. A Mongodb replication set (Replication Set) consists of a set of Mongod instances (processes), including a primary node and multiple secondary nodes. All data from the Mongodb Driver (client) is written to […]
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 […]