Can you transfer a cPanel server with MariaDB 10.3 to a server with MySQL 8?

Operating System & Version
CentOS 7
cPanel & WHM Version
96.0.7

WebHostPro

Well-Known Member
PartnerNOC
Jul 28, 2002
1,715
28
328
LA, Costa RIca
cPanel Access Level
Root Administrator
Twitter
We are migrating an older server that uses MariaDB 10.3 and we want to use MySQL 8 on the new server. There is about 30 cPanel accounts on the old server.

Will there be any compatibility issues with default cPanel set ups? No custom software or configurations or used on MariaDB or MySQL.
 

andrew.n

Well-Known Member
Jun 9, 2020
633
183
43
EU
cPanel Access Level
Root Administrator
I would first upgrade to MySQL 8 on the old server to make sure everything is working okay and then proceed with the migration over to the new server.
 

quietFinn

Well-Known Member
Feb 4, 2006
1,329
141
193
Finland
cPanel Access Level
Root Administrator
I would first upgrade to MySQL 8 on the old server to make sure everything is working okay and then proceed with the migration over to the new server.
I don't think that's possible (n WHM anyway). in WHM -> SQL Services -> MySQL/mariaDB Upgrade: " Also note that since MariaDB is installed, moving to MySQL 8 is considered a downgrade, and therefore not supported. "

I would do a test transfer and see how it goes.
 

andrew.n

Well-Known Member
Jun 9, 2020
633
183
43
EU
cPanel Access Level
Root Administrator
@quietFinn is right, direct upgrade from MariaDB to MySQL 8 is not supported due to some incompatibilities between the 2 versions. I can also suggest to do a full transfer without pointing the domains over to the new server and using your hosts file you can test how it is and then proceed with the live transfer.
 
  • Like
Reactions: quietFinn

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
7,492
1,008
313
cPanel Access Level
Root Administrator
We do recommend trying to match the MySQL version as close as possible, even with transfers we perform for clients in our ticket system. You may want to try @andrew.n 's suggestion of moving over one domain and testing that on the new server before switching DNS or performing a live transfer.