Not the answer you need?
Register and ask your own question!

Migration from MariaDB to Percona 8 cPanel

HostFoxHostFox EntrantCurrent User Role Participant
Hello,
Just want to say, i don't have that much experience with everything, so please don't be angry if i ask stupid questions.

I asked the mycpadmin team to try migrate from MariaDB 10.3 to Percona 8.
As i really want to migrate to Percona 8 but it's unsuccessful every time.

They tried even to do it for Percona 5.6/5.7 but always there was a problem with permissions or phpmyadmin:

[IMG2=JSON]{"data-align":"none","data-size":"full","height":"88","width":"190","src":"https:\/\/www.percona.com\/forums\/filedata\/fetch?filedataid=1456&type=thumb&attachmentnodeid="}[/IMG2]
https://i.gyazo.com/0636b839568db6aa9e15609c2efdfa05.png

And then when they failed after 14 hours they sended me those messages:
If you would like to try precona8 it is suggested to test in any test server. If it is working fine, then we can implement in production server. Let us know if you face any other issue on the server

If you are really trying for performance oriented Database server you are required, then you can get any remote MySQL server running. Ex: you can contact Percona support and explain your requirement and ask them for support to migrate the data too. They can offer some better solution. Below is the AWS based database service offered by percona with mgiration data.

https://www.percona.com/solutions/build/cloud-database-services/aws

If they support either we can use below option provided by cPanel to confgiure profile or you can directly use the configuration on your site config.php files to make use of it

https://documentation.cpanel.net/display/74Docs/Manage+MySQL+Profiles

But either of them has no guarantee


I am looking for help, i can even pay if someone would be able to migrate it, or tell the steps to the technical support team from mycpadmin to try different way.
Migration is not big, there are around 20 databases on the whole server some of them are 300MB MAX. So it's not that big deal.

But my point is to use Percona 8 instead of MariaDB..

Any answers would be much appreciated.

Thank you,

Regards.

Comments

  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Mentor
    Hi
    Thanks for your question.
    Just to confirm your situation, you are currently on shared hosting and would like to replace the MariaDB 10.3 database(s) with Percona Server for MySQL 8? I will drop you an email about this, since as you have mentioned if we are able to help it's more likely a paid engagement since it's very specific to your needs/environment.
  • HostFoxHostFox Entrant Current User Role Participant
    Hi
    Thanks for your question.
    Just to confirm your situation, you are currently on shared hosting and would like to replace the MariaDB 10.3 database(s) with Percona Server for MySQL 8? I will drop you an email about this, since as you have mentioned if we are able to help it's more likely a paid engagement since it's very specific to your needs/environment.

    Hello, i own my hosting company, which runs on cPanel, cPanel by default dosen't support Percona 8, which is really bad for me, because i really want Percona 8 to have as my main MySQL server, currently i am on MariaDB but i would love to switch to Percona 8, so my costumers can have what they really wanted :).

    Thank you for your time and appreciate it!
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.