Percona xtrabackup bypass xbcloud locally for retore

MySQL & MariaDB Percona XtraBackup
1

I normally sync to my storage box which is running minio via xtrabackup and xbcloud put similar to Use the xbcloud binary with MinIO - Percona XtraBackup. Then in order to restore a backup I use this command:

xbcloud get s3://database/202311112041-full_backup --s3-endpoint='http://storage.domain.com:9000' --s3-access-key='minioadmin' --s3-secret-key='#####' --parallel=10 | xbstream -x -C restore --parallel=8

However, I want to restore the backup on the local minio server; So I want to access the backup but not have it go through xbcloud/s3 since I am executing the commands locally and just want to use xbstream to restore it.

Is this possible? What command would I run assuming s3://database/202311112041-full_backup correlates to /mnt/data/database/202311112041-full_backup

2

I believe that xbcloud breaks up the backup stream into equal sized fragments for storage into S3. If you simply run the equivalent of aws s3 ls s3://path/to/backup you’ll see what I mean. As such, you must use xbcloud to stitch the fragments back together for restore.

3

I have xbcloud, how do I stitch the files back together?

For example

ibdata1.qp.00000000000000000000 ibdata1.qp.00000000000000000001 ibdata1.qp.00000000000000000002

back to

ibdata1.qp

i tried

cat ibdata1.qp.00000000000000000000 ibdata1.qp.00000000000000000001 ibdata1.qp.00000000000000000002 > ibdata1.qp;
qpress -do ibdata1.qp > ibdata1

Results in qpress: Source file was not compressed with qpress so I believe xbcloud must stitch files in a special way

4

Hello @bhare,
Use xbcloud to also fetch and stitch files back together.

5

I no longer have an s3 compatible service. Before it discontinued I downloaded all the raw files to my local disk. Now I have unstitched local files. Is my only option to host a local minio server and pretend I have a server on 127.0.0.1?

6

Yes, I would say that is the fastest way to move forward, setting up a local minio.