Migrate to remote MySQL

[maquinadigital]

Greetings,

I have a VM server running CPANEL 11.30.1, with local MySQL.

I think it's time to move to a remote, dedicated MySQL server but, as it's a production system for almost 1000 domains, I need to know some things before I move.
So, I thought I come and ask the experts

1. Is there any way to migrate the local databases do the remote DB, in CPANEL? I'll have to do that manually?
These are the manual steps i thought of:
- dump local mysql
- shutdown local mysql
- import dump into remote
- configure cpanel and add remote mysql server


2. Is it possible that the remote MySQL is a "MySQL Cluster"?

Any help and tips would be appreciated.

Best regards
Daniel

[cPanelTristan]

For 1, that would appear to be a good method to migrate the databases to dump them to ensure you have a good back, stop MySQL locally entirely, import the data to the remote machine, and then configure WHM to connect to the remote MySQL server.

I'm a bit uncertain for question 2 if you are asking if you can connect multiple cPanel machines to 1 remote MySQL machine. If you are asking this, then it is possible to do that yes. We have a few discussions on this at the following location:

http://forums.cpanel.net/f49/setup-s...tml#post784042
http://forums.cpanel.net/f334/transf...-a-171466.html

[maquinadigital]

thank you for your feedback.

About question 2, I meant this: MySQL :: MySQL Cluster

Best regards
Daniel

[cPanelTristan]

Hello Daniel,

I'm not entirely certain on this one, but provided MySQL Cluster works the same in functionality as MySQL does normally and it is rpm-based, I do not see how this would pose an issue. I would suggest getting up a test cPanel box first to try this out to ensure cPanel can properly work with it before switching over your existing production server.

Thanks!

[maquinadigital]

Hi,

thank you for your feedback.

I'll do that and then I'll get back here to post more information.

Best regards
Daniel