Topik ini menjelaskan kompatibilitas Orca dengan PolarDB for MySQL.
Kompatibilitas protokol Redis
Orca mendukung perintah Redis 7.0 dan versi sebelumnya serta protokol RESP2/RESP3. Perintah yang didukung tercantum dalam tabel berikut:
Orca tidak mendukung perintah Redis yang tidak tercantum dalam tabel berikut. Saat ini, Orca hanya mendukung operasi single DB dan tidak mendukung perintah cross-DB, seperti MOVE.
|
Category |
Command |
Supported |
|
Bitmap |
BITCOUNT |
Supported |
|
BITOP |
Supported |
|
|
BITPOS |
Supported |
|
|
SETBIT |
Supported |
|
|
GETBIT |
Supported |
|
|
Other commands |
Not supported |
|
|
Connection management |
PING |
Supported |
|
ECHO |
Supported |
|
|
HELLO |
Supported Catatan
|
|
|
AUTH |
Supported Catatan
|
|
|
CLIENT |
Partially supported Catatan
Hanya subperintah |
|
|
Other commands |
Not supported |
|
|
Generic |
DEL |
Supported |
|
UNLINK |
Supported |
|
|
EXISTS |
Supported |
|
|
KEYS |
Supported |
|
|
RENAME |
Supported |
|
|
RENAMENX |
Supported |
|
|
TYPE |
Supported |
|
|
EXPIRE |
Supported |
|
|
EXPIREAT |
Supported |
|
|
EXPIRETIME |
Supported |
|
|
PERSIST |
Supported |
|
|
PEXPIRE |
Supported |
|
|
PEXPIREAT |
Supported |
|
|
PEXPIRETIME |
Supported |
|
|
TTL |
Supported |
|
|
PTTL |
Supported |
|
|
RANDOMKEY |
Supported |
|
|
DUMP |
Supported |
|
|
RESTORE |
Supported |
|
|
INFO |
Supported |
|
|
SCAN |
Supported |
|
|
Other commands |
Not supported |
|
|
Hash |
HDEL |
Supported |
|
HEXISTS |
Supported |
|
|
HGET |
Supported |
|
|
HGETALL |
Supported |
|
|
HINCRBY |
Supported |
|
|
HINCRBYFLOAT |
Supported |
|
|
HKEYS |
Supported |
|
|
HLEN |
Supported |
|
|
HMGET |
Supported |
|
|
HMSET |
Supported |
|
|
HSET |
Supported |
|
|
HSETNX |
Supported |
|
|
HRANDFIELD |
Supported |
|
|
HVALS |
Supported |
|
|
HSTRLEN |
Supported |
|
|
HSCAN |
Supported |
|
|
HEXPIRE |
Supported |
|
|
HEXPIREAT |
Supported |
|
|
HEXPIRETIME |
Supported |
|
|
HPERSIST |
Supported |
|
|
HPEXPIRE |
Supported |
|
|
HPEXPIREAT |
Supported |
|
|
HPEXPIRETIME |
Supported |
|
|
HTTL |
Supported |
|
|
HPTTL |
Supported |
|
|
Other commands |
Not supported |
|
|
List |
LINDEX |
Supported |
|
LINSERT |
Supported |
|
|
LLEN |
Supported |
|
|
LMOVE |
Supported |
|
|
LMPOP |
Supported |
|
|
LPOP |
Supported |
|
|
LPOS |
Supported |
|
|
LPUSH |
Supported |
|
|
LPUSHX |
Supported |
|
|
LRANGE |
Supported |
|
|
LREM |
Supported |
|
|
LSET |
Supported |
|
|
LTRIM |
Supported |
|
|
RPOP |
Supported |
|
|
RPOPLPUSH |
Supported |
|
|
RPUSH |
Supported |
|
|
RPUSHX |
Supported |
|
|
BLPOP |
Supported |
|
|
BRPOP |
Supported |
|
|
Other commands |
Not supported |
|
|
Pub/Sub Catatan
Klien dalam status |
PSUBSCRIBE |
Supported |
|
PUBLISH |
Supported |
|
|
PUBSUB CHANNELS |
Supported |
|
|
PUBSUB NUMPAT |
Supported |
|
|
PUBSUB NUMSUB |
Supported |
|
|
PUNSUBSCRIBE |
Supported |
|
|
SUBSCRIBE |
Supported |
|
|
UNSUBSCRIBE |
Supported |
|
|
Other commands |
Not supported |
|
|
Server management |
DBSIZE |
Supported |
|
FLUSHALL |
Supported Catatan
|
|
|
FLUSHDB |
Supported Catatan
|
|
|
Other commands |
Not supported |
|
|
Set |
SADD |
Supported |
|
SCARD |
Supported |
|
|
SDIFF |
Supported |
|
|
SDIFFSTORE |
Supported |
|
|
SINTER |
Supported |
|
|
SINTERCARD |
Supported |
|
|
SINTERSTORE |
Supported |
|
|
SISMEMBER |
Supported |
|
|
SMEMBERS |
Supported |
|
|
SMISMEMBER |
Supported |
|
|
SMOVE |
Supported |
|
|
SREM |
Supported |
|
|
SUNION |
Supported |
|
|
SUNIONSTORE |
Supported |
|
|
SPOP |
Supported |
|
|
SRANDMEMBER |
Supported |
|
|
SSCAN |
Supported |
|
|
Other commands |
Not supported |
|
|
Sorted set |
ZADD |
Supported |
|
ZCARD |
Supported |
|
|
ZCOUNT |
Supported |
|
|
ZDIFF |
Supported |
|
|
ZDIFFSTORE |
Supported |
|
|
ZINCRBY |
Supported |
|
|
ZINTERCARD |
Supported |
|
|
ZINTERSTORE |
Supported |
|
|
ZLEXCOUNT |
Supported Catatan
Di Redis, operasi LEX bermakna ketika semua elemen dalam Sorted Set memiliki skor yang sama, karena menerapkan pengurutan leksikografis. Namun, ketika skor elemen berbeda, urutan elemen yang dikembalikan tidak terdefinisi. Oleh karena itu, perilaku Orca dan Redis mungkin tidak konsisten dalam kasus tersebut. |
|
|
ZMPOP |
Supported |
|
|
ZMSCORE |
Supported |
|
|
ZPOPMAX |
Supported |
|
|
ZPOPMIN |
Supported |
|
|
ZRANGE |
Supported Catatan
Usage: Saat melakukan pengurutan, jika Anda menentukan parameter opsional |
|
|
ZRANGEBYLEX |
Supported Catatan
Di Redis, operasi LEX bermakna ketika semua elemen dalam Sorted Set memiliki skor yang sama, karena menerapkan pengurutan leksikografis. Namun, ketika skor elemen berbeda, urutan elemen yang dikembalikan tidak terdefinisi. Oleh karena itu, perilaku Orca dan Redis mungkin tidak konsisten dalam kasus tersebut. |
|
|
ZRANGEBYSCORE |
Supported |
|
|
ZRANGESTORE |
Supported |
|
|
ZRANK |
Supported |
|
|
ZREM |
Supported |
|
|
ZREMRANGEBYLEX |
Supported Catatan
Di Redis, operasi LEX bermakna ketika semua elemen dalam Sorted Set memiliki skor yang sama, karena menerapkan pengurutan leksikografis. Namun, ketika skor elemen berbeda, urutan elemen yang dikembalikan tidak terdefinisi. Oleh karena itu, perilaku Orca dan Redis mungkin tidak konsisten dalam kasus tersebut. |
|
|
ZREMRANGEBYRANK |
Supported |
|
|
ZREMRANGEBYSCORE |
Supported |
|
|
ZREVRANGE |
Supported |
|
|
ZREVRANGEBYLEX |
Supported Catatan
Di Redis, operasi LEX bermakna ketika semua elemen dalam Sorted Set memiliki skor yang sama, karena menerapkan pengurutan leksikografis. Namun, ketika skor elemen berbeda, urutan elemen yang dikembalikan tidak terdefinisi. Oleh karena itu, perilaku Orca dan Redis mungkin tidak konsisten dalam kasus tersebut. |
|
|
ZREVRANGEBYSCORE |
Supported |
|
|
ZREVRANK |
Supported |
|
|
ZSCORE |
Supported |
|
|
ZUNION |
Supported |
|
|
ZUNIONSTORE |
Supported |
|
|
ZRANDMEMBER |
Supported |
|
|
ZSCAN |
Supported |
|
|
Other commands |
Not supported |
|
|
String |
APPEND |
Supported |
|
DECR |
Supported |
|
|
DECRBY |
Supported |
|
|
GET |
Supported |
|
|
GETDEL |
Supported |
|
|
GETEX |
Supported |
|
|
GETRANGE |
Supported |
|
|
GETSET |
Supported |
|
|
LCS |
Supported |
|
|
INCR |
Supported |
|
|
INCRBY |
Supported |
|
|
INCRBYFLOAT |
Supported |
|
|
MGET |
Supported |
|
|
MSET |
Supported |
|
|
MSETNX |
Supported |
|
|
PSETEX |
Supported |
|
|
SET |
Supported |
|
|
SETEX |
Supported |
|
|
SETNX |
Supported |
|
|
SETRANGE |
Supported |
|
|
STRLEN |
Supported |
|
|
SUBSTR |
Supported |
|
|
Scripting Catatan
Untuk informasi lebih lanjut, lihat petunjuk penggunaan skrip Lua. |
EVAL |
Supported |
|
EVAL_RO |
Supported |
|
|
EVALSHA |
Supported |
|
|
EVALSHA_RO |
Supported |
|
|
SCRIPT LOAD |
Supported |
|
|
SCRIPT EXISTS |
Supported |
|
|
SCRIPT KILL |
Supported |
|
|
SCRIPT FLUSH |
Supported |
Batasan panjang kunci
Redis membatasi panjang satu kunci hingga 512 MB, sedangkan Orca membatasinya hingga 4 GB.
Untuk performa optimal, gunakan string dengan panjang tidak lebih dari 2560 Bytes sebagai kunci.