azzbacwordz - 5:13 pm on Feb 22, 2005 (gmt 0)

Thanks for the tip Easy_Coder.

I have these options for separating the two, please tell me what is the best, in respect to performance, security, and overall stability.

Let me tell you about my old server, it is a Intel PIII, with Windows 2003, 256MB of RAM, 100GB HD, not the best server but it does what it needs to do at this time.

My options:

First option
1. Use my old server as the Web Server which connects to the MySQL (new server) server on a local IP

(that is how I have it setup now on my old servers...I have another server that specs is identical to the old server...but it is Windows 2000 server on the MySQL machine)

Second option:
2. Use my new server as the Web Server and MySQL server, but MySQL installed on a separate hard-drive and using a completely different NIC (local IP) and the Web server installed on another hard-drive using a different NIC (external IP)

(number 2 is the option I was planning to go with, but I'm also setting up a RAID and know that a second HD might not be possible, but do you know if MySQL can be setup to only receive queries from a specified IP...even if there is another IP (NIC) availiable?)

If you think option 2 is not a good idea, please let me know...and why not? I appreciate the feedback. Thanks.