| Author |
 Topic  |
|
|
RhinoOffRoad
New Member
USA
71 Posts |
 Posted - 27 July 2008 : 05:20:03
|
i would like to keep a very busy forum on a leased remote server (a lot of bandwidth, only 384 megs of RAM) and keep the DB on my local server (only 1.5 mbps upload bandwidth, but a duo-core processor with 4 gigs of ram). my thinking is that the leased remote server could serve all scripting and binaries and my local server could process the DB (the powerful hardware seems to over-come the limitations of MS Access on a very busy site) to keep searches from stopping the site until the search is over. i tried putting the URL to the DB on the other server but im getting an error. is there a way to accommplish this?
im using version 3.4.04 (dont want to have to rescript all my mods if i update to the current version).
thanks,< |
Nathan In Montana
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 27 July 2008 : 05:27:03
|
| you can't do it using access< |
 |
|
|
RhinoOffRoad
New Member
USA
71 Posts |
Posted - 27 July 2008 : 06:08:12
|
| thank you sir, for the reply. i wonder though, would it be possible to map a network drive on the local server from the remote server and then set the path to the DB on a network drive?< |
Nathan In Montana
|
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 27 July 2008 : 06:12:36
|
| Yes, it's possible. I set up a number of companies that way when I lived in Ohio. Everything from POS to multi-user estimating, etc.< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
RhinoOffRoad
New Member
USA
71 Posts |
Posted - 27 July 2008 : 06:56:15
|
| i would love to use MySQL but cannot find adequate information to teach me how to use it on a windows based server.< |
Nathan In Montana
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 27 July 2008 : 07:33:41
|
| when mapping a network drive you are still using local server resources to connect to the database, so how will it help to overcome any limitations ?< |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 27 July 2008 : 21:34:18
|
quote:
i wonder though, would it be possible to map a network drive on the local server from the remote server
Only if you have some sleepy server admin that allows smb ports over the internet. It's extremely unlikely to find any hosted server that will allow windows networking over the internet, doing so isn't all that secure.
In any case, if it were me I wouldn't consider using a remote db for a busy site, it will probably be pretty slow.
If you want to learn mysql on windows, just download a copy and install it on your own windows machine and take it for a "test drive".
< |
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
| |
Topic |
|
Topic Locked
