Communication between servers

shree24985 · 10-24-2010, 11:27 AM

Hello guys,
I have two webservers say web1 and web2, web2 server being my datacenter also.
The situation is that I have a web page form on web1 and on submitting the form the form data should be transferred to web2 and saved there.
The stored form data in web2 can also be fetched by web1 server when it needs it.

currently I am using lynx within popen as a IPC to send the data to the web2.

Please suggest me if there exist a better and efficient way to accomplish this.

Thanks.

Guillermo Reisch · 10-24-2010, 01:52 PM

why don't use a SQL Database server ? like "postgres , mysql , etc" to store the data in other server or install the SQL Database in one of the 2 servers you have
Using a Database Server you have sincronized, safe data-changes, concurrency check and other good stuff

shree24985 · 10-24-2010, 02:47 PM

Thanks Reisch,
May be I was not clear in what i was asking.

The data is indeed going to be saved in a database in a server. But i dont want to allow any other machine to connect to the database except itself.

Any other suggestions

landysaccount · 10-24-2010, 09:47 PM

Quote:

Originally Posted by shree24985

Thanks Reisch,
May be I was not clear in what i was asking.

The data is indeed going to be saved in a database in a server. But i dont want to allow any other machine to connect to the database except itself.

Any other suggestions

Then if you don't want any other user to connect to the database just create the database user to only connect from localhost:

CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';

and make sure that the

bind-address = 127.0.0.1

in /etc/mysql/my.cnf

Hope that helps.

joec@home · 10-24-2010, 10:50 PM

Quote:

Originally Posted by shree24985

Thanks Reisch,
May be I was not clear in what i was asking.

The data is indeed going to be saved in a database in a server. But i dont want to allow any other machine to connect to the database except itself.

Any other suggestions

Setup another host on the one server that is on an IP address not behind the load balance. Then have the HTML POST function sends to that URL that which is the one server outside the load balanced cluster. Then from what ever page that is, then have a link that returns the user back to the cluster.