Question: Setup Remote MySQL server

fkatzenb

Well-Known Member
Sep 23, 2009
216
0
66
Lusby, Maryland, United States
cPanel Access Level
Root Administrator
When using 'Setup Remote MySQL server', is it exclusive or inclusive? I would like to offload a few heavy hitters to a dedicated MySQL server and want to know if this features allows the use of both localhost and a remote host.

Thanks,
Frank
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
The feature allows using both local and remote so long as the connection script puts the right configuration to connect, but any new databases will be setup remotely rather than locally. Basically, you would need to have the databases you want to remain local not copied when you move the others to the remote MySQL server and keep MySQL running on both machines. Any new databases will automatically be created on the remote machine.