2 servers 1 FORUM?

[philliplewisuk]

I need some help, Im willing to pay for it to.

I own a VERY busy board.. 300-400 people on there at any time and the server cant handle it. I want to make it have 1000 at any time!

Now my idea is either to make it work with mods or to run it off 2 servers by sharing the user database.

Any help will be needed. I will pay anyone for it.

Thanks

Phil
10282728 (ICQ)

PS.. i dont want to have the php on one server and database on another. it will still slow the forum, i guess!

[Scott MacVicar]

You could use one server as a dedicated mysql.

Or to the current server make sure that mod_gzip, zlib, zend optimizer and that your my.cnf settings are correct, also turn on the gzip option in the control panel.

The gziped output will decrease bandwidth and the zend optimizer and my.cnf improvements will improve performance.

The end solution is having a front server and a dedicated mysql server to ensure speed.

Scott

[philliplewisuk]

Yeah a own server for the mysql would be cool but it wont work. the forum just dies. The vb cant handle more then 400 continue connections!

:(

[Scott MacVicar]

taking the load of mysql off the current server and putting it on another would improve the performace alot.

Whats the specs for the server and are both servers located in the same location?

Vb.com and this site use a dedicated mysql and a dedicated one for frontend and they can take alot of users. I also run a dedicated mysql and the server load on the main server is considerably less.

[philliplewisuk]

I got plenty of servers

512 ram, pent 3 1000

etc

i try to do the php on one server and the mysql on another but then i cant get it to connect..

etc.

[Scott MacVicar]

you'll need to set privledges on the mysql server to accept from the php servers IP.

Then on the php side user the other servers local network address as the host, you might need to ask your hosts what this address is.

My mysql one is 192.168.1.46