Remote sql servers
If I were to set up a remote mysql server, and move all data from my local mysql server, would cpanel be able to use it just like before? Would all databases linked to user accounts still show up properly?
Thanks
-
soja92, cPanel will list the databases present in the local server only. Why would you want to list the remote db's here ? 0 -
I want to transition all current databases to an external server(on LAN) to compartmentalize the services. I have a lot of services that rely on SQL in addition to my website. 0 -
soja92, you will have to modify your codes to establish connection to the remote server, instead of the localhost. You wont be able to see the db's in a remote server on your cPanel interface. 0 -
Hello :) Actually, you can use the following option in Web Host Manager: "WHM Home " SQL Services " Setup Remote MySQL Server" It's documented here: Setup Remote MySQL Server Thank you. 0 -
[quote="cPanelMichael, post: 1687171">Hello :) Actually, you can use the following option in Web Host Manager: "WHM Home " SQL Services " Setup Remote MySQL Server" It's documented here: Setup Remote MySQL Server Thank you.
Thanks for the information. That is the feature I was going to use. I do however have a few questions. Does the mysql server need to have a WHM/cPanel license? seems a bit wasteful. Will there be any impact on how the databases work within cpanel? Assuming I copy over all users/data to the remote server.0 -
No you don't need a cpanel license on the database server if you just set up a plain Linux server with Mysql. Once it runs it ought to be quite transparent to the users. The documentation is not complete imo. It fails to explain how to practically implement it, particularly on a server that already have local mysql databases. As far as I understand it you start by installing a server with mysql, then follow the WHM documentation in order to allow the WHM server to communicate with the remote mysql server. The documentation mentions that you need to manually copy over the databases, but I think the details are not clear. - the documentation mentions databases needs to be copied over manually, but completely lacks details. I would presume by shutting down mysql on both servers and then copy over /var/lib/mysql ought to do the trick, but it would be nice to have that confirmed. - generally scripts such as wordpress or joomla use localhost as database host name. Presumably if the database is moved to another server someone will need to go through all the config files and change the database host names accordingly. Just changing the ip address for localhost in /etc/hosts would probably not be wise. - I think this would also be the case with tools such as phpmyadmin, also this is not addressed by the documentation. It would be nice if we could have these things clarified. 0 -
That sums up the information I am looking for. Thank you for the reply. Bump Does anyone have answers to these questions? 0 -
[quote="soja92, post: 1688111">Thanks for the information. That is the feature I was going to use. I do however have a few questions. Does the mysql server need to have a WHM/cPanel license? seems a bit wasteful. Will there be any impact on how the databases work within cpanel? Assuming I copy over all users/data to the remote server.
1. No, cPanel is not required on the remote MySQL server. However, note that if you do choose to install cPanel/WHM on the remote server, then a license is required. 2. You should not have to modify the configuration files for your scripts after you migrate your databases to the remote server. You should be able to continue using "localhost" after enabling of the remote MySQL server option. Thank you.0
Please sign in to leave a comment.
Comments
8 comments