The "pit" you don't know in MySQL master-slave synchronization architecture
The following actions are for specifying an unsynchronized Library
Binlog format = row mode
View the binlog mode of the master and slave
mysql> show slave status\G
*********************** 1. row *************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.22.171
Master_User: rep
Master_Port: 330 ...
Posted by jrinco11 on Thu, 14 Nov 2019 05:13:39 -0800
SpringBoot+Poller Long Connection Implements Scavenging Logon Function Demo-Postman Simulated Scavenging Request
Scavenging Logon Function Demo-Postman Simulated Scavenging Request
Scavenging Logon Function - Polling or Long Connection WebSocket - Zxing Generate 2D Code
Scavenging login is actually a login request, but the information is stored on the user's mobile phone. It also needs two-dimensional code to verify whether the matching method can be used ...
Posted by Rob2005 on Wed, 13 Nov 2019 23:15:23 -0800
redis environment deployment
Welcome to join the operation and maintenance development technology exchange group (QQ:722381733)
I. Redis Service Introduction:
Redis is simply a database, a database container used to store the cache. It is mainly designed to make the project data write into the cache and provide users with a more comfortable experience. Or it can also b ...
Posted by gabeg on Wed, 06 Nov 2019 09:40:04 -0800
Spring boot uses redis cache
1. pom import dependency
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-redis</artifactId>
</dependency>
<dependency>
<groupId>redis.clients</groupId>
<artifactId>jedis</artifactId>
</depe ...
Posted by savedlema on Tue, 05 Nov 2019 10:44:31 -0800
Using swoole+websocket and redis to realize web one-to-one chat
Redis implements that each service connected to websocket is bound to a unique user. Save to redis through user account = websocket fd.
mysql implements the offline message pool. If a user is not online, messages sent to him by other users are temporarily stored in mysql. When the user is online, it is taken out from the offline message pool an ...
Posted by Eal on Tue, 05 Nov 2019 06:13:55 -0800
Introduction to the use of Celery in Django
Celery introduction
Cellery is a simple, flexible and reliable distributed system dealing with a large number of messages, and provides the necessary tools to maintain such a system.
It is a task queue that focuses on real-time processing and supports task scheduling.
What is task queue
Task queue: a mechanism to distribute tasks between thread ...
Posted by seaten on Mon, 04 Nov 2019 20:40:47 -0800
Getting started with redis5 cluster cluster
I. modify the configuration file
#Start port
port 5001
#Background operation
daemonize yes
#Process ID file storage location
pidfile /var/run/redis_6379.pid
#Log ID file storage location
logfile /home/whqlkj/redis-cluster/5001/redis-server.log
#Data file storage location
dir /home/whqlkj/redis-cluster/5001/
#AOF persistence
appendo ...
Posted by freeheader on Mon, 04 Nov 2019 19:11:53 -0800
Redis cluster deployment details
Blog Outline:I. Redis cluster related conceptsII. Deployment of Redis cluster
1. Deployment environment
2. Configure Redis instance
3. Configure multiple Redis instances of node06 host
4. The host node01 is installed and configured with the running environment of ruby to facilitate the management of Redis cluster
5. Configure each node in th ...
Posted by thefury on Mon, 04 Nov 2019 16:16:20 -0800
springboot integrated J2Cache
J2Cache is a two-level caching framework currently being used by OSChina. First level cache usage Ehcache , second level cache uses Redis . Because a large number of cache reads will cause L2 network to become the bottleneck of the whole system, the goal of L1 is to reduce the number of L2 reads. This caching framework is mainly used in ...
Posted by yuan on Sun, 03 Nov 2019 11:52:51 -0800
Flask -- database connection pool
Catalog
Database connection pool
pymsql linked database
Database connection pool version
Database connection pool
pymsql linked database
import pymysql
conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='123456', db='s8day127db')
cursor = conn.cursor(cursor=pymysql.cursors.D ...
Posted by johnSTK on Sun, 03 Nov 2019 02:52:08 -0800