Hi team,
I want to migrate from MySQL Enterprise 8.0.32 to Percona MySQL 8.0.Is there any documentation that I can follow to assist me migrate successfully?
Hello Chris,
You can simply shut down MySQL Enterprise 8.0.32, remove the packages, install the Percona 8.0.32 packages and then start up MySQL. If you are using any Enterprise-specific plugins, disable/unload them first before stopping.
Hi Matthewb,
Thank you for your quick response.Will this not affect my data?I wanted to do it in such a way that it will not affect my current MySQL schemas.
Thanks once again
It will not affect your data. There are no on-disk changes between Enterprise and Percona. Just make sure the versions match. Please take a backup before you proceed with the upgrade. Worst case scenario, make a logical backup of Enterprise using mysqldump or mydumper and then restore that to a fresh Percona install.
Ok.I will try that one out and let you know the outcome.
Hi matthewb,
I am trying to install percona client and server on rocky linux 8.9 but getting some dependency errors as follows:
warning: percona-server-client-8.0.32-24.1.el9.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 8507efa5: NOKEY
error: Failed dependencies:
libc.so.6(GLIBC_2.33)(64bit) is needed by percona-server-client-8.0.32-24.1.el9.x86_64
libc.so.6(GLIBC_2.34)(64bit) is needed by percona-server-client-8.0.32-24.1.el9.x86_64
libcrypto.so.3()(64bit) is needed by percona-server-client-8.0.32-24.1.el9.x86_64
libcrypto.so.3(OPENSSL_3.0.0)(64bit) is needed by percona-server-client-8.0.32-24.1.el9.x86_64
libreadline.so.8()(64bit) is needed by percona-server-client-8.0.32-24.1.el9.x86_64
libssl.so.3()(64bit) is needed by percona-server-client-8.0.32-24.1.el9.x86_64
libssl.so.3(OPENSSL_3.0.0)(64bit) is needed by percona-server-client-8.0.32-24.1.el9.x86_64
libstdc++.so.6(GLIBCXX_3.4.29)(64bit) is needed by percona-server-client-8.0.32-24.1.el9.x86_64
percona-server-shared is needed by percona-server-client-8.0.32-24.1.el9.x86_64
I seem not to find the files anywhere.
You’re trying to install EL9 (9.*) binaries into an EL8 (8.9) OS. Please download the el8 packages for your EL8 OS.
Hi Matthewb,
It has worked perfectly.Thank you for your prompt support on my installation.
Hi Matthewb,
One more question.Is it okay to run percona mysql 8.0.32 with PXC 8.0.35 or they have to be the same versions all through including the xtradb backup?
Same versions everywhere for everything. Do not attempt to downgrade as this just won’t work. (ie you cannot downgrade from 8.0.35 to 8.0.32)
Hi matthewb,
I am trying to create a cluster of 3 nodes.But when I try to bootstrap the first node,I get the following error. Could you be having any idea what I am missing?
[mysqluser@prod-mysql-node03 ~]$ systemctl start mysql@bootstrap.service
==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ====
Authentication is required to start ‘mysql@bootstrap.service’.
Authenticating as: Mysqluser-DB Account (mysqluser)
Password:
==== AUTHENTICATION COMPLETE ====
Job for mysql@bootstrap.service failed because the control process exited with error code.
See “systemctl status mysql@bootstrap.service” and “journalctl -xe” for details.
When I check the bootstrap.service,this is what I get:
[mysqluser@prod-mysql-node03 ~]$ systemctl status mysql@bootstrap.service
● mysql@bootstrap.service - Percona XtraDB Cluster with config /etc/sysconfig/mysql.bootstrap
Loaded: loaded (/usr/lib/systemd/system/mysql@.service; disabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Thu 2024-02-15 08:33:41 EAT; 2min 6s ago
Process: 26134 ExecStopPost=/usr/bin/mysql-systemd stop-post (code=killed, signal=TERM)
Process: 26099 ExecStartPre=/usr/bin/mysql-systemd start-pre (code=exited, status=1/FAILURE)
Feb 15 08:32:11 prod-mysql-node03.ipsl.co.ke systemd[1]: Starting Percona XtraDB Cluster with config /etc/sysconfig/mysql.boo>
Feb 15 08:32:11 prod-mysql-node03.ipsl.co.ke mysql-systemd[26099]: WARNING: Another instance of mysqld running on 2083, exit>
Feb 15 08:32:11 prod-mysql-node03.ipsl.co.ke systemd[1]: mysql@bootstrap.service: Control process exited, code=exited status=1
Feb 15 08:33:41 prod-mysql-node03.ipsl.co.ke systemd[1]: mysql@bootstrap.service: State ‘stop-post’ timed out. Terminating.
Feb 15 08:33:41 prod-mysql-node03.ipsl.co.ke systemd[1]: mysql@bootstrap.service: Failed with result ‘exit-code’.
Feb 15 08:33:41 prod-mysql-node03.ipsl.co.ke systemd[1]: Failed to start Percona XtraDB Cluster with config /etc/sysconfig/my>
lines 1-12/12 (END)
Could you know what I am missing?
Please open a new post for new issues. Thanks.