Hello,
I’m trying to restore a backup of an on-premise Percona MySQL 8.0 database in AWS but the operation never ends.
I’m testing with a 30GB Percona MySQL replica (real DB is 2TB):
mysql> SHOW VARIABLES LIKE 'version%';
+-------------------------+-----------------------------------------------------+
| Variable_name | Value |
+-------------------------+-----------------------------------------------------+
| version | 8.0.42-33 |
| version_comment | Percona Server (GPL), Release 33, Revision 9dc49998 |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
| version_compile_zlib | 1.3.1 |
| version_suffix | |
+-------------------------+-----------------------------------------------------+
xtrabackup version 8.0.35-36 based on MySQL server 8.0.35 Linux (x86_64) (revision id: 7233322c)
Backup command:
xtrabackup --backup --user=<USER> --password='<PASS>' --slave-info --safe-slave-backup --parallel=2 --stream=xbstream \
--target-dir=<BACKUP_PATH> | split -d --bytes=500MB \
- <BACKUP_PATH>/backup.xbstream
Upload command:
aws s3 cp \
<BACKUP_PATH> \
"s3://$BUCKET_NAME/backup/" \
--recursive
Once it’s done, I navigated to RDS Service in the AWS Console and clicked on Restore from S3. After that, I selected the <BUCKET_NAME> where I uploaded backups files and the prefix backup that I set in the previous command.
After Creating database task started; my problem is that process never ends, I don’t get any error or progress update message, even when this task was running for more than 10 hrs.
Cluster status: Preparing-data-migration
Instance status: Creating
I checked some compatibility parameters, such as:
mysql> SHOW VARIABLES LIKE 'innodb_data_file_path';
+-----------------------+------------------------+
| Variable_name | Value |
+-----------------------+------------------------+
| innodb_data_file_path | ibdata1:12M:autoextend |
+-----------------------+------------------------+
mysql> SHOW VARIABLES LIKE 'binlog_format';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| binlog_format | ROW |
+---------------+-------+
mysql> SELECT
ENGINE,
COUNT(*) AS table_count
FROM information_schema.TABLES
WHERE TABLE_SCHEMA NOT IN (
'mysql',
'information_schema',
'performance_schema',
'sys'
)
AND TABLE_TYPE = 'BASE TABLE'
GROUP BY ENGINE
ORDER BY table_count DESC;
+--------+-------------+
| ENGINE | table_count |
+--------+-------------+
| InnoDB | 214 |
+--------+-------------+
mysql> SELECT TABLE_SCHEMA,
TABLE_NAME,
ENGINE
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'mysql'
AND TABLE_NAME LIKE 'compression_dictionary%';
Empty set (0.00 sec)
mysql> SHOW TABLES FROM mysql LIKE '%compression%';
Empty set (0.00 sec)
Has anyone idea what might be going wrong with this approach?
Is this setup even possible?
Thank you!
Regards,
