Hi Azeez, This implementation is only for cluster mode, So we can't completely remove writing to Hazelcast or the DB, and simply maintaining the slots in memory.
On Thu, Apr 30, 2015 at 5:42 PM, Afkham Azeez <[email protected]> wrote: > Is it possible to repeat the test after completely removing writing to > Hazelcast or the DB, and simply maintaining the slots in memory? This is > just for comparison purposes. > > On Thu, Apr 30, 2015 at 5:00 PM, Anuja Herath <[email protected]> wrote: > >> Hi, >> >> Is it single node MB? >> >> No, It is a cluster. I used two MB nodes for testing. Publisher in one >> node and Subscriber in another node. >> >> Database is in the same machine? >> >> For MS SQL, I used a separate machine with database server. >> For MySQL, I used database in the same machine. >> >> Any reason why we used MSSQL? >> >> MB performs faster in MS SQL, So initially, we wanted to test new >> implementation in that best case. >> We are planning to continue testing with other databases as well. >> >> Result looks there are not much difference between the two. So, what is >> the conclusion? >> >> MB is heavily depend on Hazelcast and use several hazelcast maps. And >> also we faced several problems related to that. >> This implementation was done as an experiment to release that heavy >> dependency on Hazelcast. >> We did not expect to increase performance with this implementation. But >> at the same time, we did not want to decrease performance with a new >> implementation. >> So with these preliminary test results, we concluded that there is no >> much different in performance between using RDBMS and Hazelcast for storing >> slot information. >> >> If the new implementation works with further testing, we will add an >> option to select either RDBMS or Hazelcast for storing slot information. >> >> Thanks, >> Anuja >> >> On Thu, Apr 30, 2015 at 4:29 PM, Selvaratnam Uthaiyashankar < >> [email protected]> wrote: >> >>> Is it single node MB? >>> Database is in the same machine? >>> Any reason why we used MSSQL? >>> Result looks there are not much difference between the two. So, what is >>> the conclusion? >>> >>> On Thu, Apr 30, 2015 at 12:12 PM, Anuja Herath <[email protected]> wrote: >>> >>>> Hi, >>>> >>>> I have implemented storing slot information using RDBMS. Previously MB >>>> used Hazelcast for storing these slot information. I have attached >>>> performance comparison related to above implementation. >>>> >>>> [1] Performance Results - >>>> https://docs.google.com/a/wso2.com/spreadsheets/d/1O9Mr-TiZaIyOBox4KhxQkcy_puG_i9JXe4xbPY3QPg4/edit?usp=sharing >>>> >>>> [2] Redmine Project - https://redmine.wso2.com/issues/3801 >>>> >>>> Thanks, >>>> Anuja >>>> >>>> -- >>>> Anuja Herath >>>> *Software Engineer* >>>> *WSO2, Inc.* >>>> Mobile : +94 (0)71 429 8861 >>>> >>>> _______________________________________________ >>>> Architecture mailing list >>>> [email protected] >>>> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture >>>> >>>> >>> >>> >>> -- >>> S.Uthaiyashankar >>> VP Engineering >>> WSO2 Inc. >>> http://wso2.com/ - "lean . enterprise . middleware" >>> >>> Phone: +94 714897591 >>> >>> _______________________________________________ >>> Architecture mailing list >>> [email protected] >>> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture >>> >>> >> >> >> -- >> Anuja Herath >> *Software Engineer* >> *WSO2, Inc.* >> Mobile : +94 (0)71 429 8861 >> >> _______________________________________________ >> Architecture mailing list >> [email protected] >> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture >> >> > > > -- > *Afkham Azeez* > Director of Architecture; WSO2, Inc.; http://wso2.com > Member; Apache Software Foundation; http://www.apache.org/ > * <http://www.apache.org/>* > *email: **[email protected]* <[email protected]> > * cell: +94 77 3320919 <%2B94%2077%203320919>blog: * > *http://blog.afkham.org* <http://blog.afkham.org> > *twitter: **http://twitter.com/afkham_azeez* > <http://twitter.com/afkham_azeez> > *linked-in: **http://lk.linkedin.com/in/afkhamazeez > <http://lk.linkedin.com/in/afkhamazeez>* > > *Lean . Enterprise . Middleware* > > _______________________________________________ > Architecture mailing list > [email protected] > https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture > > -- Anuja Herath *Software Engineer* *WSO2, Inc.* Mobile : +94 (0)71 429 8861
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
