databend mysql on storj s3

databend mysql on storj s3.txt

$ wget https://github.com/datafuselabs/databend/releases/download/v0.7.51-nightly/databend-v0.7.51-nightly-x86_64-unknown-linux-musl.tar.gz
$ tar xf databend-v0.7.51-nightly-x86_64-unknown-linux-musl.tar.gz
$ nano databend-query.toml
$ cat databend-query.toml
[storage]
type = "s3"

[storage.s3]
bucket = "databend"
endpoint_url = "https://gateway.us1.storjshare.io"
access_key_id = "<storj s3 key>"
secret_access_key = "<storj s3 secret>"
$ nohup ./databend-query -c ./databend-query.toml >/dev/null 2>&1 &

# visit https://us1.storj.io/buckets/management
# click "New Bucket" to create a new bucket named "databend"

$ mysql -h127.0.0.1 -uroot -P3307
CREATE TABLE t1(a INT);
INSERT INTO t1 VALUES(1), (2);
SELECT * from t1;

#migrate metadata(databases, tables, row_ids etc, it seems that only row_datas saved in s3):
scp _meta_embedded/db root@<another vps ip>:/root/_meta_embedded/db