This topic describes compatibility information for PolarDB MySQL Edition Orca.
Redis protocol compatibility
Orca supports a subset of commands from Redis 7.0 and earlier versions and supports both the RESP2 and RESP3 protocols. The following table shows the current level of command support:
Orca does not support any Redis commands that are not listed in the following table. Additionally, Orca supports operations on a single database only and does not support cross-database commands such as MOVE.
Classification | Command | Supported |
Bitmap | BITCOUNT | Support |
BITOP | Support | |
BITPOS | Support | |
SETBIT | Support | |
GETBIT | Support | |
Other commands | Not supported. | |
Connection management | PING | Support |
ECHO | Support | |
HELLO | Support Note
| |
AUTH | Support Note
| |
CLIENT | Partially supported Note Only the following subcommands are supported: | |
Other commands | Not supported | |
Generic | DEL | Support |
UNLINK | Supported | |
EXISTS | Support | |
KEYS | Support | |
RENAME | Support | |
RENAMENX | Supported | |
TYPE | Supported | |
EXPIRE | Support | |
EXPIREAT | Support | |
EXPIRETIME | Supported | |
PERSIST | Support | |
PEXPIRE | Support | |
PEXPIREAT | Support | |
PEXPIRETIME | Support | |
TTL | Support | |
PTTL | Supported | |
RANDOMKEY | Support | |
DUMP | Support | |
RESTORE | Support | |
INFO | Support | |
SCAN | Support | |
Other commands | Not supported | |
Hash | HDEL | Support |
HEXISTS | Support | |
HGET | Support | |
HGETALL | Supported | |
HINCRBY | Support | |
HINCRBYFLOAT | Support | |
HKEYS | Support | |
HLEN | Support | |
HMGET | Support | |
HMSET | Supported | |
HSET | Support | |
HSETNX | Support | |
HRANDFIELD | Support | |
HVALS | Support | |
HSTRLEN | Supported | |
HSCAN | Support | |
HEXPIRE | Support | |
HEXPIREAT | Support | |
HEXPIRETIME | Support | |
HPERSIST | Support | |
HPEXPIRE | Support | |
HPEXPIREAT | Support | |
HPEXPIRETIME | Support | |
HTTL | Supported | |
HPTTL | Support | |
Other commands | Not supported | |
List | LINDEX | Support |
LINSERT | Support | |
LLEN | Support | |
LMOVE | Support | |
LMPOP | Supported | |
LPOP | Support | |
LPOS | Supported | |
LPUSH | Support | |
LPUSHX | Support | |
LRANGE | Support | |
LREM | Support | |
LSET | Support | |
LTRIM | Support | |
RPOP | Support | |
RPOPLPUSH | Support | |
RPUSH | Support | |
RPUSHX | Support | |
BLPOP | Support | |
BRPOP | Support | |
Other commands | Unsupported | |
Pub/Sub Note Clients in the | PSUBSCRIBE | Support |
PUBLISH | Supported | |
PUBSUB CHANNELS | Support | |
PUBSUB NUMPAT | Support | |
PUBSUB NUMSUB | Supported | |
PUNSUBSCRIBE | Support | |
SUBSCRIBE | Support | |
UNSUBSCRIBE | Support | |
Other commands | Not supported. | |
Server management | DBSIZE | Support |
FLUSHALL | Support Note
| |
FLUSHDB | Support Note
| |
Other commands | Not supported | |
Set | SADD | Support |
SCARD | Support | |
SDIFF | Support | |
SDIFFSTORE | Support | |
SINTER | Support | |
SINTERCARD | Support | |
SINTERSTORE | Support | |
SISMEMBER | Support | |
SMEMBERS | Support | |
SMISMEMBER | Support | |
SMOVE | Help and support | |
SREM | Supported | |
SUNION | Support | |
SUNIONSTORE | Support | |
SPOP | Support | |
SRANDMEMBER | Support | |
SSCAN | Support | |
Other commands | Not supported | |
Sorted set | ZADD | Support |
ZCARD | Support | |
ZCOUNT | Support | |
ZDIFF | Support | |
ZDIFFSTORE | Support | |
ZINCRBY | Support | |
ZINTERCARD | Supported | |
ZINTERSTORE | Support | |
ZLEXCOUNT | Supported Note In Redis, LEX operations are meaningful only when all elements in a sorted set have the same score. In this case, Redis enforces lexicographical ordering. However, when elements have different scores, the order of returned elements is undefined. Therefore, Orca and Redis may behave differently in such cases. | |
ZMPOP | Support | |
ZMSCORE | Supported | |
ZPOPMAX | Support | |
ZPOPMIN | Support | |
ZRANGE | Support Note Usage: When sorting with the optional | |
ZRANGEBYLEX | Support Note In Redis, LEX operations are meaningful only when all elements in a sorted set have the same score. In this case, Redis enforces lexicographical ordering. However, when elements have different scores, the order of returned elements is undefined. Therefore, Orca and Redis may behave differently in such cases. | |
ZRANGEBYSCORE | Support | |
ZRANGESTORE | Support | |
ZRANK | Supported | |
ZREM | Support | |
ZREMRANGEBYLEX | Support Note In Redis, LEX operations are meaningful only when all elements in a sorted set have the same score. In this case, Redis enforces lexicographical ordering. However, when elements have different scores, the order of returned elements is undefined. Therefore, Orca and Redis may behave differently in such cases. | |
ZREMRANGEBYRANK | Support | |
ZREMRANGEBYSCORE | Support | |
ZREVRANGE | Support | |
ZREVRANGEBYLEX | Support Note In Redis, LEX operations are meaningful only when all elements in a sorted set have the same score. In this case, Redis enforces lexicographical ordering. However, when elements have different scores, the order of returned elements is undefined. Therefore, Orca and Redis may behave differently in such cases. | |
ZREVRANGEBYSCORE | Support | |
ZREVRANK | Support | |
ZSCORE | Support | |
ZUNION | Support | |
ZUNIONSTORE | Support | |
ZRANDMEMBER | Support | |
ZSCAN | Support | |
Other commands | Not supported. | |
String | APPEND | Support |
DECR | Support | |
DECRBY | Support | |
GET | Support | |
GETDEL | Support | |
GETEX | Support | |
GETRANGE | Support | |
GETSET | Support | |
LCS | Support | |
INCR | Support | |
INCRBY | Support | |
INCRBYFLOAT | Support | |
MGET | Support | |
MSET | Support | |
MSETNX | Support | |
PSETEX | Support | |
SET | Support | |
SETEX | Support | |
SETNX | Support | |
SETRANGE | Support | |
STRLEN | Support | |
SUBSTR | Support |
Key length limits
Redis limits the length of a single key to 512 MB. Orca limits the length of a single key to 4 GB.
For best performance, use keys no longer than 2560 bytes.