MySql on another Server

[RedSec]

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

[timaaarrreee]

(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.

[RedHeberg]

With this configuration, all databases, even clients is on the second server? Thank you

[timaaarrreee]

No problem hopefully the nightly check bug will be looked into to stop an email from each DB not existing on localhost

[RedSec]

Great ^^

Very thanks

[pgentoo]

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...

[timaaarrreee]

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.

[kilburn]

I would go the proxy route: http://forge.mysql.com/wiki/MySQL_Proxy

[pgentoo]

killburn, this looks interesting. Thanks for the tip.

Do you use this today?