Hi Robert You mention using MySQL or PostgreSQL for recovery log. Are there any problem if we change the recovery log to use PostgreSQL at same host (that Sequoia connected to)?
Regards Francis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Hodges Sent: Wednesday, January 16, 2008 9:25 AM To: Sequoia general mailing list Subject: Re: [Sequoia] Recovery Log Hi Stuart, The backlog should disappear if you switch the log to write to a more capable database such as MySQL. MySQL by contrast can perform 2000 or more updates per second on a single thread without difficulty. You correctly noted, by the way, that there is a single connection. We use either MySQL or PostgreSQL in the commercial products based on Sequoia. The recovery log is written asynchronously, so it does not at least in theory have too much impact on SQL update rates. However, Hypersonic is pretty slow and uses a lot of memory when you have large quantities of data. Switching to an external database should speed things up at least a bit. Cheers, Robert On 1/15/08 4:58 PM, "Stuart James" <[EMAIL PROTECTED]> wrote: > Hi all, > > At what stage does the writes to the recovery log database become a > bottleneck? Currently we are bench marking our platform and hitting > about 200-300 writes per second. What we have noticed is after > finishing the frontend bench marking (using jmeter) against our > application, their appears to be a backlog of writes continuing to > happen to the recovery log for quite a period after the bench marking > is finished. In this period their appears to only be 1 connection > Established to the local recovery log database. > > We are currently using a local instance of postgresql for the recovery > log, the documentation pointis at HSqldb, is this the preferred database > for the recovery log? > > Regards > > > Stuart > _______________________________________________ > Sequoia mailing list > Sequoia@lists.forge.continuent.org > https://forge.continuent.org/mailman/listinfo/sequoia -- Robert Hodges, CTO, Continuent, Inc. Email: [EMAIL PROTECTED] Mobile: +1-510-501-3728 Skype: hodgesrm _______________________________________________ Sequoia mailing list Sequoia@lists.forge.continuent.org https://forge.continuent.org/mailman/listinfo/sequoia _______________________________________________ Sequoia mailing list Sequoia@lists.forge.continuent.org https://forge.continuent.org/mailman/listinfo/sequoia
