馃毃 Cassandra鐨勪富閿珶鐒朵笉鑳借嚜澧烇紵閭ｆ€庝箞鐜╋紵

鍒氭帴瑙assandra鐨勬柊鎵嬭偗瀹氶兘鎳佃繃鈥斺€旇繖鏁版嵁搴撴€庝箞杩炰釜鑷涓婚敭閮戒笉缁欙紵鍒厡锛岃繖浜嬪効寰椾粠瀹冪殑鑰佹湰琛岃璧枫€侰assandra澶╃敓灏辨槸涓烘捣閲忔暟鎹璁＄殑锛屸€?strong>鈥嬭嚜澧濱D鍦ㄥ垎甯冨紡绯荤粺閲屽氨鍍忔槬杩愮伀杞︾エ锛屾墍鏈変汉鎶㈠悓涓€涓敭绁ㄧ獥鍙ｇ粷瀵硅宕┾€?/strong>鈥嬶紒涓嶈繃鍒媴蹇冿紝鍜辨湁鏇磋仾鏄庣殑瑙ｅ喅鍔炴硶銆?/p>

锛堝仠椤匡級浣犲彲鑳借闂細閭ｆ窐瀹濅含涓滆繖浜涚綉绔欐€庝箞澶勭悊璁㈠崟鍙风殑锛熷樋锛岃繖灏卞甫浣犵湅涓夌缁濇椿...

馃攽 鏂规涓€锛歎UID澶ф硶濂斤紒闆堕厤缃紑绠卞嵆鐢?/h3>

cql澶嶅埗
CREATE TABLE user_order (
   order_id UUID PRIMARY KEY,
   product_name text
);
-- 鎻掑叆鏁版嵁鏃惰嚜鍔ㄧ敓鎴?/span>
INSERT INTO user_order (order_id, product_name) 
VALUES (uuid(), '鏈€鏂版鎵嬫満');

鈥?strong>鈥嬭繖鎷涙湁澶氶鈥?/strong>鈥嬶細

• 馃幆 涓嶇敤鍔ㄨ剳瀛愰厤缃紝鐩存帴鎶勪唬鐮佸氨鑳界敤
• 馃挜 澶╃劧闃叉挒杞︼紝鐞嗚閲嶅姒傜巼姣斾腑褰╃エ杩樹綆
• 馃寪 鍒嗗竷寮忕郴缁熼殢渚挎墿瀹癸紝瀹屽叏鏃犲帇鍔?/li>

鈥?strong>鈥嬩絾鏄娉ㄦ剰鈥?/strong>鈥嬶細

• 璁㈠崟鍙烽暱寰楀儚"a1b2c3d4-..."锛屼汉绫绘牴鏈涓嶄綇
• 鎸夋椂闂存煡璁㈠崟锛熸兂閮藉埆鎯筹紒UUID閮芥槸涔卞簭鐨?/li>

涓句釜鐪熷疄妗堜緥锛氭煇娓告垙鍏徃鐢ㄨ繖鏂规瀛樼帺瀹剁櫥褰曡褰曪紝3涓湀瀛樹簡20浜挎潯鏁版嵁锛屼粠娌″嚭鐜拌繃ID閲嶅锛?/p>

---

鈴?鏂规浜岋細鏃堕棿鎴?鏈哄櫒鐮佹嫾绉湪

閫傚悎闇€瑕佹寜鏃堕棿鏌ユ暟鎹殑鍦烘櫙锛屾瘮濡傛櫤鑳芥墜鐜殑姝ユ暟璁板綍锛?/p>

cql澶嶅埗
CREATE TABLE fitness_data (
   device_id int,
   date_hour timestamp,
   record_id timeuuid,
   steps int,
   PRIMARY KEY ((device_id, date_hour), record_id)
);

鈥?strong>鈥嬫嫾瑁呯绫嶁€?/strong>鈥嬶細

1. 鍓?浣嶏細璁惧缂栧彿锛?001-9999锛?/li>
2. 涓棿13浣嶏細绮剧‘鍒版绉掔殑鏃堕棿鎴?/li>
3. 鍚?浣嶏細鍚屼竴姣鍐呯殑娴佹按鍙?/li>

鈥?strong>鈥嬪疄娴嬫暟鎹€?/strong>鈥嬶細
鏌愭櫤鑳藉灞呭叕鍙哥敤杩欏鏂规锛?000鍙拌澶囨瘡绉掑苟鍙戝啓鍏ワ紝3骞存病鍑虹幇杩嘔D閲嶅銆備笉杩囦粬浠繍缁村皬鍝ュ伔鍋峰憡璇夋垜锛屾湁娆℃湇鍔″櫒鏃堕挓婕傜Щ宸偣缈昏溅...

鉂勶笍 鏂规涓夛細闆姳绠楁硶鎵嶆槸鐪熷ぇ浣紒

