Tag：Master and slave
-
MySQL setting master-slave configuration in CentOS 7
Master slave configuration, mainly used for backup. Monitor the action of the master server from the server to achieve the purpose of backup. Master server configuration (1) Open profile vim /etc/my.cnf (2) Add Server id = 1 #id value cannot be the same Log bin = / var / lib / MySQL / mysqldata / […]
-
MySQL’s faster drop table method for deleting large tables
MySQL’s faster drop table method for deleting large tables Using hard link and truncate to reduce the impact of drop table on online environment During drop table, all processes, whether DDL or DML, are started by Hang; Continue to execute until the end of drop; This is because InnoDB will maintain a global exclusive lock […]
-
Docker MySQL master-slave installation
1. First, remove the image docker pull mysql:5.7 2. Run image It mainly maps log storage files and configuration files to the host docker run -p 13307:3306 –name mysql-master \ -v /mydata/mysql-master/log:/var/log/mysql \ -v /mydata/mysql-master/data:/var/lib/mysql \ -v /mydata/mysql-master/conf:/etc/mysql \ -e MYSQL_ROOT_PASSWORD=123456 \-d mysql:5.7 [[email protected] ~]# docker run -p 13307:3306 –name mysql-master \ > -v /mydata/mysql-master/log:/var/log/mysql […]
-
Necessary for Architects: principle and application of MySQL master-slave synchronization
In daily work, MySQL database is essential storage, in which read-write separation is basically standard configuration. Behind this, MySQL needs to turn on master-slave synchronization to form a master-slave or master-slave multi-slave architecture. Mastering the principle of master-slave synchronization and knowing how to apply it in practice are the necessary skills of an architect. The […]
-
[issue 33] golang school recruitment interview experience sharing Changtian Tour
1. The execution order of go init is not in accordance with the import rules (in this case, it is executed in the order of file names during compilation) 2. Interface nil comparison. 3. Native map is non thread safe, locking and sync Implementation of map {}. 4. The difference between channel no buffer and […]
-
MySQL of spring boot realizes read-write separation
In high concurrency scenarios, what are the optimization methods for databases? Commonly used implementation methods include the following: read-write separation, caching, master-slave architecture cluster, sub database and sub table. In Internet applications, most of them are“Read more and write less”Set up two libraries, the main library and the read library,“The main database is responsible for […]
-
Redis achieves high concurrency: the principle of redis master-slave replication
preface Redis mainly relies on master-slave architecture to achieve high concurrency.Generally speaking, many projects are enough. A single master is used to write data, a single machine has tens of thousands of QPS, and multiple slaves are used to query data. Multiple slave instances can provide 10W QPS per second. If you want to achieve […]
-
MySQL master-slave synchronization failed
prefaceThe container starts Mysql to quickly solve the master-slave asynchrony. [environmental description] MySQL started by two containers, one master and one slave service IP Port mysql-m 10.xxx.75.7 23306 mysql-s 10.xxx.75.8 23306 [fault] Previously: the project that has been dumped for a long time suddenly needs to be used. Because the slave server was abnormally shut […]
-
Redis master-slave synchronization
Principle: 1. Send the sync command from the server to the master server. 2. The master server receiving the sync command will call the bgsave command to create an RDB file, and use the buffer to record all the next write commands. 3. When the master server executes bgsave command, it will send RDB file […]
-
Essential for Architects: MySQL master-slave delay solution
The last article introducedPrinciple and application of MySQL master-slave synchronization, this paper summarizes the causes and solutions of MySQL master-slave delay. If the master-slave delay is too large, it will affect the business, and appropriate solutions should be adopted. Performance of MySQL master-slave delay Insert or update the update operation first, and then select the […]
-
MySQL basic technology (IV) — how does MySQL ensure high availability?
Previously, I had more than one year of working experience in the client field.Later, I also did back-end business in byte for more than a year.Now I hope to do somethingMySQLSummarize and enrich your accumulation in the back-end field.The contents are as follows: Basic MySQL Technology (I) — how does MySQL query? Basic MySQL Technology […]
-
Mysql database | build master-slave instances of mysql-8.0 or above based on docker
Overview of MySQL master-slave environment Construction of MySQL Cluster master-slave environment This time, docker is used to deploy the cluster, and the master-slave instance is configured first. 1. MySQL Cluster Cluster service planning 2. MySQL Cluster Cluster prerequisites The main configuration directories for creating MySQL Cluster cluster are as follows: 2.1 MySQL master node [3308] […]