[Kaelon]

Originally Posted by toprak

Him dedicated server own by me.. There is no host..I don't want to pay for software. I just don't know linux. There should be a way to backup we just don't know..

We had a single dedicated server for years, with a database that is over 4 gigs in size (2.5 gig post table), and there was never any problem. If you're having problems, I suggest that it isa processor/memory issue which should be rectified. Ensure that your dedicated server has at least 2 Gigs of RAM, preferrably 4 Gigs; look into making sure that your processor is multi-core or dual-unit. Such a configuration can comfortably hold up to 1500 concurrent users, provided your MySQL is configured properly, without any serious risk of error.

You should also ensure that your PHP, MySQL, and Apache versions are up to date. Unfortunately, if you're not an experienced Linux administrator, these can be daunting tasks. Get a Linux administrator - even if it's just on a per-instance, or per-contract basis - to upgrade your OS, Apache, PHP, and MySQL. These can all serve as bottle-necks and error-producers.

Eventually, there will come a time when no matter how much you optimize your system, you will need to expand to have multiple servers to handle a single forum. Usually, a 2-forum system supports up to 3,000 concurrent connections fairly comfortably, but it all depends on the server architecture and configuration. Many admins prefer having 3-4 servers on any forum that has more than 2,000 concurrent connections at peak, and understandably, because at that point, the principal load is no longer on MySQL, but on httpd.