+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: MySql on another Server (/thread-6668.html)
MySql on another Server - RedSec - 05-08-2009 05:52 AM
Hi all,
I want to know how to get the sql is on another server.
So have the SQL server on the server 2 and the rest on the 1.
Thank you
RE: MySql on another Server - timaaarrreee - 05-10-2009 11:38 AM
(05-08-2009 05:52 AM)RedSec Wrote: Hi all,
I want to know how to get the sql is on another server.
So have the SQL server on the server 2 and the rest on the 1.
Thank you
I am doing this and everything works fine except for one thing. You just add the sql servers ip address in the /etc/hosts file with a hostname e.g sql.mydomain.com and you tell ipspCP the database host in the setup.
There is one problem however,
at 1pm server time an error gets sent out to the server admin saying the databases that you clients have don't exist on the localhost server (which is true! Because they are on another server
) I have added it as a bug.
RE: MySql on another Server - RedHeberg - 05-11-2009 06:14 PM
With this configuration, all databases, even clients is on the second server? Thank you
RE: MySql on another Server - timaaarrreee - 05-11-2009 06:19 PM
No problem
hopefully the nightly check bug will be looked into to stop an email from each DB not existing on localhost
RE: MySql on another Server - RedSec - 05-12-2009 08:08 AM
Great ^^
Very thanks
RE: MySql on another Server - pgentoo - 05-12-2009 04:20 PM
I have an existing setup with one server, but am looking to break out mail/db into separate servers soon. I dont want to break existing client sites that are connecting to mysql through "localhost", via unix socket currently. How have you taken care of this? just force everyone to switch to using mysql.domain.com over TCP or something first, then make the actual migration later?
id be interested to hear what others have done...
RE: MySql on another Server - timaaarrreee - 05-13-2009 02:46 PM
i have thought about this before and there might a way.
You could change the sql server config address In the bind-address line to your other sql host but i am not sure if that would work
But you could port foward 3306 on localhost to sqlserver.domain.com's ip possebly too but i have no idea how or if that is possible.
Someone might know.
RE: MySql on another Server - kilburn - 05-13-2009 04:33 PM
I would go the proxy route: http://forge.mysql.com/wiki/MySQL_Proxy
RE: MySql on another Server - pgentoo - 05-20-2009 01:31 AM
killburn, this looks interesting. Thanks for the tip.
Do you use this today?