THey will be linked by an 10mb port switch one will server the apache and other will be exclusively DTABASE server.
I expect like 1000 users online.
Please advice me a server for apache and Mysql
What must be their configuration.
Any advice will be highly appriciated
If you feel insecure about running a big server
- find a host which has not only dedicated servers, but also dedicated staff. You pay a bit more, but if they're any good, they're worth it. To test, just call them in the middle of the night, see if they answer the phone.
- be prepared to run into trouble. There is no such thing is problem free server owning
- forums like www.webhostingtalk.com (http://www.webhostingtalk.com/), http://forum.ev1servers.net (http://forum.ev1servers.net/) and http://forums.cpanel.net (http://forums.cpanel.net/) are good ways of finding info and people who had the same problems as you. I learned a lot just browsing these.
Thnx
Now will cross my fingers and wait and see
I am constantly checking all those 3 forums an regular basisi
Dave's right - if you have a busy forum, 10Mb network is too slow - go 100Mb.
As to your server requirements, there's a few things to note:
1. vB user online concurrently is based on default 15 min or 900 second cookie time out and is different from mysql concurrent connections
2. vB currently only can use mysql as a backend but later there will be ports to sybase and postgresql way after vB 3.x has been publicly released
3. MySQL regardless of forum software, provided it has the right hardware and mysql, php and apache configuration is good for theoretically 1000 - 1500 mysql concurrent connections (latter figure with the mysql rpm binaries) based on single dual cpu server setup (excluding dual, quad p4 xeons which could handle more)
4. this means you can have 1000 vB users online displayed but they actually can use 200 - 700 concurrent mysql max connections since vB shows those 1000 vB users over 15 mins / 900s and not the exact same second, you can have any combination
i.e.
300 members + 700 guests = 1000 vb users online past 15 min, with only 300 - 500 mysql concurrent connections in use
or
500 members + 500 guests = 1000 vb users online past 15min, with 500 - 800 mysql concurrent connections in use
both examples show 1,000 vb users online past 15mins but the latter example could place more load on the server due to more mysql concurrent connection usage
5. hardware isn't the only aspect which determines vB performance, you have to have apache, php and mysql configured optimally - left unoptimised especially mysql's configuration, then even the most powerful hardware will not perform well
6. if you set your vB timeout cookie higher than default 15 mins, you will show more vB users online - so set timeout cookie in vB admin panel to 30 mins, then the vB user online display will show users on in the past 30 mins thereby inflating the vB user online display - generally the higher the cookie timeout, the higher the vB users online to mysql concurrent connections ratio
with the above points for 1 vB installed and no other site sharing the server:
A single dual cpu server running Red Hat 9 or higher, latest 2.6.x smp stable kernel, PHP 4.3.9 compiled with GD2, and zlib support, CURL and compiled to use MySQL client libraries instead of PHP's own included mysql libraries, MySQL 4.0.22 installed from rpm binary, latest Apache 2.0.x server. Also installing Turck Mmcache http://www.vbulletin.com/forum/showthread.php?t=75878 (needs to be uninstalled and reinstalled for each PHP upgrade in future)
with properly fine tuned mysql, apache and php settings
Dual P4 2.8ghz Xeon 533FSB 512K cache
2GB REG ECC PC3200 DDRAM
4 x 36GB 15,000 rpm SCSI raid 1+0
with 2 x Gigabit Network cards
Would probably handle anyware between 350 - 450 mysql concurrent connections - that would show as X amount of vB users depending on the set vB cookie timeout on the vB forum. So in theory, the lower or closer to default vB cookie timeout of 900 seconds, the closer the vB users online displayed would be to the real mysql concurrent connections in use.
however if you intend to have consistently 1,000+ vB users online over default 900 second cookie timeout, then you will definitely need a 2+ dual cpu server setup
1 server as a dedicated web server
1 server as a dedicated mysql database server
i.e. 2 of these
Dual P4 3.06ghz Xeon 533FSB 512k cache
3GB REG ECC PC2100 DDRAM
4 x 36GB 15,000 rpm SCSI raid 1+0
with 2 x Gigabit Network cards
Note this is all just theory and based on my observations and with working with various large vB clients which have >1,000 vB users online - generally these larger vBs have a 2:1 or 3:1 or higher vB user to mysql concurrent connection ratio - so really 1,000 vB users only use around 200 - 600 mysql concureent connections
I've seen a few vB's with close to 800 - 990 mysql concurrent connections displaying 1,200 - 1,400 vB users online as well (these vBs are all on 2 or dual cpu server setups dedicated web and database servers)
Last but not least is if you need even more scalability for MySQL server, you could implement MySQL clustering technologies from MySQL.com themselves http://www.mysql.com/products/cluster/ or 3rd party solutions like http://www.emicnetworks.com/products/mysql.html which cost alot more money per cpu license. Both I have not personally used but from reading what they do, it looks like they will provide additional performance beyond the basic MySQL server/hardware setups.
hope that helps :)
If you can post your projected stats, users online, threads, posts, users of the forum, or at least what you are expecting we can better assit you
Dual xeon 2.8ghz
36gb scsi disk
4 gb DDram
plesk
centos
what do you guys say?
If you feel insecure about running a big server
- find a host which has not only dedicated servers, but also dedicated staff. You pay a bit more, but if they're any good, they're worth it. To test, just call them in the middle of the night, see if they answer the phone.
- be prepared to run into trouble. There is no such thing is problem free server owning
- forums like www.webhostingtalk.com, http://forum.ev1servers.net and http://forums.cpanel.net are good ways of finding info and people who had the same problems as you. I learned a lot just browsing these.
George(Eva2000) is our local guru and he will be best able to help you with your problems.
Continueing to create multiple threads will not get your problem fixed any faster
No need
I am repeating my question
Cause i am gonna ask for optimization Later
And i dont wanna end up being in situation like:
Why you buy a server like p4 1 gb ram
yu should get dual xeon 5gb ram
or
Well dual xeon is to much with 4gb ram.
a p4 will handle the load quite nice
what a pitty you spent 400 buscks
a $200 dolar server will handle it.
i need advice.
members: 7000
But deleting the members with 0 messages every week.
threads:30k can double after server purc.
posts: when i do a serach index i saw it goes upto 400k but at the stats it shows 280k expecting more than 1m in month
i am expecting like 1000 to 2000 users online with a solid server.
cause after 300 the server so far cannot handle it.
and
dave thanx for the advice:)
Reply With QuoteUse 100MB cards not 10
George(Eva2000) is our local guru and he will be best able to help you with your problems.
Continueing to create multiple threads will not get your problem fixed any faster
#If you have any other info about this subject , Please add it free.# |
