« Return to Thread: stability for multi-user environment ..

Re: stability for multi-user environment ..

by Fred Toussi-2 :: Rate this Message:

Some parts of this message have been removed. Learn more about Nabble's security policy.

In general, the latest HSQLDB is quite stable as a server. I know of several companies that use it for "small-enterprise" setups.

Although the server can handle it, we don't recommend using 1000 simultaneously connected clients. Usually a connection pool is used with about 20 live connections.

MVCC is a good option for servers. It is not the default transaction model because HSQLDB is more often used with very few connections.

A non-blocking hot backup feature was added this year. We have found and fixed some issues with this feature, which should be fully stable by the next release.

I recommend joining SupportWare or getting professional support for all production use.

Fred

On Fri, May 4, 2012, at 14:34, Amit.Shah@... wrote:

We have a requirement where we have to ship an offline version of our product, as well as keep an online version of it for our customers. It looks like hsqldb will hold up well for offline customers because that will be a single user environment. The question is, is it stable enough to hold up against our online users as well ? We won’t be having more than 1000 users online. Most of them will be doing reads against the database. There would be some writes. I would have to change the transaction model to MVCC. Any reason why hsqldb doesn’t default to it ?

Would it be better to use hsqldb for offline folks, but use something like mysql for the online folks who would use it over the web ? Wasn’t able to find reviews about people who have used hsqldb in a multiuser “small-enterprise” type setups.

Also, I have noticed that hsqldb locks everything when it is data is being backed up. Is there a way to avoid that and atleast let reads happen even when the database is being backed up ?

Thanks,

Amit

------------------------------------------------------------------------------

Live Security Virtual Conference

Exclusive live event will cover all the ways today's security and

threat landscape has changed and how IT managers can respond. Discussions

will include endpoint security, mobile security and the latest in malware

threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/

_______________________________________________

Hsqldb-user mailing list

Hsqldb-user@...

https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

« Return to Thread: stability for multi-user environment ..