戴着假发的程序员-分布式锁

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for lock_test
-- ----------------------------
DROP TABLE IF EXISTS `lock_test`;
CREATE TABLE `lock_test` (
  `num` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lock_test
-- ----------------------------
INSERT INTO `lock_test` VALUES ('0');

   	upstream locktest{
   		server 127.0.0.1:9090;
   		server 127.0.0.1:9091;
   		server 127.0.0.1:9092;
   	}

   	server{
   		listen 888;
   		server_name localhost;
   		location / {
   		 proxy_pass http://locktest;
   		 index index.html index.htm;
   		}
   	}