Quote:
Originally Posted by Dan
Hi Ian,
WebhostingUK provide load-balancing support if you have one or two dedicated machines meaning that the load can be distributed between two separate machines.
If you ever decide to purchase two or more dedicated machines, definitely take advantage of this.  |
Hi,
Thanks for your suggestion.
I won't post a link to my site here as it might be deemed as advertising, but there is a link in my profile and it might help explain some of my comments.
I am about to go live tomorrow and I have no customers so this is all dreaming.
In practical terms my site is not really a web site, it is web front end on a business application, most of it is text with minimal graphics and minimal operators just staring at a screen for long time, they will; sign in, do something and sign out and I fully expect a single server to be able to serve up the web pages with resource to spare.
If things go well and without getting boring and going into too much detail I am expecting one key table to grow at about 1Million rows per month and other to grow at about 5Million rows per month, this might give you and idea. If things went very well this would increase to 5 Million and 25 Million rows per month. This will occupy the database server pretty much full time. The current plan is to ship the transaction log from the live database server to the backup server, so it will have some spare capacity but it may not be worth the effort of trying to use it share web page serving, especially as the dedidcated servers here are so cheap.
Thanks again for the suggestion.
Bye
ian