The company I'm working for has several projects that are mainly forums based on vBulletin. I believe that JForum's performance might be much better than that of vBulletin, and I want try to convince the people at my company to shift to JForum. I just wanted to know if it's possible if you can give me some details on the server(s) configuration and the average number of concurrent users that the server(s) can handle.
Alaa,
First of all, you know that JForum is essentially unsupported, right? Their forums have been dead for all of 2010.
We run on Tomcat and Postgresql. I have no idea what the hardware specs are but someone else probably does. As far as how many concurrent users it can handle, we don't know that either as we've never done a formal stress test. We know it can handle the volume we actually get.
Also, keep in mind that we aren't running pure JForum. We have forked our version of JForum, made a lot of changes and support it ourselves. We know of at least two scalability problems in the original JForum - one of the queries does a full table scan causing problems when you have a lot of data and there is a memory leak if you turn on thread caching.
We believe we are the biggest install of JForum in the world, so we know it can handle our volume. We also know it isn't written to handle horizontal/vertical clones - too much happens in memory.
It is really nice to know that the JR uses PostgreSQL database, I'm huge fan of this system (I never liked MySQL and don't know really why to use MySQL when we got PostgreSQL).
Amr hassanin wrote:I understand but the problem is availability is very important in our case...
Amr,
Do you have to have them both up at the same time? Replicating the database and having another server on warm standby seems like an option that work better with the existing JForum codebase.
Amr hassanin
Greenhorn
Joined: Jan 31, 2011
Posts: 3
posted
0
Thank you Jeanne very much... I understand now that there is another solution for availability other than load balancing(ofcourse if load balancing is not needed).
Raghavan Muthu wrote:Just out of curiosity, What made you choose Postgresql over all the other databases?
It was already on the production server and being used for another JavaRanch app. Unless there is a good reason not to, using less technologies helps with maintenance.
Saurabh Pillai
Ranch Hand
Joined: Sep 12, 2008
Posts: 297
posted
0
John Todd wrote: (I never liked MySQL and don't know really why to use MySQL when we got PostgreSQL).
This sounds pretty harsh. I have not used Postgre but I have very good experience with MySQL.
Any specific points/features that are available in Postgre bur not in MySQL?
Raghavan Muthu wrote:Just out of curiosity, What made you choose Postgresql over all the other databases?
It was already on the production server and being used for another JavaRanch app. Unless there is a good reason not to, using less technologies helps with maintenance.
Thats true. Thank you Jeanne. I know by the time Ranch would have started using the apps, MySQL would not have become that matured and stable. Perhaps, PostgreSQL was more stabilized. Am I Right? Or there any other significant features made you choose PostgreSql?