Hi Guys, Thanks for the feedback.
In terms of my interest, I have no relationship with NuoDB at all. The company I work for Avoka Technologies provide a forms hosting platform for large government and corporates. We use/love Cayenne and support Oracle, SQL Server, MySQL databases. Generally Oracle and SQL Server are used for on-premise installations and we use MySQL for a cloud offering (Amazon RDS). For us we have no performance problems with relational databases. By using Cayenne caching intelligently we can handle very high loads. However when it comes to providing a High Availability solution across multiple data centers things become much harder. The database vendors have different approaches to this problem, but generally use a primary active database in data center 1 and a standby database in data center 2. Microsoft provides a new capability to support this in SQL Server 2012 AlwaysOn, for MySQL there is Continuent, for Oracle there is RAC with Data Guard. All these HA approaches are inherently complex to setup and administer. NuoDB offers fresh approach at this problem. The video below gives a good overview: http://vimeo.com/33785505 I looked at early beta's of NuoDB about 8 months ago, and it was too unstable at this point. Whether NuoDB becomes a viable player in the market is open to question. Building SQL databases is hard, but they do have people like Jim Starkey on board and some serious Venture Captial backing I don't think adding NuoDB support to Cayenne would be trivial, as they have their own DDL and SQL dialect as does every database vendor. I wished they had a MySQL emulation mode. Again I have no direct commercial interest in this, and would look at contributing/developing this code in the Cayenne project if people were interested. regards Malcolm Edgar On Wed, Aug 15, 2012 at 9:15 AM, Aristedes Maniatis <[email protected]>wrote: > On 14/08/12 11:32pm, Aristedes Maniatis wrote: > >> On 14/08/12 10:00pm, Malcolm Edgar wrote: >> >>> Hi All, >>> >>> I am interested in developing a Cayenne Adaptor for the NuoDB database >>> https://www.nuodb.com/ >>> >>> Its a very interesting database technology for developing scale out / >>> high >>> availability solutions. The stuff that relational databases struggle >>> with. >>> >>> Presumably to get started I would need to create a NuoDBAdaptor >>> extending * >>> org.apache.cayenne.dba.**JdbcAdapter*. Is this the best place to >>> start, does >>> anyone have any recommendations, or would like to be involved ? >>> >>> regards Malcolm Edgar >>> >> >> >> Interesting. Their website is full of marketing speak, but very light on >> what makes this database so "revolutionary". What is that attracts you to >> it over the choice of existing open source databases? >> >> If it supports the basic SQL specification, there is probably very little >> code to implement in the Cayenne dba package. >> >> Ari >> > > Just to be clear Malcolm, I'm not being critical of your effort at all. > The more databases Cayenne supports the better. But I've never come across > Nuo before and I'm curious about what it offers. Certainly mysql's > master/master clustering capabilities leave a bit to be desired, but as a > basic SQL/storage engine I wonder how easy it would be for anyone to > surpass postgresql/mysql after all the years of bug fixing and tuning. > > I've not been able to Google any benchmarks or other third party reviews. > The best I found was this: > > http://sqlandsiva.blogspot.**com.au/2011/11/nuodb-acid-** > compliant-scalable-cloud_02.**html<http://sqlandsiva.blogspot.com.au/2011/11/nuodb-acid-compliant-scalable-cloud_02.html> > > which suggests that about 90% of the SQL standard is implemented. I guess > the real question is which 90%? > > > > > Ari > > > -- > --------------------------> > Aristedes Maniatis > GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A >
