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

[WebHostPro]

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]

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]

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]

@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.

 

[cPRex]

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.