如何处理并发情况下涉及多个表下数据的操作?
产品给的需求是: 做一个抽奖活动，用户每天的抽奖次数有限(根据其当天的消费行为获得)，用户如果中奖，那么就要修改用户今天抽了几次，修改用户资产(发放奖励)，增加一条log。
这里就涉及多个表需要防止并发，log表要防止并发insert, 用户表要防止并发update， 资产表要防止并发insert与update。
现在的问题是如何防止高并发时（包括恶意攻击）出现重复操作？
用队列处理只适合被抽奖的奖品有限的情况，但坑爹的产品还提出一种奖品数量没有限制的抽奖（抽奖发虚拟币）-_-#
回复内容：
产品给的需求是: 做一个抽奖活动，用户每天的抽奖次数有限(根据其当天的消费行为获得)，用户如果中奖，那么就要修改用户今天抽了几次，修改用户资产(发放奖励)，增加一条log。
这里就涉及多个表需要防止并发，log表要防止并发insert, 用户表要防止并发update， 资产表要防止并发insert与update。
现在的问题是如何防止高并发时（包括恶意攻击）出现重复操作？
用队列处理只适合被抽奖的奖品有限的情况，但坑爹的产品还提出一种奖品数量没有限制的抽奖（抽奖发虚拟币）-_-#
保证一致性和原子性就需要使用事务，我之前碰到这类问题的解决方案是写入队列，后台进程异步处理并使用事务来保证
redis inc数量，判断数量然后再插log
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How do you parse and process HTML/XML in PHP?
Feb 07, 2025 am 11:57 AM
This tutorial demonstrates how to efficiently process XML documents using PHP. XML (eXtensible Markup Language) is a versatile text-based markup language designed for both human readability and machine parsing. It's commonly used for data storage an
PHP Program to Count Vowels in a String
Feb 07, 2025 pm 12:12 PM
A string is a sequence of characters, including letters, numbers, and symbols. This tutorial will learn how to calculate the number of vowels in a given string in PHP using different methods. The vowels in English are a, e, i, o, u, and they can be uppercase or lowercase. What is a vowel? Vowels are alphabetic characters that represent a specific pronunciation. There are five vowels in English, including uppercase and lowercase: a, e, i, o, u Example 1 Input: String = "Tutorialspoint" Output: 6 explain The vowels in the string "Tutorialspoint" are u, o, i, a, o, i. There are 6 yuan in total
Break or return from Java 8 stream forEach?
Feb 07, 2025 pm 12:09 PM
Java 8 introduces the Stream API, providing a powerful and expressive way to process data collections. However, a common question when using Stream is: How to break or return from a forEach operation? Traditional loops allow for early interruption or return, but Stream's forEach method does not directly support this method. This article will explain the reasons and explore alternative methods for implementing premature termination in Stream processing systems. Further reading: Java Stream API improvements Understand Stream forEach The forEach method is a terminal operation that performs one operation on each element in the Stream. Its design intention is
Java Program to Find the Volume of Capsule
Feb 07, 2025 am 11:37 AM
Capsules are three-dimensional geometric figures, composed of a cylinder and a hemisphere at both ends. The volume of the capsule can be calculated by adding the volume of the cylinder and the volume of the hemisphere at both ends. This tutorial will discuss how to calculate the volume of a given capsule in Java using different methods. Capsule volume formula The formula for capsule volume is as follows: Capsule volume = Cylindrical volume Volume Two hemisphere volume in, r: The radius of the hemisphere. h: The height of the cylinder (excluding the hemisphere). Example 1 enter Radius = 5 units Height = 10 units Output Volume = 1570.8 cubic units explain Calculate volume using formula: Volume = π × r2 × h (4
How to Run Your First Spring Boot Application in Spring Tool Suite?
Feb 07, 2025 pm 12:11 PM
Spring Boot simplifies the creation of robust, scalable, and production-ready Java applications, revolutionizing Java development. Its "convention over configuration" approach, inherent to the Spring ecosystem, minimizes manual setup, allo
Java Program to insert an element at the Bottom of a Stack
Feb 07, 2025 am 11:59 AM
A stack is a data structure that follows the LIFO (Last In, First Out) principle. In other words, The last element we add to a stack is the first one to be removed. When we add (or push) elements to a stack, they are placed on top; i.e. above all the
PHP Program to Check if a Number is an Armstrong Number
Feb 07, 2025 am 11:27 AM
Armstrong Number The Armstrong number refers to the sum of n powers of each digit of a number equal to the number itself, where n is the number of digits of the number. This article will discuss how to check if a given number is an Armstrong number. Example Let's learn about the Armstrong number with some input and output examples. enter 9474 Output yes explain This is a four-digit number. The numbers for this number are 9, 4, 7 and 4. 9474 = 94 44 74 44= 6561 256 2401 256= 9474 So, this is an Armstrong number. enter 153 Output yes explain This is a triple digit number. The numbers for this number are 1, 5 and 3
How to Run Your First Spring Boot Application in IntelliJ?
Feb 07, 2025 am 11:40 AM
IntelliJ IDEA simplifies Spring Boot development, making it a favorite among Java developers. Its convention-over-configuration approach minimizes boilerplate code, allowing developers to focus on business logic. This tutorial demonstrates two metho
