ZEESQL.EXECis for updating the status of the database using
SELECT, mostly for keeping things simple for everybody.
ZEESQL.QUERYshould be preferred whenever you are executing a read-only operation.
ZEESQL.QUERYwill never modify the status of the database, hence all the operations executed with it, are not replicated, nor to the AOF file, nor to the replicas.
ZEESQL.EXEC. Since we don't know if the operation in
ZEESQL.EXECwill modify or not the database, the command needs to be replicated. This implies that the replicas will repeat the command against their own internal status.
ZEESQL.EXECcommand because it will be replicated by your replicas and by the AOF file, while not changing the structure of the database.
ZEESQL.QUERY, being a read-only Redis command, can be executed also by the replicas.
ZEESQL.QUERYwhen possible instead of blindly using
ZEESQL.QUERYwill raise an error when you try to use it with something that is not a read-only query, so you will catch possible misuses of