At the scene of a large-scale car accident, e-commerce is oversold. Who will carry this pot?

background Xiaoming works in an online shopping mall. Recently, he has a new demand. He needs to develop a commodity seckill module. The demand is urgent. The boss requires that it be online as soon as possible. programme Xiaoming did this at the beginning. He used the database lock directly to control, obtain and lock the quantity of seckill ...

Posted on Thu, 17 Oct 2019 01:53:24 -0400 by stevenszabo

MySQL command line artifact: Mycli

Mycli is a MySQL command-line client tool, which has automatic completion and syntax highlighting functions. It is a tool developed by Indians based on python. It is suitable for beginners or people who are familiar with database but can't remember commands. It can overcome the difficulty of not remembering commands. Official website: ht ...

Posted on Wed, 16 Oct 2019 13:26:53 -0400 by meltingpotclub

Linux builds MySQL master slave

Achieve goals Set up two MySQL servers (one master and one slave), one as the master server and one as the slave server. The master server writes and the slave server reads. Workflow overview Primary server: Open binary log Configure a unique server ID Get the name and location of the master binary log file Create a user account for slave and ...

Posted on Wed, 16 Oct 2019 12:41:33 -0400 by Fahid

Kafka learning notes - Kafka consumer API

I. Kafka consumer profile Kafka and other message systems have a different design, adding a layer of group on top of consumer. Consumer Group is a scalable and fault-tolerant consumer mechanism provided by Kafka. Consumers of the same group can consume messages of the same topic in parallel, but consumers of the same group will not consume the ...

Posted on Wed, 16 Oct 2019 11:49:32 -0400 by mchip

Spring cloud realizes real-time database expansion under the mode of sub database and sub table

I. project structure 1. Engineering structure 2. Module naming Shard common entity: common code block Shard open Intel: open interface management shard-eureka-7001: Registry shard-two-provider-8001: Service Based on two libraries shard-three-provider-8002:8002 services based on three libraries 3. Code dependency structure 4. Project star ...

Posted on Wed, 16 Oct 2019 11:12:32 -0400 by echoninja

One of the design modes: single instance mode [creation mode]

The creation mode is divided into the following types. Singleton mode: a class can only generate one instance. The class provides a global access point for external access to the instance. Its extension is the limited multiple instance mode. Prototype pattern: an object is used as a prototype, and multiple new instances similar to the proto ...

Posted on Wed, 16 Oct 2019 05:57:11 -0400 by suigion

Spring 5 source code deep parsing - transaction rollback and commit (100% understanding of transaction)

The previous article explained how to obtain transactions and set read-only and isolation level through the acquired connection. This article explained the rollback and commit of the remaining transactions. Rollback processing We have completed the transaction preparation before the running of the target method, and the biggest purpose of the ...

Posted on Tue, 15 Oct 2019 23:44:37 -0400 by SystemWisdom

Installation of database pressure measuring tool Sysbench-0.4.12

> Recently, the company is going to oracle and migrate to mysql cluster. We choose mycat as the technology of distributed database middleware. There is no doubt that the preparatory work needs to be done well in the early stage. With the help of the operation and maintenance students, the cluster has been set up. Next, our task is the press ...

Posted on Tue, 15 Oct 2019 21:57:57 -0400 by Mind freak

Spring Boot integrates Mybatis to add, query, delete and modify the database

Spring Boot integrates Mybatis to add, query, delete and modify the database (3) Then the content of the previous section continues to be sorted out. This section will realize the operation of adding, querying, deleting and modifying the database. If you don't say much, just open it! First, the cont ...

Posted on Tue, 15 Oct 2019 16:08:52 -0400 by sweetstuff2003

Introduction to common commands of MySQL basic introduction

Next: MySQL database master slave synchronization process mysql command introduction mysql is a database management command adopt mysql --help To view relevant parameters and instructions mysql --help #mysql database management command Usage: mysql [OPTIONS] [database] #Grammatical format --help #View help d ...

Posted on Tue, 15 Oct 2019 15:50:10 -0400 by jblallement