# redis-rdb-cli **Repository Path**: szkr/redis-cli-tool ## Basic Information - **Project Name**: redis-rdb-cli - **Description**: Redis rdb CLI : A CLI tool that can parse, filter, split, merge rdb and analyze memory usage offline. It can also sync 2 redis data and allow user define there own sink service to migrate redis data to somewhere. - **Primary Language**: Java - **License**: Apache-2.0 - **Default Branch**: master - **Homepage**: https://github.com/leonchen83/redis-rdb-cli - **GVP Project**: No ## Statistics - **Stars**: 0 - **Forks**: 12 - **Created**: 2021-09-17 - **Last Updated**: 2021-09-17 ## Categories & Tags **Categories**: Uncategorized **Tags**: None ## README # redis-rdb-cli Buy Me A Coffee A tool that can parse, filter, split, merge rdb and analyze memory usage offline. It can also sync 2 redis data and allow user define there own sink service to migrate redis data to somewhere. [![Java CI](https://github.com/leonchen83/redis-rdb-cli/actions/workflows/maven.yml/badge.svg)](https://github.com/leonchen83/redis-rdb-cli/actions/workflows/maven.yml) [![Gitter](https://badges.gitter.im/leonchen83/redis-rdb-cli.svg)](https://gitter.im/leonchen83/redis-rdb-cli?utm_source=badge&utm_medium=badge&utm_campaign=pr-badge) [![Hex.pm](https://img.shields.io/hexpm/l/plug.svg?maxAge=2592000)](https://github.com/leonchen83/redis-rdb-cli/blob/master/LICENSE) ## Chat with author [![Join the chat at https://gitter.im/leonchen83/redis-rdb-cli](https://badges.gitter.im/leonchen83/redis-rdb-cli.svg)](https://gitter.im/leonchen83/redis-rdb-cli?utm_source=badge&utm_medium=badge&utm_campaign=pr-badge&utm_content=badge) ## Contract the author **chen.bao.yi@gmail.com** ## Binary release [binary releases](https://github.com/leonchen83/redis-rdb-cli/releases) ## Runtime requirement ```java jdk 1.8+ ``` ## Install ```java wget https://github.com/leonchen83/redis-rdb-cli/releases/download/${version}/redis-rdb-cli-release.zip unzip redis-rdb-cli-release.zip cd ./redis-rdb-cli/bin ./rct -h ``` ## Compile requirement ```java jdk 1.8+ maven-3.3.1+ ``` ## Compile & run ```java git clone https://github.com/leonchen83/redis-rdb-cli.git cd redis-rdb-cli mvn clean install -Dmaven.test.skip=true cd target/redis-rdb-cli-release/redis-rdb-cli/bin ./rct -h ``` ## Run in docker ```java # run with jvm docker run -it --rm redisrdbcli/redis-rdb-cli:latest rct -V # run without jvm docker run -it --rm redisrdbcli/redis-rdb-cli:latest-native rct -V ``` ## Build native image via graalvm in docker ``` docker build -m 8g -f DockerfileNative -t redisrdbcli:redis-rdb-cli . docker run -it redisrdbcli:redis-rdb-cli bash bash-5.1# rct -V ``` ## Windows Environment Variables Add `/path/to/redis-rdb-cli/bin` to `Path` environment variable ## Usage ```java Usage: rct [-hV] -f -s -o [-e ] [-d ...] [-k ...>] [-t ...] [-b ] [-l ] [-r] Options: -b, --bytes Limit memory output(--format mem) to keys greater to or equal to this value (in bytes) -d, --db ... Database number. multiple databases can be provided. if not specified, all databases will be included. -e, --escape Escape strings to encoding: raw (default), redis, json. -f, --format Format to export. valid formats are json, jsonl, dump, diff, key, keyval, count, mem and resp -h, --help Show this help message and exit. -k, --key ... Keys to export. this can be a regex. if not specified, all keys will be returned. -l, --largest Limit memory output(--format mem) to only the top n keys (by size). -o, --out Output file. -r, --replace Whether the generated aof with parameter(--format dump). if not specified, default value is false. -s, --source Source file or uri. eg: /path/to/dump.rdb redis://host:port?authPassword=foobar redis:///path/to/dump.rdb. -t, --type ... Data type to export. possible values are string, hash, set, sortedset, list, module, stream. multiple types can be provided. if not specified, all data types will be returned. -V, --version Print version information and exit. Examples: rct -f dump -s ./dump.rdb -o ./appendonly.aof -r rct -f resp -s redis://127.0.0.1:6379 -o ./target.aof -d 0 1 rct -f json -s ./dump.rdb -o ./target.json -k user.* product.* rct -f mem -s ./dump.rdb -o ./target.aof -e redis -t list -l 10 -b 1024 ``` ```java Usage: rmt [-hV] -s (-m | -c ) [-d ...] [-k ...] [-t ...] [-rl] Options: -c, --config Migrate data to cluster via redis cluster's file, if specified, no need to specify --migrate. -d, --db ... Database number. multiple databases can be provided. if not specified, all databases will be included. -h, --help Show this help message and exit. -k, --key ... Keys to export. this can be a regex. if not specified, all keys will be returned. -l, --legacy If specify the and this parameter. then use lua script to migrate data to target. if target redis version is greater than 3.0. no need to add this parameter. -m, --migrate Migrate to uri. eg: redis://host:port?authPassword=foobar. -r, --replace Replace exist key value. if not specified, default value is false. -s, --source Source file or uri. eg: /path/to/dump.rdb redis://host:port?authPassword=foobar redis:///path/to/dump.rdb. -t, --type ... Data type to export. possible values are string, hash, set, sortedset, list, module, stream. multiple types can be provided. if not specified, all data types will be returned. -V, --version Print version information and exit. Examples: rmt -s ./dump.rdb -c ./nodes.conf -t string -r rmt -s ./dump.rdb -m redis://127.0.0.1:6380 -t list -d 0 rmt -s redis://127.0.0.1:6379 -m redis://127.0.0.1:6380 -d 0 ``` ```java Usage: rdt [-hV] (-b [-g ] | -s -c | -m ...) -o [-d ...] [-k ...] [-t ...] Options: -b, --backup Backup to local rdb file. eg: /path/to/dump.rdb redis://host:port?authPassword=foobar redis:///path/to/dump.rdb -c, --config Redis cluster's file(--split ). -d, --db ... Database number. multiple databases can be provided. if not specified, all databases will be included. -g, --goal Convert db from and save to rdb file as . -h, --help Show this help message and exit. -k, --key ... Keys to export. this can be a regex. if not specified, all keys will be returned. -m, --merge ... Merge multi rdb files to one rdb file. -o, --out If --backup or --merge ... specified. the is the target file. if --split specified. the is the target path. -s, --split Split rdb to multi rdb files via cluster's . eg: /path/to/dump.rdb redis://host:port?authPassword=foobar redis:///path/to/dump -t, --type ... Data type to export. possible values are string, hash, set, sortedset, list, module, stream. multiple types can be provided. if not specified, all data types will be returned. -V, --version Print version information and exit. Examples: rdt -b ./dump.rdb -o ./dump.rdb1 -d 0 1 rdt -b ./dump.rdb -o ./dump.rdb1 -d 0 1 -g 3 rdt -b redis://127.0.0.1:6379 -o ./dump.rdb -k user.* rdt -m ./dump1.rdb ./dump2.rdb -o ./dump.rdb -t hash rdt -s ./dump.rdb -c ./nodes.conf -o /path/to/folder -t hash -d 0 rdt -s redis://127.0.0.1:6379 -c ./nodes.conf -o /path/to/folder -d 0 ``` ```java Usage: rst [-hV] -s (-m | -c ) [-d ...] [-rl] Options: -c, --config Migrate data to cluster via redis cluster's file, if specified, no need to specify --migrate. -d, --db ... Database number. multiple databases can be provided. if not specified, all databases will be included. -h, --help Show this help message and exit. -l, --legacy If specify the and this parameter. then use lua script to migrate data to target. if target redis version is greater than 3.0. no need to add this parameter. -m, --migrate Migrate to uri. eg: redis://host:port?authPassword=foobar. -r, --replace Replace exist key value. if not specified, default value is false. -s, --source Redis uri. eg: redis://host:port?authPassword=foobar -V, --version Print version information and exit. Examples: rst -s redis://127.0.0.1:6379 -c ./nodes.conf -r rst -s redis://127.0.0.1:6379 -m redis://127.0.0.1:6380 -d 0 ``` ```java Usage: ret [-hV] -s [-c ] [-p ] -n Options: -c, --config External config file, if not specified, default value is null. -h, --help Show this help message and exit. -n, --name Sink service name, registered sink service: example. -p, --parser Parser service name, registered parser service: default, dump. if not specified, default value is default -s, --source Redis uri. eg: redis://host:port?authPassword=foobar -V, --version Print version information and exit. Examples: ret -s redis://127.0.0.1:6379 -c ./config.conf -n example ret -s redis://127.0.0.1:6379 -c ./config.conf -p dump -n example ``` ### Filter 1. `rct`, `rdt` and `rmt` these 3 commands support data filter by `type`,`db` and `key` RegEx(Java style). 2. `rst` this command only support data filter by `db`. For example: ```java rct -f dump -s /path/to/dump.rdb -o /path/to/dump.aof -d 0 rct -f dump -s /path/to/dump.rdb -o /path/to/dump.aof -t string hash rmt -s /path/to/dump.rdb -m redis://192.168.1.105:6379 -r -d 0 1 -t list rst -s redis://127.0.0.1:6379 -m redis://127.0.0.1:6380 -d 0 ``` ### Redis mass insertion ```java rct -f dump -s /path/to/dump.rdb -o /path/to/dump.aof -r cat /path/to/dump.aof | /redis/src/redis-cli -p 6379 --pipe ``` ### Convert rdb to dump format ```java rct -f dump -s /path/to/dump.rdb -o /path/to/dump.aof ``` ### Convert rdb to json format ```java rct -f json -s /path/to/dump.rdb -o /path/to/dump.json ``` ### Numbers of key in rdb ```java rct -f count -s /path/to/dump.rdb -o /path/to/dump.csv ``` ### Find top 50 largest keys ```java rct -f mem -s /path/to/dump.rdb -o /path/to/dump.mem -l 50 ``` ### Diff rdb ```java rct -f diff -s /path/to/dump1.rdb -o /path/to/dump1.diff rct -f diff -s /path/to/dump2.rdb -o /path/to/dump2.diff diff /path/to/dump1.diff /path/to/dump2.diff ``` ### Convert rdb to RESP ```java rct -f resp -s /path/to/dump.rdb -o /path/to/appendonly.aof ``` ### Sync with 2 redis ```java rst -s redis://127.0.0.1:6379 -m redis://127.0.0.1:6380 -r ``` ### Sync single redis to redis cluster ```java rst -s redis://127.0.0.1:6379 -m redis://127.0.0.1:30001 -r -d 0 ``` ### Migrate rdb to remote redis ```java rmt -s /path/to/dump.rdb -m redis://192.168.1.105:6379 -r ``` ### Migrate rdb to remote redis cluster ```java rmt -s /path/to/dump.rdb -c ./nodes-30001.conf -r ``` or simply use following cmd without `nodes-30001.conf` ```java rmt -s /path/to/dump.rdb -m redis://127.0.0.1:30001 -r ``` ### Backup remote rdb ```java rdt -b redis://192.168.1.105:6379 -o /path/to/dump.rdb ``` ### Backup remote rdb and convert db to dest db ```java rdt -b redis://192.168.1.105:6379 -o /path/to/dump.rdb --goal 3 ``` ### Filter rdb ```java rdt -b /path/to/dump.rdb -o /path/to/filtered-dump.rdb -d 0 -t string ``` ### Split rdb via cluster's nodes.conf ```java rdt -s ./dump.rdb -c ./nodes.conf -o /path/to/folder -d 0 ``` ### Merge multi rdb to one ```java rdt -m ./dump1.rdb ./dump2.rdb -o ./dump.rdb -t hash ``` ### Other parameter More configurable parameter can be modified in `/path/to/redis-rdb-cli/conf/redis-rdb-cli.conf` ## Difference between rmt and rst 1. When `rmt` started. source redis first do `BGSAVE` and generate a snapshot rdb file. `rmt` command migrate this snapshot file to target redis. after this process done, `rmt` terminated. 2. `rst` not only migrate snapshot rdb file but also incremental data from source redis. so `rst` never terminated except type `CTRL+C`. `rst` only support `db` filter more details please refer to [Limitation of migration](#limitation-of-migration) ## Dashboard Since `v0.1.9`, the `rct -f mem` support showing result in grafana dashboard like the following: ![img](./images/memory-dashboard.png) If you want to turn it on. you **MUST** install `docker` and `docker-compose` first, the installation please refer to [docker](https://docs.docker.com/install/) Then run the following command: ```java cd /path/to/redis-rdb-cli/dashboard # start docker-compose up -d # stop docker-compose down ``` `cd /path/to/redis-rdb-cli/conf/redis-rdb-cli.conf` Then change parameter [metric_gateway](https://github.com/leonchen83/redis-rdb-cli/blob/master/src/main/resources/redis-rdb-cli.conf#L194) from `none` to `influxdb`. Open `http://localhost:3000` to check the `rct -f mem`'s result. If you deployed this tool in multi instance, you need to change parameter [metric_instance](https://github.com/leonchen83/redis-rdb-cli/blob/master/src/main/resources/redis-rdb-cli.conf#L240) to make sure unique between instances. ## Redis 6 ### Redis 6 SSL 1. use openssl to generate keystore ```xslt $cd /path/to/redis-6.0-rc1 $./utils/gen-test-certs.sh $cd tests/tls $openssl pkcs12 -export -CAfile ca.crt -in redis.crt -inkey redis.key -out redis.p12 ``` 2. If source redis and target redis use the same keystore. then config following parameters [source_keystore_path](https://github.com/leonchen83/redis-rdb-cli/blob/master/src/main/resources/redis-rdb-cli.conf#L255) and [target_keystore_path](https://github.com/leonchen83/redis-rdb-cli/blob/master/src/main/resources/redis-rdb-cli.conf#L284) to point to `/path/to/redis-6.0-rc1/tests/tls/redis.p12` set [source_keystore_pass](https://github.com/leonchen83/redis-rdb-cli/blob/master/src/main/resources/redis-rdb-cli.conf#L263) and [target_keystore_pass](https://github.com/leonchen83/redis-rdb-cli/blob/master/src/main/resources/redis-rdb-cli.conf#L292) 3. after config ssl parameters use `rediss://host:port` in your command to open ssl, for example: `rst -s rediss://127.0.0.1:6379 -m rediss://127.0.0.1:30001 -r -d 0` ### Redis 6 ACL 1. use following URI to open redis ACL support ```java rst -s redis://user:pass@127.0.0.1:6379 -m redis://user:pass@127.0.0.1:6380 -r -d 0 ``` 2. `user` **MUST** have `+@all` permission to handle commands ## Hack rmt ### Rmt threading model The `rmt` command use the following 4 parameters([redis-rdb-cli.conf](https://github.com/leonchen83/redis-rdb-cli/blob/master/src/main/resources/redis-rdb-cli.conf)) to migrate data to remote. ```java migrate_batch_size=4096 migrate_threads=4 migrate_flush=yes migrate_retries=1 ``` The most important parameter is `migrate_threads=4`. this means we use the following threading model to migrate data. ```java single redis ----> single redis +--------------+ +----------+ thread 1 +--------------+ | | +----| Endpoint |-------------------| | | | | +----------+ | | | | | | | | | | +----------+ thread 2 | | | | |----| Endpoint |-------------------| | | | | +----------+ | | | Source Redis |----| | Target Redis | | | | +----------+ thread 3 | | | | |----| Endpoint |-------------------| | | | | +----------+ | | | | | | | | | | +----------+ thread 4 | | | | +----| Endpoint |-------------------| | +--------------+ +----------+ +--------------+ ``` ```java single redis ----> redis cluster +--------------+ +----------+ thread 1 +--------------+ | | +----| Endpoints|-------------------| | | | | +----------+ | | | | | | | | | | +----------+ thread 2 | | | | |----| Endpoints|-------------------| | | | | +----------+ | | | Source Redis |----| | Redis cluster| | | | +----------+ thread 3 | | | | |----| Endpoints|-------------------| | | | | +----------+ | | | | | | | | | | +----------+ thread 4 | | | | +----| Endpoints|-------------------| | +--------------+ +----------+ +--------------+ ``` The difference between cluster migration and single migration is `Endpoint` and `Endpoints`. In cluster migration the `Endpoints` contains multi `Endpoint` to point to every `master` instance in cluster. For example: 3 masters 3 replicas redis cluster. if `migrate_threads=4` then we have `3 * 4 = 12` connections that connected with `master` instance. ### Migration performance The following 3 parameters affect migration performance ```java migrate_batch_size=4096 migrate_retries=1 migrate_flush=yes ``` 1. `migrate_batch_size`: By default we use redis `pipeline` to migrate data to remote. the `migrate_batch_size` is the `pipeline` batch size. if `migrate_batch_size=1` then the `pipeline` devolved into 1 single command to sent and wait the response from remote. 2. `migrate_retries`: The `migrate_retries=1` means if socket error occurred. we recreate a new socket and retry to send that failed command to target redis with `migrate_retries` times. 3. `migrate_flush`: The `migrate_flush=yes` means we write every 1 command to socket. then we invoke `SocketOutputStream.flush()` immediately. if `migrate_flush=no` we invoke `SocketOutputStream.flush()` when write to socket every 64KB. notice that this parameter also affect `migrate_retries`. the `migrate_retries` only take effect when `migrate_flush=yes`. ### Migration principle ```java +---------------+ +-------------------+ restore +---------------+ | | | redis dump format |---------------->| | | | |-------------------| restore | | | | convert | redis dump format |---------------->| | | Dump rdb |------------>|-------------------| restore | Targe Redis | | | | redis dump format |---------------->| | | | |-------------------| restore | | | | | redis dump format |---------------->| | +---------------+ +-------------------+ +---------------+ ``` ## Limitation of migration 1. We use cluster's `nodes.conf` to migrate data to cluster. because of we did't handle the `MOVED` `ASK` redirection. so limitation of cluster migration is that the cluster **MUST** in stable state during the migration. this means the cluster **MUST** have no `migrating`, `importing` slot and no switch slave to master. 2. If use `rst` migrate data to cluster. the following commands not supported `SWAPDB,MOVE,FLUSHALL,FLUSHDB,PUBLISH,MULTI,EXEC,SCRIPT FLUSH,SCRIPT LOAD,EVAL,EVALSHA`. and the following commands `RPOPLPUSH,SDIFFSTORE,SINTERSTORE,SMOVE,ZINTERSTORE,ZUNIONSTORE,DEL,UNLINK,RENAME,RENAMENX,PFMERGE,PFCOUNT,MSETNX,BRPOPLPUSH,BITOP,MSET,COPY,BLMOVE,LMOVE,ZDIFFSTORE,GEOSEARCHSTORE` **ONLY SUPPORT WHEN THESE COMMAND KEYS IN THE SAME SLOT**(eg: `del {user}:1 {user}:2`) ## Hack ret ### What ret command do 1. `ret` command that allow user define there own sink service like sink redis data to `mysql` or `mongodb`. 2. `ret` command using Java SPI extension to do this job. ### How to implement a sink service User should follow the steps below to implement a sink service. 1. create a java project using maven pom.xml ```java 4.0.0 com.your.company your-sink-service 1.0.0 UTF-8 1.8 1.8 com.moilioncircle redis-rdb-cli-api 1.5.1 provided com.moilioncircle redis-replicator [3.4.0, ) provided org.slf4j slf4j-api 1.7.25 provided maven-assembly-plugin 3.1.0 jar-with-dependencies make-assembly package single org.apache.maven.plugins maven-compiler-plugin 3.8.1 ${maven.compiler.source} ${maven.compiler.target} ${project.build.sourceEncoding} ``` 2. implement `SinkService` interface ```java public class YourSinkService implements SinkService { @Override public String sink() { return "your-sink-service"; } @Override public void init(File config) throws IOException { // parse your external sink config } @Override public void onEvent(Replicator replicator, Event event) { // your sink business } } ``` 3. register this service using Java SPI ```java # create com.moilioncircle.redis.rdb.cli.api.sink.SinkService file in src/main/resources/META-INF/services/ |-src |____main | |____resources | | |____META-INF | | | |____services | | | | |____com.moilioncircle.redis.rdb.cli.api.sink.SinkService # add following content in com.moilioncircle.redis.rdb.cli.api.sink.SinkService your.package.YourSinkService ``` 4. package and deploy ```java mvn clean install cp ./target/your-sink-service-1.0.0-jar-with-dependencies.jar /path/to/redis-rdb-cli/lib ``` 5. run your sink service ```java ret -s redis://127.0.0.1:6379 -c config.conf -n your-sink-service ``` 6. debug your sink service ```java public static void main(String[] args) throws Exception { Replicator replicator = new RedisReplicator("redis://127.0.0.1:6379"); Runtime.getRuntime().addShutdownHook(new Thread(() -> { Replicators.closeQuietly(replicator); })); replicator.addExceptionListener((rep, tx, e) -> { throw new RuntimeException(tx.getMessage(), tx); }); SinkService sink = new YourSinkService(); sink.init(new File("/path/to/your-sink.conf")); replicator.addEventListener(new AsyncEventListener(sink, replicator, 4, Executors.defaultThreadFactory())); replicator.open(); } ``` ### How to implement a formatter service 1. create `YourFormatterService` extend `AbstractFormatterService` ```java public class YourFormatterService extends AbstractFormatterService { @Override public String format() { return "test"; } @Override public Event applyString(Replicator replicator, RedisInputStream in, int version, byte[] key, int type, ContextKeyValuePair context) throws IOException { byte[] val = new DefaultRdbValueVisitor(replicator).applyString(in, version); getEscaper().encode(key, getOutputStream()); getEscaper().encode(val, getOutputStream()); getOutputStream().write('\n'); return context; } } ``` 2. register this formatter using Java SPI ```java # create com.moilioncircle.redis.rdb.cli.api.format.FormatterService file in src/main/resources/META-INF/services/ |-src |____main | |____resources | | |____META-INF | | | |____services | | | | |____com.moilioncircle.redis.rdb.cli.api.format.FormatterService # add following content in com.moilioncircle.redis.rdb.cli.api.format.FormatterService your.package.YourFormatterService ``` 3. package and deploy ```java mvn clean install cp ./target/your-service-1.0.0-jar-with-dependencies.jar /path/to/redis-rdb-cli/lib ``` 4. run your formatter service ```java rct -f test -s redis://127.0.0.1:6379 -o ./out.csv -t string -d 0 -e json ``` ## Contributors * [Baoyi Chen](https://github.com/leonchen83) * [Jintao Zhang](https://github.com/tao12345666333) * [Maz Ahmadi](https://github.com/cmdshepard) * [Anish Karandikar](https://github.com/anishkny) * Special thanks to [Kater Technologies](https://www.kater.com/)