Closed Thread Icon

Topic awaiting preservation: Beginer in web based system Pages that link to <a href="https://ozoneasylum.com/backlink?for=12871" title="Pages that link to Topic awaiting preservation: Beginer in web based system" rel="nofollow" >Topic awaiting preservation: Beginer in web based system\

 
Author Thread
rangga
Obsessive-Compulsive (I) Inmate

From: Malaysia
Insane since: Aug 2003

posted posted 08-28-2003 02:35

Anybody home...Plzzz help me.....

I got a PHP web page which is running on Linux Web Server...The Database also in that server...
My Boss ask me to put the database in a NT server but the web server is still the same...
Let say...If i want to do that...is it possible...???If yes...How to make the connection between my web and database??

Thanks

Live Your Life

Emperor
Maniac (V) Mad Scientist with Finglongers

From: Cell 53, East Wing
Insane since: Jul 2001

posted posted 08-28-2003 04:07

rangga: Welcome. I'll move this over to the server-side scripting forum where it is more at home

To answer your question(s):

1. Yes you can run MySQL on a Windows box (see the FAQ on installing AMP).

2. Yes you can connect to a remote version of MySQL (there was a service a while back which offered to host a MySQL DB for free).

I'm not sure its overly wise working like this but if you had to do it then it is doable.

___________________
Emps

FAQs: Emperor

brucew
Paranoid (IV) Inmate

From: North Coast of America
Insane since: Dec 2001

posted posted 08-28-2003 05:26

Emps: It's fairly common among those companies that don't use an outside commercial hosting service. The advantage is that it isolates the database from the web server thereby increasing security since the database box sits behind the firewall.

Further it increases safety since a webserver crash doesn't affect the database. Err, wait a minute. Rangga is moving the database to a Windows box, so that would should be rephrased: When Windows crashes it won't take down the web server.

Finally it can improve performance by distributing the load. This is especially helpful when running reports (like periodic sales and accounting reports) from the database since doing so will not slow down the web server.

Rangga: Making the connection between the two is easy. The database server location is somewhere in your web application's configuration. (Every application is different, sorry I can't be more specific.) Right now it probably says "localhost" or 127.0.0.1. Change that to the IP address of the database server, and change any logins and passwords accordingly.

edit: Whoopsie. Typos.



[This message has been edited by brucew (edited 08-28-2003).]

Tyberius Prime
Paranoid (IV) Mad Scientist with Finglongers

From: Germany
Insane since: Sep 2001

posted posted 08-28-2003 09:16

well, actually, if she had a local mysql so far, it should say something like ':/var/mysql/mysld.sock' - unix sockets being much faster than tcp/ip ones even to localhost...

brucew
Paranoid (IV) Inmate

From: North Coast of America
Insane since: Dec 2001

posted posted 08-29-2003 19:22

TP: Tell me more about UNIX sockets. I'm not familiar with it at all.

« BackwardsOnwards »

Show Forum Drop Down Menu