Scalability

[dwiegand]

Anyone out there have some general scaling guidlines? eg: Application CPU's, dB CPU's and Number of supported users on the Open Source?

[kpit]

Anyone out there have some general scaling guidlines? eg: Application CPU's, dB CPU's and Number of supported users on the Open Source?

There are several ways to scale the server UP and OUT. Scaleing up by buying larger capacity servers (IE. More RAM, CPUS) has definate limitations. SMP provides a diminishing return as more cpus are added. This is largly due to bus contention and processor syncronization Some of this can be worked around by some higher end sytems but you pay more for it in $$. Over all you do loose some preformance I would not go for much more than 4 cpus on X86 systems, If you are going with hardware from Sun, IBM or HP you could take as high as 16 processors or higher. Scaling Out is a better solution by having multiple servers that have special functions (IE. Database, Web server) By specializing the database server seprate from the webserver you can make the database preform better at cacheing querys and finding information requested, while at the same time the Web server is preforming business logic and delivering content. A single dedicated Database server can serve many web servers that are more compute intensive at the same time providing redundancy of the webservers. The database server could also be replicating data real time between database servers for redundancy and load balancing.

This is a complex subject each method has its advantages and disadvantages. Over all SugarCRM can scale well it is just a matter of how you would configure the systems. I am avalable to consult on large projects and can help with implementations issues you can contact me via Private Message.

Cheers,

Max