2 servers, apache on one, mysql on the other

rkolbe

Ok so the title may lead some astray..but never fear, as I will explain in some detail.

I have 2 servers. One has MySQL and PHP5, and the other has Apache and PHP5 running. The MySQL server is just MySQL and PHP, no Apache and I dont want apache on it.

I have a script i wrote up that reads a spcific file in many different folders. These files contain specific info like "Progress" and "Workstation name". I can parse this information no problem and throw it into MySQL just fine on the MySQL server...that is of course if Apache was running on the server (this is what I originally had...bleh).

So now that I have a seperate Apache server and the MySQL server no longer has apache on it...I am at a standstill. I have to find a way to run that PHP script on the MySQL server! How can I set up my front end on the apache server to trigger that PHP script on the MySQL server?

I have thought about using the exec function to execute the php script through an SSH connection (of course I have though of a caching function but that is not what I need right now).

Is there a better easier way?

bogu

Just run the php script from the apache server and connect to mysql server (mysql_pconnect)

rkolbe

I cant just run the script because it reads through specific directories on the MySQL server. It pulls specific information from these files on the server in folders.

rkolbe

Ok I have come up with a system here now... 😉

We have one server now, that will be strictly PHP and those "progress" files in the different folders....

The other "frontend" server will have a LAMP setup.

On the "backend" server there will be a cronjob that runs to execute the script progress.php which will then push the much needed info to the MySQL server...this will happen about ever 2 - 5 mins...whatever we decide on.

edwardp

how bout virtual directory settings in the apache http.conf??