{"id":478,"title":"\u5206\u5e03\u5f0f\u9501\u5bf9\u6bd4","good":0,"bad":0,"hit":1973,"created_at":"2020-05-29 23:46:32","content":"<p><br\/><\/p><p><img src=\"https:\/\/api.hu-rong.com\/uploads\/image\/20200529\/1590766609431257.png\" title=\"1590766609431257.png\" alt=\"image.png\"\/><\/p><p>\u5206\u5e03\u5f0f\u9501\u5bf9\u6bd4<\/p><p>\uff08\u4ee5\u4e0b\u8ba2\u5355\u66f4\u65b0\u5e93\u5b58\u4e3a\u4f8b\uff09<\/p><p>\u5bf9\u4e8e\u6570\u636e\u5e93\u6765\u8bf4\u67e5\u8be2\u7684\u65f6\u5019\u4e00\u822c\u662f\u7528select for update\u52a0\u9501\uff0c\u66f4\u65b0\u5e93\u5b58\u7684\u65f6\u5019\u6267\u884csql\u8bed\u53e5\u8981\u5224\u65ad\u5269\u4f59\u5e93\u5b58\u5927\u4e8e\u7b49\u4e8e\u8d2d\u4e70\u6570\u636e\uff0c\u5982\uff1awhere amout&gt;=buyNum<\/p><p>redis\u4e2d\u662f\u7528setnx\uff08value\u5b58\u4e00\u4e2a\u968f\u673a\u6570)\u53cadelete\u6765\u5b9e\u73b0\u9501\u53ca\u91ca\u653e\u9501\uff0c\u6ce8\u610f\u91ca\u653e\u6240\u65f6\u8981\u5224\u65ad\u751f\u6210\u9501\u7684\u968f\u673a\u6570\u548c\u8fdb\u548c\u83b7\u5f97\u9501\u65f6\u662f\u5426\u4e00\u6837\uff0c\u4ee5\u514d\u5220\u9664\u5176\u5b83\u8fdb\u7a0b\u4ea7\u751f\u7684\u9501\uff1b<\/p><p>\u5176\u5b83\u51e0\u79cd\u662f\u7b2c\u4e09\u65b9\u7684\u5305\uff0czookeeper\u7684\u539f\u7406\u662f\u9ad8\u5e76\u53d1\u65f6\uff0c\u751f\u6210\u6709\u5e8f\u6811\u8282\u70b9\uff0c\u6700\u5148\u751f\u6210\u7684\u5360\u7528\u9501\uff0c\u5176\u5b83\u7684\u8fdb\u7a0b\u5904\u4e8e\u7b49\u5f85\u4e2d\uff0c\u524d\u9762\u7684\u6267\u884c\u5b8c\u6210\u540e\u5220\u9664\u8282\u70b9\uff0c\u540e\u9762\u7684\u8282\u70b9\u5224\u65ad\u81ea\u5df1\u6392\u5728\u7b2c\u4e00\u4f4d\u65f6\u5219\u83b7\u5f97\u6240\uff1b<\/p><p>redisson\u662f\u5bf9redis\u7684\u5c01\u88c5\uff0c\u5176\u539f\u7406\u548csetnx\u57fa\u672c\u4e00\u81f4\uff0c\u6bd4\u8f83\u597d\u7528\uff08\u4e3a\u4ec0\u4e48\u4f1a\u51fa\u73b0redission\u5462\uff0c\u4e3b\u8981\u662f\u81ea\u5df1\u7528setnx\u65f6\u5199\u903b\u8f91\u53ef\u80fd\u6709\u7eb0\u6f0f\uff09\uff1b<\/p>"}