Hi, Moving to Architecture@
Thanks On Thu, Jul 17, 2014 at 6:59 AM, Srinath Perera <[email protected]> wrote: > We need to d a initial design before the discussion. > > Please move this to arch@ > > > On Wed, Jul 16, 2014 at 10:25 PM, Shammi Jayasinghe <[email protected]> > wrote: > >> Hi Hasitha, >> >> I think , it would be great to have a meeting on this with all the >> relevant people and come up with an idea on the design of the database >> after explaining current data storage pattern in Cassandra. Then we ll be >> able to verify that with wider audience and proceed further. >> >> Could you please schedule a meeting on this. >> >> Thanks >> Shammi >> >> >> On Wed, Jul 16, 2014 at 9:52 PM, Hasitha Hiranya <[email protected]> >> wrote: >> >>> Hi All, >>> >>> We are ready to do the $Subject with more clean APIs etc now. >>> We would like to get ideas from DB experts at WSO2 on the $Subject. >>> >>> We need to discuss how to >>> >>> 1. Save metadata >>> 2. Save content chunks of messages >>> 3. Read message metadata as groups of messages (between msg_id x and y) >>> 4. How to move message metadata efficiently >>> 5. How to deal with limited number of columns in RDBMS as opposed to >>> Cassandra >>> 6. Cassandra automatically order messages by message ID? What about >>> RDBMS? >>> >>> etc. >>> >>> As the first step we are going to embed H2 as the in-memory database. >>> Thus we have following concerns. >>> >>> 1. Can we use H2 embedded in Carbon servers now. As it is file based can >>> the same be used for memory based or should it be different? >>> 2. As I understand the best way to create a connection with the DB is to >>> use masterDataSources.xml file and let the carbon framework to create the >>> connection for us. Can we get the DB connection into a dependency using a >>> look up by JNDI name? Is this possible for inmemory H2? >>> 3. Is H2 the best DB for in-mememory implementation? Why H2? >>> 4. We need to design this as there will be no drastic changes in >>> on-coming releases. Otherwise we will need complex Data migration scripts. >>> >>> Thanks >>> >>> -- >>> *Hasitha Abeykoon* >>> Senior Software Engineer; WSO2, Inc.; http://wso2.com >>> *cell:* *+94 719363063* >>> *blog: **abeykoon.blogspot.com* <http://abeykoon.blogspot.com> >>> >>> >> >> >> -- >> Best Regards, >> >> * Shammi Jayasinghe* >> Associate Tech Lead >> WSO2, Inc.; http://wso2.com, >> mobile: +94 71 4493085 >> >> > > > -- > ============================ > Director, Research, WSO2 Inc. > Visiting Faculty, University of Moratuwa > Member, Apache Software Foundation > Research Scientist, Lanka Software Foundation > Blog: http://srinathsview.blogspot.com twitter:@srinath_perera > Site: http://people.apache.org/~hemapani/ > Photos: http://www.flickr.com/photos/hemapani/ > Phone: 0772360902 > -- *Hasitha Abeykoon* Senior Software Engineer; WSO2, Inc.; http://wso2.com *cell:* *+94 719363063* *blog: **abeykoon.blogspot.com* <http://abeykoon.blogspot.com>
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
