'Off-Site' MySQL Data Questions

mrhinman

My client currently has a MySQL database on their web site; They would like to have the actual DB reside on a local server (on the office network), but serve out the data to the outside world via the web interface (residing on another server).

Make sense?

In other words, script residing on web server A designed to access MySQL data on web server B (which is in-house).

I've got some trials running, but keep getting errors like:
Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query .........

I've checked log-in name, host name, etc. Still getting issues. Perhaps I'm filling in the host name properly? DB on "server B" is accessible locally with same script.

The idea is to have access to DB even when internet goes down.

Ideas? Comments?

kidgeek_dfw

Its an ugly scenario no matter how you look at it...

If their not making changes to the data, I'd consider a mirror copy at the office.
If they are making changes, then you could run a mirror copy to the web server.
If you are making changes at the office and on the web, then maybe have 3 db servers.
One being the master read...

If you don't like these scenarios, then here's another place to check:
http://www.google.com/search?hl=en&q=mysql+connect+to+local+network

If your not worried about speed or downtime then you could run the server locally...

But honestly I think your best deal is to contact the pros at totalserversolutions.com
they manage my servers for 75.00 each per month...

mrhinman

Thanks. Yeah, the uptime here for Verizon DSL stinks. And, there are no other high speed providers here. Granted, the DB only needs to accessed by no more than 10 internal users, and some items are viewable to the public, but past usage indicates no more than 20 or 30 users at a time, and small amounts of data at that.

I was hoping really that the data could be on a server on the local network so when the web is down (i.e., Verizon), they could still access and use their DB. Yes, the "outside world" could not, but at least internal operations could continue under that arrangement until Verizon came back up.