SQl on Web Server or on different machine (Full Version)

All Forums >> [Web Development] >> Server Issues



Message


Smitty -> SQl on Web Server or on different machine (12/18/2001 11:30:05)

Right now I have a web server and a SQL server, two different machines.

Would it be better to run the web and SQL togther and mirror it with the other machine or keep them seperate.

Thanks

Smitty

John A. Smith sorryiforgot.com hairschool.org
If you have to ask "Who's the man?" Your probaly not him.




Gil -> RE: SQl on Web Server or on different machine (12/18/2001 12:31:36)

IMHO

seperate seperate seperate


Gil Harvey





Mojo -> RE: SQl on Web Server or on different machine (12/18/2001 13:30:39)

Gil and I agree!





Smitty -> RE: SQl on Web Server or on different machine (12/18/2001 20:28:40)

Thanks, I'm in the middle of re-installing all of the software to both and setting them up. Should I get a nother machine to act as back up for both, and if so is there some software that makes this easier?

Thanks

Smitty

John A. Smith sorryiforgot.com hairschool.org
If you have to ask "Who's the man?" Your probaly not him.




caywind -> RE: SQl on Web Server or on different machine (12/20/2001 1:03:46)

what are you running a quad processor itanium 7? last time I ran SQL server that was it for that machine. (it was a 700 mhz 256 m computer too!)

All this to change a number into a name...




Smitty -> RE: SQl on Web Server or on different machine (12/20/2001 10:59:58)

It's a AMD 850MHz with 128Ram and a 30GIG harddrive, I plan to up the memory to the max if that helps. What the Hell, may as well do it anyway, memory so cheap.

What kind on machine would be Idealy suited for this SQL stuff?

Thanks

Smitty

John A. Smith sorryiforgot.com hairschool.org
If you have to ask "Who's the man?" Your probaly not him.




Gil -> RE: SQl on Web Server or on different machine (12/20/2001 15:13:04)

quote:

What kind on machine would be Idealy suited for this SQL stuff?



We're running SQL on a Dell 6400 -four Xeon 800MHZ and 4GB RAM, RAID3 w/ 9GB SCSI drives.

It's "almost" as quick as the SUN box running Oracle

Gil Harvey





caywind -> RE: SQl on Web Server or on different machine (12/21/2001 0:14:50)

Thats what you need smitty, just what gil has

All this to change a number into a name...




Gil -> RE: SQl on Web Server or on different machine (12/21/2001 6:49:49)

quote:

Thats what you need smitty, just what gil has



Not "Gil's" That's at the day job...

My servers are all Linux/MySQL

Gil Harvey





Smitty -> RE: SQl on Web Server or on different machine (12/21/2001 9:07:34)

If thats the Cadillac, I may be stuck with the Yugo.

Gil,

Should I ask what you hardware cost, I'm already locked into the windows stuff and don't want to throw away a whole bunch of money. I did get Redhat Linux, but after playing with it for a couple of months I got rid of it. Too different and couldn't figure it out, nobody at work uses it.

Thanks

Smitty

John A. Smith sorryiforgot.com hairschool.org
If you have to ask "Who's the man?" Your probaly not him.




Gil -> RE: SQl on Web Server or on different machine (12/21/2001 10:08:05)

quote:


Should I ask what you hardware cost,




The "work" box was around $25K - I think.

The SUN/Oracle was a LOT more!

My Linux boxes (PIII 950, 512RAM, 18GB SCSI Drives) are about 1/10th that


It all depends on the use - for "normal" DB usage, I'd guess a P4 1.5 w/ 1GB RAM and a SCSI HD (assuming W2K advanced server) would be fine.


Gil Harvey





Smitty -> RE: SQl on Web Server or on different machine (12/21/2001 22:02:49)

Gil,

So my 850MHz AMD with 128 and a 30gig IDE for only a address book type service needs to be stepped up?

Was that $25,000 for the box, my car didn't cost that much, ouchh. That will have to wait until I make some money off the site.

Thanks

Smitty

John A. Smith sorryiforgot.com hairschool.org
If you have to ask "Who's the man?" Your probaly not him.




Gil -> RE: SQl on Web Server or on different machine (12/22/2001 10:00:13)

quote:


So my 850MHz AMD with 128 and a 30gig IDE for only a address book type service needs to be stepped up?


Depends on traffic, size of DB(s), etc.
My concern with the setup you quote qould be RAM (I'd go at least 512 - heck it's cheap now) and the IDE HD.
quote:

Was that $25,000 for the box, my car didn't cost that much, ouchh. That will have to wait until I make some money off the site.



Yep, that's the box, software is extra

Gil Harvey





Smitty -> RE: SQl on Web Server or on different machine (12/26/2001 18:27:27)

Well after all of your feedback and three weeks of trying to get everything going again, with little to no progres.

I have made a command decision. Give the headache to someone with asprin.

I will be hosted with readyhosting, and should be able to sleep at night again.

I'll try to keep current on things that I can manage and have an interest in.

I will keep the server up with SQL as a learning/web testing area.

Thank you all for your help, it wasn't in vain.

Smitty

John A. Smith sorryiforgot.com hairschool.org
If you have to ask "Who's the man?" Your probaly not him.

Edited by - Smitty on 12/28/2001 01:09:12




bpestilence -> RE: SQl on Web Server or on different machine (12/29/2001 23:14:24)

Don't try to max out your memory while running windows. Windows gets an awful "out of memory" problem (go figure) if you install more that 512 megs. (Unless you reconfigure the batch size, which only works some times)

Why did you give up on Red Hat Linux? I use it, and love it (I also have windows on the other HD for running FP, Autodesk, the LAN, etc)

Semper Fidelis




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.140625