transfer from server with mariadb 10.3 to server with mysql 8.0

[bitpt]

When try transfer from a server with Mariadb10.3 to Mysql 8.0 transfer in some databases got error and do not work.
However, when do a fullbackup and a restore work always well.
Now i need transfer a large site(more then 200G) and transfer is better option (site not stop).
Anyone know why in fullbackup and restore work fine, but not in direct transfer?

Thank You!!!

 

[bitpt]

seems user in "stream account transfer" is username and with "restorepkg" is root.

Solve this, first transfer (server load is much lower), then dump db with root permissions.

Account transfer needs an option to allow restore with root or any other mechanism or option that allows transferring the db without issues.

 

[Steini Petur]

Hi,
Please note that if you have a large server, you may run into much more than a brick wall when going over from 10.3 to 8.0

Careful when migrating from 6 to 8 (Serious complications)

Hey guys, I just wanted to write this friendly reminder because of the errors that we went through, we were migrating from Cloudlinux 6 to Cloudlinux 8.5, the previous version of SQL was MariaDB and by default, and here is the thing, the default MySQL is 8! on the new cPanel you can avoid this...

forums.cpanel.net

These were just the few issues we ran into, I had to help clients with databases which had TEXT DEFAULT which are not allowed in 8, what you may not realize is if you are restoring 100's upon 100's of databases and accounts you may miss the text when it just didn't add the database for John or Jane..

I will be doing another set of 6 servers for our company but I will be staying away from MySQL 8.0!, Ill start at 10.3 MariaDB and go with it, remember if you do 8.0 you cant roll back.

My best way to do this especially if its many accounts is to do this

Backup in commandline
for x in `ls /var/cpanel/userdata`; do /scripts/pkgacct $x; done

Once done, I like to move them fast so
for x in `ls -arth /home | grep tar.gz`; do rsync -avh --progress -e 'ssh -p (port) -T -o Compression=no -x' $x root@(IP):/home/; done

Then just loop through them to restore
for x in `ls /home | grep tar.gz`; do /scripts/restorepkg --unrestricted --force --allow_reseller $x; done

Just my two cents, and careful with MySQL 8.0 cant stress the hell I was in for 2 nights straight. Remember if you are not in Console and an SSH session, do this in screen, so you can get back to it with screen -r in case you lose the connection. Also remember that doing things with backup tool cpbackup, it relies on your system load so it can constantly pause for a while when it's waiting for load to go down, pain in the ass, didn't have that issue with pkgacct but it also can be tweaked in WHM > Tweak

 

[cPRex]

@bitpt - if you're seeing issues with the Transfer Tool, could we get access to a server experiencing that problem so we can check that out?

 

[bitpt]

one or both ???

 

[cPRex]

When you create the support ticket with our team we'd need access to both the Source and Destination so we can check the migration details.

 

[bitpt]

I already migrate all dbs and is working fine.
If you want find what happened for this stream migration fail, thats ok, but pls don't migrate again, server already working after dumping dbs.

Can you send ticket link or submit a normal ticket?

 

[cPRex]

You would just need to submit a normal ticket.

 

[Esquio]

This is a shame. I buy a new server that is different than others due AlmaLinux 8 and cPanel 104 has not MariaDB on the selector like others, it installs mysql 8 by default. MySQL 8 is somekind of crap, comparing to MariaDB 10.3 that is better in all aspects. I don't know why cPanel adopts that decision, maybe commercial topics.

 

[cPRex]

@Esquio - you can customize a new installation to install a specific MySQL/MariaDB version using the details listed here:

Customize Your Installation | cPanel & WHM Documentation

This document describes how to customize your cPanel & WHM installation.

docs.cpanel.net

 

[quietFinn]

... it installs mysql 8 by default. ..

Yes it install MySQL 8 by default but when you install cPanel you can choose MariaDB to be installed, read here:

Customize Your Installation | cPanel & WHM Documentation

This document describes how to customize your cPanel & WHM installation.

docs.cpanel.net

 

[Esquio]

Yes it install MySQL 8 by default but when you install cPanel you can choose MariaDB to be installed, read here:

Customize Your Installation | cPanel & WHM Documentation

This document describes how to customize your cPanel & WHM installation.

docs.cpanel.net

Yes, I read it above, but I think it's a regression with what we have in previous versions, that not needs config files and terminal intervention to allow the mariadb installation, it comes by default and we can choose it.
However, I read it now, but when I purchase the new server and encounters that problem, I have to hurry to prepare the server and I not repaired on "maybe new cpanel replaces the web UI with parameters on config files", to check it out if exists. I work with cPanel since 2014 and it's the first time that I encountered this.

 

[cPRex]

Is there a specific issue you're having with MySQL 8?

 

[Timway Support]

cPanel should show that pink box on the installation process!!
Our usual experience tell us that we can change the db engine after install.... but that's not the case.

 

[cPRex]

@Timway Support - is there a certain issue you're running into with the installation?

 

[Timway Support]

We use the usual installation command we found on Installation | cPanel & WHM Documentation to install a new cPanel server for migration.
We run the script as usual, after cPanel installed, we found that there is no way to change the database engine to Mariadb and stuck in MySQL 8.0
Our original server is running Mariadb, and we want to keep everything as smooth as possible. We have to use Mariadb.
So what we done? we take down the server from the production rack and reinstall the OS again.

And on this guild, no pink warning box
Installation | cPanel & WHM Documentation

The pink box only show on this customization page:

Customize Your Installation | cPanel & WHM Documentation

This document describes how to customize your cPanel & WHM installation.

docs.cpanel.net

We expect we can choose the DB engine after we install the cPanel, if that's nor possible, please consider show the pink box right before the "installation" command box.

 

[cPRex]

There is currently not a supported way to move back to MariaDB from MySQL 8 as that is considered a downgrade.

 

[Timway Support]

We are looking for cPanel to show more noticeable message on the installation process, and require the operator to confirm / select (any interaction) a db engine type for a irreversible installation process.

 

[cPRex]

Can you use the link in my signature to submit a feature request, or would you like me to do that for you?

 

[Timway Support]

Please create the feature request for us. I guess you are more familiarize with it and need to know what kind of information need to provide. Thank you.