how do we migrate the keyring key from enterprise mysql 5.7 to Percona 8.4.3 mysql component keyring i.e. copy keys from one keystore to another. taking a mysql dump of 5.7 and importing into 8.4.3 works as new keys are generated through component keyring,
but the ask is, first migrate the keyring key to 8.4.3, then transfer mysql data directory from 5.7 to 8.4.3 (both are remote and data size is huge, but easier to copy than mysqldump option), apply required permissions and restarting 8.4.3 should work seamlessly. in this, tried couple of options to migrate the keys using mysqld and mysql_migrate_keyring. mysqld (8.4.3, and the component_keyring_file.so is there in plugin directory) reported an error saying;
Can’t find symbol ‘mysql_plugin_interface_version’ in library.
Couldn’t load plugin named ‘component_keyring_file.so’ with soname ‘component_keyring_file.so’.
the command is.
mysqld --defaults-file=/etc/keyring.cnf --keyring-migration-source=keyring_file.so --keyring-migration-destination=component_keyring_file.so --user=mysql