分布式锁之mysql实现

小趴菜不能喝

已于 2023-08-29 10:34:17 修改

阅读量433

点赞数

CC 4.0 BY-SA版权

分类专栏： springCloud 文章标签：分布式

于 2023-08-28 20:01:13 首次发布

本文链接：https://blog.csdn.net/m0_65775063/article/details/132536692

文章讨论了在本地应用中使用JVM锁（synchronized和ReentrantLock）以及MySQL锁（悲观锁和乐观锁）解决票务系统中的超卖问题。对比了不同锁定策略在性能上的优劣，并强调在分布式环境中避免使用JVM锁以防止失效情况。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

本地jvm锁

搭建本地卖票案例

package com.test.lockservice.service.impl;

import com.test.lockservice.mapper.TicketMapper;
import com.test.lockservice.service.TicketService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * @Author sl
 */
@Service
public class TicketServiceImpl implements TicketService {

    @Autowired
    private TicketMapper ticketMapper;

    private  int count = 5000;

    @Override
    public void sellTicket() {
        count = count -1;
        System.out.println("count:"+ count);
    }
}

使用jmeter压测

5000个请求测试买票，查看是否出现超卖问题

出现了超卖问题

本地synchronized和ReentrantLock解决本地超卖问题

package com.test.lockservice.service.impl;

import com.test.lockservice.mapper.TicketMapper;
import com.test.lockservice.service.TicketService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * @Author sl
 */
@Service
public class TicketServiceImpl implements TicketService {

    @Autowired
    private TicketMapper ticketMapper;

    private  int count = 5000;
    
    @Override
    public synchronized void sellTicket() {
        count = count -1;
        System.out.println("count:"+ count);
    }
}

或者使用ReentrantLock

package com.test.lockservice.service.impl;

import com.test.lockservice.mapper.TicketMapper;
import com.test.lockservice.service.TicketService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.concurrent.locks.ReentrantLock;

/**
 * @Author sl
 */
@Service
public class TicketServiceImpl implements TicketService {

    @Autowired
    private TicketMapper ticketMapper;

    private  int count = 5000;

    private ReentrantLock lock = new ReentrantLock();
    @Override
    public  void sellTicket() {
        lock.lock();
        try {
            count = count -1;
            System.out.println("count:"+ count);
        }finally {
            lock.unlock();
        }
    }
}

jmeter压测结果显示，5000总票数，压测5000，都能够解决超卖的现象

将共享资源放入mysql

查库操作，演示超卖现象

package com.test.lockservice.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.test.lockservice.mapper.TicketMapper;
import com.test.lockservice.model.Ticket;
import com.test.lockservice.service.TicketService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.concurrent.locks.ReentrantLock;

/**
 * @Author sl
 */
@Service
public class TicketServiceImpl implements TicketService {

    @Autowired
    private TicketMapper ticketMapper;

//    private ReentrantLock lock = new ReentrantLock();
    @Override
    public  void sellTicket() {
//        lock.lock();
        try {
            // 查询票数
            Ticket ticket = ticketMapper.selectOne(new Query