Tag：Master and slave
-
Time：2021-4-12
We often hear that redis has high reliability. What is the meaning of high reliability here?① Less data loss② Less service disruption ① Guaranteed by AOF and RDB② Through multiple instances to save data backup guarantee, that is, multiple machines save a copy of data, even if machine a is down, there are machine B […]
-
Time：2021-4-7
Common architecture of redis Master and slave One master and many followers Master slave read write separation Daemonize no docker requires at least one foreground process in the container, so it cannot be set as a daemon Setting master IP replicaof < masterip > < masterport > from slave node version: ‘3’ services: master: image: […]
-
Time：2021-3-31
The harder you work, the luckier you are,This article has been collected in GitHub Java community, which has interview sharing, source code analysis series articles, welcome to collect, likehttps://github.com/Ccww-lx/Ja… In actual projects, high availability of services is very important, such as whenRedisAs a cache service, it can relieve the pressure of database, improve the speed […]
-
Time：2021-3-23
Gtid definition Gtid (global transaction identifier) global transaction identifier. Gtid is a significant improvement on master-slave replication introduced in version 5.6. Compared with the master-slave replication based on binlog file + position in the previous version, the master-slave replication based on gtid has higher data consistency, more robust master-slave data replication, less error prone master-slave […]
-
Time：2021-3-18
Other blogs: Thinkp6 note 12: multi database configuration www.manongjc.com/detail/15-puxjgeek… config\ database.php code return [ app\api\model\CrmBaseModel.php <?php app\api\model\CrmTestModel.php <?php Configuration file.env [DATABASE] This work adoptsCC agreementReprint must indicate the author and the link of this article
-
Time：2021-3-18
Leancache is a high performance, high available memory storage service for cloud engine users. Compared with our previous data storage service, it can not only handle more concurrent connections and requests, greatly improve application performance, but also reduce the cost of data storage. Leancache is suitable for scenes such as second kill, red packet grabbing, […]
-
Time：2021-3-12
Write on the front Recently, I’m writing a topic about MYCAT. As many of my friends are going out for an interview recently, I asked if I could simply write down the principle and precautions of master-slave replication in mysql, because I was asked these questions in the previous interview. Me: Yes, it’s arranged!! Principle […]
-
Time：2021-3-11
preface I have configured the master-slave of windows before. Now let’s review the master-slave configuration of docker Master slave principle Master library — curd operation — record to binlog log — store to ready log through IO thread — SQL thread — write to slave Library to configure Master configuration #Master configuration Server id = […]
-
Time：2021-3-6
problem Today, we found that the master-slave database of MySQL is not synchronized Go to the master library first: mysql>show processlist; Check whether the next process has too many sleep. It’s normal. show master status; It’s normal, too. mysql> show master status; +——————-+———-+————–+——————————-+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +——————-+———-+————–+——————————-+ | mysqld-bin.000001 […]
-
Time：2021-3-6
<div style=”margin: 0px auto; color: rgb(85, 85, 85); max-width: 23cm; padding: 1em;”><div style=”margin: 0px; padding: 0px;”><div style=” padding:8px; “> < H3 style =” font family: & quot; Pt sans narrow & quot;, sans serif; font weight: 700; line height: 1.1em; color: rgb (133, 153, 0); font size: 1.4em; “> IO multithreading</h3> <p>In the past, redis […]
-
Time：2021-3-4
The configuration of the redis master-slave server is omitted. The following is based on how you have configured it and how to use it in the laravel environment. to configure Laravel uses the predis extensioncomposer require predis/predisvi config/database.php ‘redis’=>[ ‘cluster’ => false, ‘default’ => [ “tcp://” . env(“REDIS_ DEFAULT_ HOST”) . “:” . env(“REDIS_ DEFAULT_ […]
-
Time：2021-3-2
The master-slave replication function provided by MySQL database itself can easily realize multiple automatic backup of data and realize the expansion of database. Multiple data backup can not only enhance the security of data, but also further improve the load performance of the database through the implementation of read-write separation. In this paper, we mainly […]
