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.
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
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
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.
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
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
I. project structure
1. Engineering structure
2. Module naming
Shard common entity: common code block
Shard open Intel: open interface management
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
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
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.
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
> 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 (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
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 database management command
Usage: mysql [OPTIONS] [database]
--help #View help d ...
Posted on Tue, 15 Oct 2019 15:50:10 -0400 by jblallement