michaelcaplan

Member
Aug 15, 2003
19
0
151
Hi there,

I am considering setting up my Cpanel box to use a MySQL server on a remote machine to reduce the load on the box. I understand that I can get Cpanel to use the remote MySQL server by telling it so with the "Setup Remote MySQL server" option under WHM. But, I am a little uncertain about how this will actually work (there is very little documentation on this).

I'm hoping that others running Cpanel boxes with this setup can help me fill in some of the blanks.

Will Cpanel firmly intergrate with the secondary MySQL server as it does with the service running locally? Will Cpanel backups work the same? Will users be able to check MySQL service status the same way? Are there any differences to how Cpanel will run with MySQL hosted remotelly vs. on the same box?

Also, I am curious for those who have set this up if you have any tips for ensuring that the two servers will work at optimum speeds between each other.

Thanks,

Michael
 

michaelcaplan

Member
Aug 15, 2003
19
0
151
FYI, according to Cpanel tech support:

Using a remote MySQL setup, will be functionaly the same a using a local setup. Since you are configuring all your customer connections to occur over tcp, the only difference will be their connection string. On the backend, the only applications that I can think of that are connecting with domain sockets are horde,squirrel mail, and phpMyAdmin. All these connections are built dynamically from system variables determined by your configuration. All service status information should be displayed normally. So no worries there either.