杩欏氨鏄帹鐗瑰唴閮ㄧ敤鐨勭粷鎷涳紝鍜变滑鑷繁鍔ㄦ墜瀹炵幇涔熶笉闅撅細

python澶嶅埗
# 涓句釜绠€鍖栫増渚嬪瓙
def snowflake():
    machine_id = 5    # 姣忓彴鏈嶅姟鍣ㄤ笉鍚?/span>
    sequence = 0
    
    now = int(time.time()*1000)
    return (now << 20) | (machine_id << 12) | sequence

鈥?strong>鈥嬩笁澶х粷鏉€鎶€鈥?/strong>鈥嬶細

1. 馃搱 瀹屽叏鏃堕棿鏈夊簭锛屾煡鏁版嵁蹇闂數
2. 馃敘 鏁板瓧鐭皬绮炬倣锛屾瘮UUID鐪佷竴鍗婄┖闂?/li>
3. 馃洝锔?鑷甫闃叉挒鏈哄埗锛屾満鍣ㄦ椂閽熸甯稿氨涓嶄細閲嶅

涓嶈繃瑕佸綋蹇冿紒鍘诲勾鍙屽崄涓€鏌愮數鍟嗗氨鏍借繃璺熷ご鈥斺€旀湇鍔″櫒鏃堕棿鍥炴嫧瀵艰嚧鐢熸垚閲嶅ID锛屽悗鏉ヤ粬浠姞浜嗐€屾椂閽熺洃鎺ф姤璀︺€嶆墠瑙ｅ喅銆?/p>

馃弳 涓夊ぇ鏂规PK鎿傚彴璧?/h3>

鎷跨湡瀹炴祴璇曟暟鎹璇濓紙娴嬭瘯鐜锛?鑺傜偣闆嗙兢锛屾瘡绉?涓囨鍐欏叆锛夛細

	UUID鏂规	鏃堕棿鎷兼帴鏂规	闆姳绠楁硶
璁㈠崟鍙烽暱搴?/td>	36瀛楃	20瀛楃	18瀛楃
鏄惁鏀寔鏃堕棿鑼冨洿鏌?/td>	鉂?/td>	鉁?/td>	鉁?/td>
鏈嶅姟鍣ㄦ垚鏈?/td>	0鍏?/td>	闇€瑕丯TP鍚屾	闇€瑕佺紪鐮?/td>
鏂版墜鍙嬪ソ搴?/td>	猸愨瓙猸愨瓙猸?/td>	猸愨瓙猸愨瓙	猸愨瓙猸?/td>

---

馃 鐏甸瓊鎷烽棶鐜妭

鈥?strong>鈥婹锛氭垜璇ラ€夊摢涓柟妗堬紵鈥?/strong>鈥?br/> A锛氳鐗㈣繖涓彛璇€锛?/p>

• 瑕佺畝鍗曠渷浜?鈫?闂溂閫塙UID
• 缁忓父鎸夋椂闂存煡鏁版嵁 鈫?鏃堕棿鎷兼帴鏂规
• 閲戣瀺/璁㈠崟绯荤粺 鈫?姝荤闆姳绠楁硶

鈥?strong>鈥婹锛氫竾涓€ID鐢ㄥ畬浜嗘€庝箞鍔烇紵鈥?/strong>鈥?br/> 杩欓棶棰橀棶寰楀ソ锛佸叾瀹為洩鑺辩畻娉曠殑鏃堕棿鎴抽儴鍒嗚兘鐢?9骞达紝绛夊挶浠€€浼戜簡閮借繕娌＄敤瀹屻€傜湡瑕佹媴蹇冪殑璇濓紝鍙互瀛﹂摱琛岀殑鍋氭硶鈥斺€旀瘡骞撮噸缃捣濮嬫椂闂存埑銆?/p>

鐙鐖嗘枡锛氬幓骞村府鏌愮洿鎾钩鍙板仛鏋舵瀯锛屽彂鐜颁釜楠氭搷浣溾€斺€斾粬浠妸鐢ㄦ埛ID鍜岀ぜ鐗㊣D鎷煎湪涓€璧峰綋涓婚敭锛屾棦閬垮厤閲嶅鍙堣兘鐩存帴鍏宠仈鏁版嵁銆備笉杩囪繖绉嶇帺娉曢渶瑕佺簿鍑嗚绠楀瓧娈甸暱搴︼紝鏂版墜寤鸿鍏堝埆灏濊瘯銆?/p>

鏈€鍚庤鍙ュぇ瀹炶瘽锛氭病鏈夊畬缇庣殑鏂规锛屽彧鏈夊悎閫傜殑鍦烘櫙銆傚氨鍍忕┛闉嬶紝鍚堜笉鍚堣剼鑷繁鏈€娓呮锛屽崈涓囧埆鍚闆姳绠楁硶鐗涘氨鏃犺剳涓婏紝鏈夋椂鍊欑畝鍗曠殑UUID鍙嶈€屾洿鐪佸績涓嶆槸锛?/p>