Hi Ryszard,
We're planning to launch a portal (over 1 milion page views/day) built
of dynamicaly generated pages. No we have to make a decision regarding
database engine. The alternatives are a cluster of Oracle DB's or C-JDBC
+ (possibly) PostgreSQL. We have quite a big experience with PostgreSQL
and Hibernate and would prefer Sequoia, but we've heard from somebody
who tested C-JDBC a year or two ago, that it wasn't stable under haeavy
load. Since we do not have a time for making our own tests using newest
stable branch - could you tell me if there are a known issues regarding
stability of sequoia? Or, another words, do you know heavy loaded
installations of sequoia running without problems?
Whatever solution you choose (Oracle, Sequoia or something else), I
would really recommend that you do some testing before deploying a site
that should serve more than a million pages/day. Even though these
systems are designed to work with significant workloads, I think that it
is illusory to envisage that an out-of-the-box install will give
satisfactory results without hiccups.
Even though these technologies try to be as transparent as possible,
there might still be some application specific issues that require some
tuning. This is why there is no single answer to your question. It is
not because someone has a good experience with his web site that it will
work as well for another one (unless you run exactly the same thing).
Now we have a couple of Sequoia deployments in production and we did not
hear about instability issues. Load can come from various factors:
number of connections, number of requests, complexity of requests,
amount of data transferred, read/write ratio, ... Scalability is
affected by all these parameters and there is no magic formula (yet) for
this.
Thanks for your interest in Sequoia,
Emmanuel
--
Emmanuel Cecchet
Chief Architect, Continuent
Blog: http://emanux.blogspot.com/
Open source: http://www.continuent.org
Corporate: http://www.continuent.com
Skype: emmanuel_cecchet
Cell: +33 687 342 685
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
