FW: unsubscribe
Thanks and regards, Bhupendra Baraiya Continuum Managed Services, LLC. p: 902-933-0019 e: bhupendra.bara...@continuum.net<mailto:bhupendra.bara...@continuum.net> w: continuum.net [http://cdn2.hubspot.net/hub/281750/file-393087232-png/img/logos/email-continuum-logo-151x26.png]<http://www.continuum.net/>
RE: Cassandra Single Node Setup Questions
We have around 20 Million rows and around 200 concurrent users The reason we want single Node is we have only single DC , I believe if there is only one DC there is no question of keeping multiple nodes The main reason we want to migrate to Cassandra is we have a denormalized data structure in Ms Sql server Database and we want to move to Open source database , currently we are in process of POC of Cassandra only I want to keep it less complicated and simple hence I want to go with Single Node The main issue that we have is the Transaction support Thanks and regards, Bhupendra Baraiya Continuum Managed Services, LLC. p: 902-933-0019 e: bhupendra.bara...@continuum.net<mailto:bhupendra.bara...@continuum.net> w: continuum.net [http://cdn2.hubspot.net/hub/281750/file-393087232-png/img/logos/email-continuum-logo-151x26.png]<http://www.continuum.net/> From: Jack Krupansky [mailto:jack.krupan...@gmail.com] Sent: April 06, 2016 7:29 PM To: user@cassandra.apache.org Subject: Re: Cassandra Single Node Setup Questions Generally, regardless of your expected cluster size, you need to perform a proof of concept implementation (POC) to obtain those numbers for your own application. These numbers are not absolute limits enforced by Cassandra, but practical limits based on your actual data model, actual data patterns, and actual access patterns, as well as your actual hardware - RAM, storage (SSD vs. HDD), and network connectivity. And queries drive the data modeling - how do you intend to access the data, latency requirements, and how many concurrent clients do you expect. Generally, Cassandra is chosen for applications which have a lot of data and the need for high availability (redundancy, meaning at least three copies of the data.) Neither of which seems to be your requirement. How much data do you have? What led you to believe that you only need a single node? -- Jack Krupansky On Wed, Apr 6, 2016 at 9:44 AM, Bhupendra Baraiya <bhupendra.bara...@continuum.net<mailto:bhupendra.bara...@continuum.net>> wrote: Hi , I had few question related to Single Node Setup in Cassandra 1) We want to install Cassandra but multiple Node is not what we need Can we proceed with Single Node and store millions of data in Single Node only 2) How many Partitions are allowed per Node , that is what is the limit of Partition in single node if exceeded will impact the Performance 3) How many rows allowed per Partition in Single Node Thanks and regards, Bhupendra Baraiya Continuum Managed Services, LLC. p: 902-933-0019 e: bhupendra.bara...@continuum.net<mailto:bhupendra.bara...@continuum.net> w: continuum.net<http://continuum.net> [http://cdn2.hubspot.net/hub/281750/file-393087232-png/img/logos/email-continuum-logo-151x26.png]<http://www.continuum.net/>
Cassandra Single Node Setup Questions
Hi , I had few question related to Single Node Setup in Cassandra 1) We want to install Cassandra but multiple Node is not what we need Can we proceed with Single Node and store millions of data in Single Node only 2) How many Partitions are allowed per Node , that is what is the limit of Partition in single node if exceeded will impact the Performance 3) How many rows allowed per Partition in Single Node Thanks and regards, Bhupendra Baraiya Continuum Managed Services, LLC. p: 902-933-0019 e: bhupendra.bara...@continuum.net<mailto:bhupendra.bara...@continuum.net> w: continuum.net [http://cdn2.hubspot.net/hub/281750/file-393087232-png/img/logos/email-continuum-logo-151x26.png]<http://www.continuum.net/>
Drop and Add column with different datatype in Cassandra
Hi , I am using Cassandra 3.0.4 I am using a Table called User which has a column last_login with Map datatype . I dropped the column using the syntax Alter Table User Drop last_login; I dropped the column from table and recreated it with a nested datatype last_login map<varchar,frozen<tuple<timestamp,inet>>> But then I got an below error InvalidRequest: code=2200 [Invalid query] message="Cannot add a collection with the name last_login because a collection with the same name and a different type (map<text, timestamp>) has already been used in the past" Does it mean Cassandra does not allow adding of the same column in the Table even though it does not exists in the Table Thanks and regards, Bhupendra Baraiya Continuum Managed Services, LLC. p: 902-933-0019 e: bhupendra.bara...@continuum.net<mailto:bhupendra.bara...@continuum.net> w: continuum.net [http://cdn2.hubspot.net/hub/281750/file-393087232-png/img/logos/email-continuum-logo-151x26.png]<http://www.continuum.net/>
RE: Transaction Support in Cassandra
Ok so we will not get what they had developed So what will be the closest Alternative of Transaction in Cassandra Thanks and regards, Bhupendra Baraiya Continuum Managed Services, LLC. p: 902-933-0019 e: bhupendra.bara...@continuum.net<mailto:bhupendra.bara...@continuum.net> w: continuum.net [http://cdn2.hubspot.net/hub/281750/file-393087232-png/img/logos/email-continuum-logo-151x26.png]<http://www.continuum.net/> From: DuyHai Doan [mailto:doanduy...@gmail.com] Sent: March 22, 2016 1:20 PM To: user@cassandra.apache.org Subject: Re: Transaction Support in Cassandra First Ok.ru support for acid transactions is using a complete FORK of Apache Cassandra so people using it need to maintain the fork themselves. Second, as far as I know, they don't intend to publish the source code so it's not really available in the public space either. The reason is that their architecture has been tailored for their own usage and hardware so I 'm not sure it can be adapted for general purpose public usage... Le 22 mars 2016 08:12, "Bhupendra Baraiya" <bhupendra.bara...@continuum.net<mailto:bhupendra.bara...@continuum.net>> a écrit : HI , We are currently thinking of moving from Sql to Cassandra but our major worry here is we have a system which required concurrent 200 connection at time and they do the updates and insert and delete which requires Transaction support When I searched o Google about these what I got is Cassandra support Lightweight Transaction And Quorum consistency is there any other way we can achieve the same Transaction support in Cassandra as available in Ms Sql Server Below is the link where Team had actually build Transaction support in Cassandra same as there is Sql Server is it available to Public (all those who download latest Cassandra) http://www.planetcassandra.org/blog/interview/acid-transactions-with-apache-cassandra-social-network-ok-ru-moves-from-microsoft-sql-to-handle-200m-users/ Thanks and regards, Bhupendra Baraiya Continuum Managed Services, LLC. p: 902-933-0019 e: bhupendra.bara...@continuum.net<mailto:bhupendra.bara...@continuum.net> w: continuum.net<http://continuum.net> [http://cdn2.hubspot.net/hub/281750/file-393087232-png/img/logos/email-continuum-logo-151x26.png]<http://www.continuum.net/>
Transaction Support in Cassandra
HI , We are currently thinking of moving from Sql to Cassandra but our major worry here is we have a system which required concurrent 200 connection at time and they do the updates and insert and delete which requires Transaction support When I searched o Google about these what I got is Cassandra support Lightweight Transaction And Quorum consistency is there any other way we can achieve the same Transaction support in Cassandra as available in Ms Sql Server Below is the link where Team had actually build Transaction support in Cassandra same as there is Sql Server is it available to Public (all those who download latest Cassandra) http://www.planetcassandra.org/blog/interview/acid-transactions-with-apache-cassandra-social-network-ok-ru-moves-from-microsoft-sql-to-handle-200m-users/ Thanks and regards, Bhupendra Baraiya Continuum Managed Services, LLC. p: 902-933-0019 e: bhupendra.bara...@continuum.net<mailto:bhupendra.bara...@continuum.net> w: continuum.net [http://cdn2.hubspot.net/hub/281750/file-393087232-png/img/logos/email-continuum-logo-151x26.png]<http://www.continuum.net/>