Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mysql on seperate server 1

Status
Not open for further replies.

dbeez

Technical User
Aug 15, 2005
71
KR
Hi,

I want to run a php/mysql application. I want to give it as much BW and processor speed as possible, but unfortunately I don't have access to server grade computers.

I am wondering whether I would see a large performance gain if I split the system into one php/net box and one mysql database server.

Will this make my system appreciably faster ?
Do you think it's worth it ?
How can I connect the linux servers together ... specifically what connection string would I use mysql> create database mydatabase ?
What are the major security issues involved here ?

Thanks,
 
I am wondering whether I would see a large performance gain if I split the system into one php/net box and one mysql database server. {/i]

DEFINITELY

-DNG
 
thanks dng,

I am curious though, as to whether this is because mysql hammers the cpu, or just hogs the hard drive ... or both ?

Is there any mysql.conf settings I should be looking to tweak here in particular. Kinda like pipelining tweak for apache, I want mysql to hammer away at my RAID 1 config as fast as possible. What can I do to streamline it ???

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top