Yes I used the SeaweedFS but the restore doesn't give any error but data is not loaded properly.
cluster-deployment.yaml
apiVersion: mysql.oracle.com/v2
kind: InnoDBCluster
metadata:
name: mycluster
spec:
secretName: mycluster-user
instances: 3
tlsUseSelfSigned: true
router:
instances: 1
initDB:
dump:
name: hourly-backup
storage:
s3:
bucketName: sample
prefix: /mysql/mycluster-hourly230425174209/
config: s3-secret
profile: default
endpoint:
http://s3-service:8333
Logs:
2023-04-25 17:54:20,218] sidecar [INFO ] Executing load_dump(/mysql/mycluster-hourly230425174209, {'progressFile': '', 's3BucketName': 'sample', 's3Profile': 'default', 's3EndpointOverride': '
http://s3-service:8333';})
Loading DDL and Data from AWS S3 bucket=sample, prefix='/mysql/mycluster-hourly230425174209' using 4 threads.
Opening dump...
Target is MySQL 8.0.32. Dump was produced from MySQL 8.0.32
Fetching dump data from remote location...
Listing files...
Listing files - done
Scanning metadata...
Scanning metadata - done
Checking for pre-existing objects...
Executing common preamble SQL
Executing DDL...
Executing DDL - done
Executing view DDL...
Executing view DDL - done
Loading data...
Starting data load
Recreating indexes...
Loading data - done
Recreating indexes - done
Executing common postamble SQL
No data loaded.
0 warnings were reported during the load.
[2023-04-25 17:54:20,421] sidecar [INFO ] Load_dump finished
[2023-04-25 17:54:20,422] sidecar [INFO ] Creating local accounts
[2023-04-25 17:54:20,435] sidecar [INFO ] Resetting password for mysqladmin@%
[2023-04-25 17:54:20,440] sidecar [INFO ] Dropping cloned mysql_innodb_cluster_metadata schema
[2023-04-25 17:54:20,511] sidecar [INFO ] Configuration finished
[2023-04-25 17:54:20,517] sidecar [INFO ] Server.TLS.useSelfSigned: True
[2023-04-25 17:54:20,518] sidecar [INFO ] Starting Operator request handler...
[2023-04-25 17:54:20,529] kopf.activities.star [INFO ] sidecar: configure()
[2023-04-25 17:54:20,535] kopf.activities.star [INFO ] Activity 'configure' succeeded.
[2023-04-25 17:54:20,538] kopf._core.engines.a [INFO ] Initial authentication has been initiated.
[2023-04-25 17:54:20,543] kopf.activities.auth [INFO ] Activity 'login_via_client' succeeded.
[2023-04-25 17:54:20,543] kopf._core.engines.a [INFO ] Initial authentication has finished.
[2023-04-25 17:54:20,618] kopf._core.reactor.o [WARNING ] Not enough permissions to list namespaces. Falling back to a list of namespaces which are assumed to exist: {'default'}
[2023-04-25 17:54:20,634] kopf._core.reactor.o [WARNING ] Not enough permissions to watch for resources: changes (creation/deletion/updates) will not be noticed; the resources are only refreshed on operator restarts.
[2023-04-25 17:54:20,635] kopf._core.reactor.o [WARNING ] Not enough permissions to watch for namespaces: changes (deletion/creation) will not be noticed; the namespaces are only refreshed on operator restarts.
^C