Migrate enterprise mysql 5.7 keyring file to Percona 8.4 component key ring file

MySQL & MariaDB Percona Distribution for MySQL
, ,
1

I migrated database from mysql enterprise edition 5.7.36 to Percona 8.4.3. mysql 5.7 uses keyring_file plugin and mysql 8.4 uses component keyring file. Installed 8.4.3 and configured mysql and then later replaced data directory from mysql 5.7. the server wont start as the keyring from 5.7 is not migrated/copied to 8.4.3 component keyring.

I tried various options in mysql_migrate_keyring and mysqld to migrate the keyring_file to component keyring file. I could not get through. Please help me here. Thanks

I could not find enough materials on the web to proceed further. Thank you.

how do we migrate keys and start the 8.4 mysql?

1 Like
2

Hello @perconaplanet
The version upgrade path should be 5.7 to 5.7 latest.
5.7 latest to 8.0 latest percona server.
Once the percona server is upgraded to latest 8.0 version, you should be able to use keyring component,

Make sure that component cnf file is placed in plugin directory and it points to the old keyring file only.
Take a backup of the keyring file and test it on the test environment before doing it on the production environment.
The keyring file is not suggested for prod, though. You should think about keyring vault.
Regards,
Yunus Shaikh